easyexcel结合zip 导出压缩文件(包含多个excel)

easyexcel结合zip 导出压缩文件(包含多个excel)

直接上代码… 分批次查询处理示例代码

 		 int limit = 1;
        int pageNum = 500;
        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        ZipOutputStream out = new ZipOutputStream(bos);
        try {
            while (true) {
                params.put("limit", limit);
                params.put("pageNum", pageNum);
                List<GoodsSpecExportExcel> excelList = goodsSpecService.findSkuListByParams(params);
           
                ByteArrayOutputStream out1 = new ByteArrayOutputStream();
                EasyExcel.write(out1, GoodsSpecExportExcel.class).sheet().doWrite(excelList);
                out1.close();
                out.putNextEntry(new ZipEntry(System.currentTimeMillis() + ".xls"));
                byte[] excelStream = out1.toByteArray();
                out.write(excelStream);
                limit++;
                     if (excelList.size()<500) {
                    break;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            out.close();
            bos.close();
        }