easypoi版本——3.1.0
实现代码
public void export(HttpServletResponse response, HttpServletRequest request, ModelMap modelMap) {
try {
String fileName = "批量导出.zip";
response.setContentType("application/octet-stream ");
response.setHeader("Connection", "close"); // 表示不能用浏览器直接打开
response.setHeader("Accept-Ranges", "bytes");// 告诉客户端允许断点续传多线程连接下载
response.setHeader("Content-Disposition",
"attachment;filename=" + new String(fileName.getBytes("GB2312"), "ISO8859-1"));
response.setCharacterEncoding("UTF-8");
OutputStream out = response.getOutputStream();
ZipOutputStream zos = new ZipOutputStream(out);
//读取路径下的模板
TemplateExportParams params = new TemplateExportParams("导出模板.xlsx");
//获取业务数据逻辑
L