java导出excel并压缩

1. /** 
2.  * 导出支付宝批量支付文件excel 
3.  *  
4.  * @param name 
5.  * @param begintime 
6.  * @param endtime 
7.  * @param p 
8.  * @param l 
9.  * @param k 
10.  * @param request 
11.  * @param response 
12.  */  
13. @RequestMapping("exportApplyBatchExcel")  
14. public void exportApplyBatchExcel(String name, String begintime, String endtime, Integer p, Integer l, String k,  
15.         HttpServletRequest request, HttpServletResponse response) {  
16.     // if (auth.getCurrentUserId(k) == null) {  
17.     // ResponseUtil.json(JsonUtil.toString(GenericResponses.TOKEN_LOSE),  
18.     // response);  
19.     // return;  
20.     // }  
21.     // 逐页查询数据,将所有数据导出到excel表中(注:此方法中不传p,l参数,使用的是service层中,默认的第1页开始,每页显示50条)  
22.     Integer pp = 1;  
23.     Long tt = 1l;  
24.     String[] headers = { "批次号", "付款日期", "付款人email", "账户名称", "总金额(元)", "总笔数" };  
25.     OutputStream out = null;  
26.     while (true) {  
27.         pp++;  
28.         // 查询数据库  
29.         ListResponse<?> listResponse = this.finApi.selectApplyBatch(name, begintime, endtime, p, l, k);  
30.         // 获取总页数  
31.         Long total = listResponse.getTotal();  
32.         if (tt > 0) {  
33.             tt = total - pp;  
34.         } else {  
35.             break;  
36.         }  
37.         // 获取查询结果,数据列表  
38.         Object result = listResponse.getResult();  
39.         // 类型转换  
40.         if (result != null) {  
41.             List<ApplyBatchMXVo> applyBatchMXVos = JsonUtil.readJsonList(JsonUtil.toString(result),  
42.                     ApplyBatchMXVo.class);  
43.             // 导出  
44.             try {  
45.                 // 设置导出excel文件  
46.                 out = response.getOutputStream();  
47.                 ZipOutputStream zipOutputStream = new ZipOutputStream(out);  
48.                 String fileName = "批量支付文件" + ".zip";  
49.                 response.setContentType("application/octet-stream ");  
50.                 response.setHeader("Connection", "close"); // 表示不能用浏览器直接打开  
51.                 response.setHeader("Accept-Ranges", "bytes");// 告诉客户端允许断点续传多线程连接下载  
52.                 response.setHeader("Content-Disposition",  
53.                         "attachment;filename=" + new String(fileName.getBytes("GB2312"), "ISO8859-1"));  
54.                 response.setCharacterEncoding("UTF-8");  
55.                 // 遍历填充数据  
56.                 for (ApplyBatchMXVo vo : applyBatchMXVos) {  
57.                     List<List<Object>> datas = new ArrayList<>();  
58.                     List<Object> data = new ArrayList<>();  
59.                     data.add(vo.getId());// 批次号  
60.                     data.add(vo.getCreateTime());// 付款时间  
61.                     data.add(vo.getPayAccount());// 付款人email  
62.                     data.add(vo.getPayName());// 账户名称  
63.                     data.add(vo.getTotalCost());// 总金额(元)  
64.                     data.add(vo.getTotalCount());// 总笔数  
65.                     datas.add(data);  
66.                     List<Object> data2 = new ArrayList<>();  
67.                     // 插入第二行表头  
68.                     data2.add("商户流水号");// 商户流水号  
69.                     data2.add("收款人email");// 收款人email  
70.                     data2.add("收款人姓名");// 收款人姓名  
71.                     data2.add("付款金额(元)");// 付款金额(元)  
72.                     data2.add("付款理由");// 付款理由  
73.                     datas.add(data2);  
74.                     for (ApplyMoneyMXVo amvo : vo.getApplyMoneyMXVos()) {  
75.                         List<Object> data3 = new ArrayList<>();  
76.                         data3.add(amvo.getApplyNo());// 商户流水号  
77.                         data3.add(amvo.getUserAccount());// 收款人email  
78.                         data3.add(amvo.getUserName());// 收款人姓名  
79.                         data3.add(amvo.getMoney());// 付款金额(元)  
80.                         data3.add(amvo.getPayCase());// 付款理由  
81.                         datas.add(data3);  
82.                     }  
83.                     // 导出文件zip压缩设置  
84.                     Workbook book = GenerateXmlUtil.generateCreateXsl(headers, datas, "批量支付文件");  
85.                     ZipEntry entry = new ZipEntry(vo.getId() + ".xls");  
86.                     zipOutputStream.putNextEntry(entry);  
87.                     book.write(zipOutputStream);  
88.                 }  
89.                 // 关闭输出流  
90.                 zipOutputStream.flush();  
91.                 zipOutputStream.close();  
92.             } catch (Exception e) {  
93.                 e.printStackTrace();  
94.                 ResponseUtil.text(TraceUtil.trace(e), response);  
95.             }  
96.         }  
97.         // 重新设置分页参数  
98.         p = pp;  
99.     }  
100. } 

文章来源: aaaedu.blog.csdn.net，作者：tea_year，版权归原作者所有，如需转载，请联系作者。

原文链接：aaaedu.blog.csdn.net/article/details/77531177