poi导出大数据 1000万

1.  @RequestMapping("exportUserToExcel.do")  
2.     public void exportUserToExcel(UserBean userBean,HttpServletRequest request,HttpServletResponse response) throws Exception{  
3.         SXSSFWorkbook wb = new SXSSFWorkbook(5000);//内存中保留 10000 条数据，以免内存溢出，其余写入 硬盘       
4.         int count = userService.getUserExcelCount(userBean);  
5.         int page = (int) Math.ceil(count / 500000)+1;  
6.         for (int i = 1; i <= page; i++) {  
7.             System.out.println(i);  
8.             userBean.setPage(i);  
9.             userBean.setRows(500000);  
10.             userBean.calculate();  
11.             List<UserBean> userList = userService.getUserExcelList(userBean);  
12.             Sheet sheet = wb.createSheet("sheet"+i);   
13.             Row row = sheet.createRow(0);  
14.             Cell cell = row.createCell(0);  
15.             cell.setCellValue("id");  
16.             cell = row.createCell(1);  
17.             cell.setCellValue("员工姓名");  
18.             cell = row.createCell(2);  
19.             cell.setCellValue("员工性别");  
20.             cell = row.createCell(3);  
21.             cell.setCellValue("开号日期");  
22.             cell = row.createCell(4);  
23.             cell.setCellValue("账号");  
24.             cell = row.createCell(5);  
25.             cell.setCellValue("密码");  
26.             cell = row.createCell(6);  
27.             cell.setCellValue("头像");  
28.             cell = row.createCell(7);  
29.             cell.setCellValue("状态");  
30.             cell = row.createCell(8);  
31.             cell.setCellValue("备注");  
32.             for (int j = 0; j < userList.size(); j++) {  
33.                 row = sheet.createRow(j+1);  
34.                 row.createCell(0).setCellValue(userList.get(i).getId());  
35.                 row.createCell(1).setCellValue(userList.get(j).getName());  
36.                 row.createCell(2).setCellValue(userList.get(j).getSex() == 1 ? "男":"女");  
37.                 row.createCell(3).setCellValue(userList.get(j).getRegisTime());  
38.                 row.createCell(4).setCellValue(userList.get(j).getLoginNumer());  
39.                 row.createCell(5).setCellValue(userList.get(j).getPassword());  
40.                 row.createCell(6).setCellValue(userList.get(j).getHeadImg());  
41.                 row.createCell(7).setCellValue(userList.get(j).getStatusName());  
42.                 row.createCell(8).setCellValue(userList.get(j).getRemark());  
43.             }  
44.         }  
45.         FileOutputStream fout = new FileOutputStream("G:\\students.xlsx");    
46.         wb.write(fout);  
47.         System.out.println("完成");  
48.         fout.flush();  
49.         fout.close();  
50.         wb.dispose();  
51.   
52.         FileUtil.downloadFile(request, response,"G:\\students.xlsx","测试.xlsx");  
53.         File file = new File("G:\\students.xlsx");  
54.         file.delete();  
55.     }