poi 导出

Question

 List beanList = mcReportUserService.findList(queryString, values);// .findAll();
             
               // response.setContentType("octets/stream");
                response.setContentType("application/msexcel");// 定义输出类型  
             response.addHeader("Content-Disposition", "attachment;filename=test.xls");             //测试图书             ExportExcel ex = new ExportExcel();
            //  workbook = new HSSFWorkbook();
             String[] headers = {"编号", "时间", "商户名称", "任务类型", "类别", "等级","联系人" ,"职务", "联系方式", "地址", "进度", "后续跟踪方式","下次跟踪时间","备注"};
                       //List<Book> dataset = new ArrayList<Book>();             
    
                OutputStream out = response.getOutputStream();
               // WritableWorkbook 
                HSSFWorkbook   workbook=   ex.exportExcel(headers, beanList, out);               // response.setContentType(getContentType());  
                ServletOutputStream outs = response.getOutputStream();  
                workbook.write(outs);  
                outs.flush();  
//                try {
//                    workbook.write(out);
//                    out.flush();
//                    System.out.println("excel导出成功！");
//                } catch (Exception e) {
//                    // TODO Auto-generated catch block
//                    e.printStackTrace();
//                }

Answer 1

public static void writeExcel(OutputStream out, List<String[]> beanList)
         throws Exception {
      HSSFWorkbook book = new HSSFWorkbook();
      HSSFSheet sheet = book.createSheet(bean.getSheetName());      for(int i = 0; i < beanList.size(); i++) {
            HSSFRow row = sheet.createRow(sheet.getLastRowNum());
            String data = beanList.get(i);            for(int j = 0; j < data.length; j++) {
               HSSFCell cell = row.createCell(j);
               cell.setCellValue(data[j]);
            }
      }      book.write(out);
   }