导出excel

1949阅读　0评论2012-02-03　yl1003
分类：系统运维

首先在页面上设置导出excel的按钮，代码如下：
  1. <input type="button" value=" 导 出 excel " class="button" onFocus="this.blur();" onclick="toExcel()">

  3. //导出excel
  4.     function toExcel(){
  5.         
  6.         location.href = "<%=request.getContextPath()%>/checkedman.do?operFlag=export";

  8.     }
此处使用的是struts1，在action中处理业务。具体代码如下：
  1. //此处为判断转向
  2. if("export".equals(operFlag)) {
  3.             forward = exportData(request, response);
  4. //下面是exportData方法
  5. public String exportData(HttpServletRequest request,
  6.             HttpServletResponse response) {
  7.         //通过BO层找到获取查询的list
  8.         ArrayList<CheckedmanPO> list = CheckedmanBO.exportExcel(request, response);
  9.         
  10.         if (list == null || list.size() <= 0) {

  12.         } else {
  13.             //HttpServletResponse response = FacesUtils.getServletResponse();
  14.             String msg = "";
  15.             response.reset();
  16.             OutputStream os = null;
  17.             try {
  18.                 os = response.getOutputStream();

  20.             } catch (IOException e1) {
  21.                 msg = e1.getMessage();
  22.             }

  24.             response.setContentType("application/vnd.ms-excel;charset=utf-8");
  25.             response.setCharacterEncoding("utf-8");

  27.             try {
  28.                 response.setHeader("Content-disposition",
  29.                         "attachment; filename="
  30.                                 + new String(
  31.                                         "受检者信息.xls".getBytes(),
  32.                                         "ISO8859_1"));
  33.             } catch (Exception e1) {
  34.                 // TODO 自动生成 catch 块
  35.                 e1.printStackTrace();
  36.             }

  38.             HSSFWorkbook wb = new HSSFWorkbook();
  39.             HSSFSheet hs = wb.createSheet();
  40.             
  41.                     
  42.             HSSFRow firstRow = hs.createRow(0);
  43.             
  44.             HSSFCell firstCell0 = firstRow.createCell((short) 0);
  45.             HSSFCell firstCell1 = firstRow.createCell((short) 1);
  46.             HSSFCell firstCell2 = firstRow.createCell((short) 2);
  47.             HSSFCell firstCell3 = firstRow.createCell((short) 3);
  48.             HSSFCell firstCell4 = firstRow.createCell((short) 4);
  49.             HSSFCell firstCell5 = firstRow.createCell((short) 5);
  50.             HSSFCell firstCell6 = firstRow.createCell((short) 6);
  51.             HSSFCell firstCell7 = firstRow.createCell((short) 7);
  52.             HSSFCell firstCell8 = firstRow.createCell((short) 8);
  53.             HSSFCell firstCell9 = firstRow.createCell((short) 9);
  54.             HSSFCell firstCell10 = firstRow.createCell((short) 10);
  55.             HSSFCell firstCell11 = firstRow.createCell((short) 11);
  56.             HSSFCell firstCell12 = firstRow.createCell((short) 12);
  57.             //以下代码处理数据的中文乱码
  58.             firstCell0.setEncoding(HSSFCell.ENCODING_UTF_16);
  59.             firstCell1.setEncoding(HSSFCell.ENCODING_UTF_16);
  60.             firstCell2.setEncoding(HSSFCell.ENCODING_UTF_16);
  61.             firstCell3.setEncoding(HSSFCell.ENCODING_UTF_16);
  62.             firstCell4.setEncoding(HSSFCell.ENCODING_UTF_16);
  63.             firstCell5.setEncoding(HSSFCell.ENCODING_UTF_16);
  64.             firstCell6.setEncoding(HSSFCell.ENCODING_UTF_16);
  65.             firstCell7.setEncoding(HSSFCell.ENCODING_UTF_16);
  66.             firstCell8.setEncoding(HSSFCell.ENCODING_UTF_16);
  67.             firstCell9.setEncoding(HSSFCell.ENCODING_UTF_16);
  68.             firstCell10.setEncoding(HSSFCell.ENCODING_UTF_16);
  69.             firstCell11.setEncoding(HSSFCell.ENCODING_UTF_16);
  70.             firstCell12.setEncoding(HSSFCell.ENCODING_UTF_16);
  71.         
  72.             firstCell0.setCellValue("客户姓名");
  73.             firstCell1.setCellValue("性别");
  74.             firstCell2.setCellValue("民族");
  75.             firstCell3.setCellValue("证件类别");
  76.             firstCell4.setCellValue("证件号码");
  77.             firstCell5.setCellValue("出生日期");
  78.             firstCell6.setCellValue("婚姻状况");
  79.             firstCell7.setCellValue("手机号码");
  80.             firstCell8.setCellValue("家族病史");
  81.             firstCell9.setCellValue("个人病史");
  82.             firstCell10.setCellValue("药物过敏史");
  83.             firstCell11.setCellValue("主要体质");
  84.             firstCell12.setCellValue("辨识日期");


  87.             for (int i = 0; i < list.size() ; i++) {
  88.                 HSSFRow oneRow = hs.createRow(i+1);
  89.                 HSSFCell cell0 = oneRow.createCell((short) 0);
  90.                 HSSFCell cell1 = oneRow.createCell((short) 1);
  91.                 HSSFCell cell2 = oneRow.createCell((short) 2);
  92.                 HSSFCell cell3 = oneRow.createCell((short) 3);
  93.                 HSSFCell cell4 = oneRow.createCell((short) 4);
  94.                 HSSFCell cell5 = oneRow.createCell((short) 5);
  95.                 HSSFCell cell6 = oneRow.createCell((short) 6);
  96.                 HSSFCell cell7 = oneRow.createCell((short) 7);
  97.                 HSSFCell cell8 = oneRow.createCell((short) 8);
  98.                 HSSFCell cell9 = oneRow.createCell((short) 9);
  99.                 HSSFCell cell10 = oneRow.createCell((short) 10);
  100.                 HSSFCell cell11 = oneRow.createCell((short) 11);
  101.                 HSSFCell cell12 = oneRow.createCell((short) 12);

  103.                 cell0.setEncoding(HSSFCell.ENCODING_UTF_16);
  104.                 cell1.setEncoding(HSSFCell.ENCODING_UTF_16);
  105.                 cell2.setEncoding(HSSFCell.ENCODING_UTF_16);
  106.                 cell3.setEncoding(HSSFCell.ENCODING_UTF_16);
  107.                 cell4.setEncoding(HSSFCell.ENCODING_UTF_16);
  108.                 cell5.setEncoding(HSSFCell.ENCODING_UTF_16);
  109.                 cell6.setEncoding(HSSFCell.ENCODING_UTF_16);
  110.                 cell7.setEncoding(HSSFCell.ENCODING_UTF_16);
  111.                 cell8.setEncoding(HSSFCell.ENCODING_UTF_16);
  112.                 cell9.setEncoding(HSSFCell.ENCODING_UTF_16);
  113.                 cell10.setEncoding(HSSFCell.ENCODING_UTF_16);
  114.                 cell11.setEncoding(HSSFCell.ENCODING_UTF_16);
  115.                 cell12.setEncoding(HSSFCell.ENCODING_UTF_16);


  118.                 CheckedmanPO po = (CheckedmanPO) list.get(i);

  120.                 cell0.setCellValue(po.getCName());
  121.                 cell1.setCellValue(po.get***());
  122.                 cell2.setCellValue(po.getNationName());
  123.                 cell3.setCellValue(po.getCCardTypeName());
  124.                 cell4.setCellValue(po.getUCardNum());
  125.                 cell5.setCellValue(po.getBirth());
  126.                 cell6.setCellValue(po.getMarriage());
  127.                 cell7.setCellValue(po.getMobileTel());
  128.                 cell8.setCellValue(po.getFamilyIllnessIdList());
  129.                 cell9.setCellValue(po.getIndividualIllnessIdList());
  130.                 cell10.setCellValue(po.getMedicineSensitiveIdList());
  131.                 cell11.setCellValue(po.getMainPhysical());
  132.                 cell12.setCellValue(po.getTestDate());
  133.             }
  134.             try {
  135.                 wb.write(os);
  136.                 os.flush();
  137.                 //FacesContext.getCurrentInstance().responseComplete();
  138.             } catch (IOException e) {
  139.                 msg = msg + e.getMessage();
  140.             }
  141.             if (!"".equals(msg)) {
  142.             }
  143.         }
  144.         return null;
  145.     }
写到此处，导出功能基本已完成。根据不同的情况，获取不同的数据封装进list就可以了。
关于导出excel，这里使用的是jxl。
上一篇：网站小结
下一篇：通过js改变字体大小