poi 3.11版本,最多65536条

需求:点击按钮,下载user数据表中的所有数据到excel中

1.pom坐标

<!-- POI-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.11</version>
        </dependency>

2.controller代码(下载excel)

String filename=new String("客户表.xlsx".getBytes(),"ISO-8859-1");
   response.setHeader("Content-Disposition", "attachment;filename="+filename);
   ServletOutputStream sos = response.getOutputStream();
   HSSFWorkbook book=new HSSFWorkbook();
   HSSFSheet sheet = book.createSheet();
   Workbook wb = new SXSSFWorkbook(100);
   HSSFRow titlerow = sheet.createRow(0);
   //设置标题
   titlerow.createCell(0).setCellValue("编号");
   titlerow.createCell(1).setCellValue("公司名称");
   titlerow.createCell(2).setCellValue("姓名");
   titlerow.createCell(3).setCellValue("部门");
   titlerow.createCell(4).setCellValue("email");
   titlerow.createCell(5).setCellValue("邮政编码");
   titlerow.createCell(6).setCellValue("地址");
   titlerow.createCell(7).setCellValue("次行业");

   List<User> list = $userService().getAll();

   for(int i=0;i<list.size();i++){
      User user = list.get(i);
      HSSFRow datarow = sheet.createRow(i+1);
      datarow.createCell(0).setCellValue(user.getId());
      datarow.createCell(1).setCellValue(user.getCompanyName());
      datarow.createCell(2).setCellValue(user.getName());
      datarow.createCell(3).setCellValue(user.getDept());
      datarow.createCell(4).setCellValue(user.getEmaill());
      datarow.createCell(5).setCellValue(user.getPostalcode());
      datarow.createCell(6).setCellValue(user.getAddress());
      datarow.createCell(7).setCellValue(user.getSecondIndustry());
   }
   book.write(sos);
} catch(Exception e){
   e.printStackTrace();
}

3.前端写一个界面,点击访问此类即可