excel

  SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");       SimpleDateFormat sdf2 = new SimpleDateFormat("HHmmss");       String date = sdf.format(new Date());       String time = sdf2.format(new Date());    String dirName =this.getServlet().getServletContext().getRealPath("upload/uploadfile") + File.separator;    String fileName = dirName +((Teacher)_request.getSession().getAttribute(Constants.TEACHER)).getJsbh()+"_"+date+"_"+time+".xls";    String fileName1 = "/upload/uploadfile/" + ((Teacher)_request.getSession().getAttribute(Constants.TEACHER)).getJsbh()+"_"+date+"_"+time+".xls";    log.info("v size:"+v.size());      if(v.size()>0){            HSSFWorkbook wb = new HSSFWorkbook();//建立新HSSFWorkbook对象   HSSFSheet sheet = wb.createSheet("sheet1");//建立新的sheet对象   wb.setSheetName(0,"学生体段信息",HSSFWorkbook.ENCODING_UTF_16);     HSSFRow headerRow = sheet.createRow((short)0);//建立新行           String[] array={"xx","bb","cc","dd","ddf","ss","rr","cc"};    for(int k=0;k<array.length;k++) {    HSSFCell csCell = headerRow.createCell((short)k);    csCell.setEncoding(HSSFCell.ENCODING_UTF_16);          csCell.setCellValue(array[k]);          }        String[] array2={"XH","XM","YXMC","BJMC","TYBMC","NJ","CS"};              for(int i=0;i<v.size();i++){      ht = (Hashtable)v.elementAt(i);      /*String nj = (String)ht.get("NJ")==null?"":(String)ht.get("NJ");      String xb = (String)ht.get("XB")==null?"":(String)ht.get("XB");      String qz = (String)ht.get("QZ")==null?"":(String)ht.get("QZ");*/     /* log.info("nj:"+nj);      log.info("xb:"+xb);      log.info("qz:"+qz); */         HSSFRow row = sheet.createRow((short)(i+1));//建立新行              HSSFCell csCell = null;       int m = 0;           //生成序号       csCell = row.createCell((short)m++);       csCell.setEncoding(HSSFCell.ENCODING_UTF_16);       csCell.setCellValue(String.valueOf(i+1));                                              for(int j=0;j<array2.length;j++) {        csCell = row.createCell((short)m++);        csCell.setEncoding(HSSFCell.ENCODING_UTF_16);        //log.info("j:="+j);        String tempValue="";            tempValue = ht.get(array2[j])==null?"":String.valueOf(ht.get(array2[j]));           csCell.setCellValue(tempValue);        }        }            /**放入上传文件存放的数据库表中，用于删除**/    FileOutputStream fileOut=null;   try {    fileOut = new FileOutputStream(fileName);    wb.write(fileOut);        fileOut.close();