public String exportAll(HttpServletResponse response,String id) throws IOException { List<HSSFWorkbook> workbookList = new ArrayList<HSSFWorkbook>(); HSSFWorkbook sheets = this.exportNotice(response); HSSFWorkbook sheets1 = xcBaseInfoService.exportTiKu(response); HSSFWorkbook exportxcjh = xcPlanService.exportxcjh(response); HSSFWorkbook exportmzcp = mzcpService.exportmzcp(response); workbookList.add(sheets); workbookList.add(sheets1); workbookList.add(exportxcjh); workbookList.add(exportmzcp); response.setContentType("application/zip"); response.addHeader("Content-Disposition", "attachment; filename=\"" + URLEncoder.encode("lzsj.zip", "UTF-8")); ZipArchiveOutputStream zipOutputStream = new ZipArchiveOutputStream(response.getOutputStream()); for (int i = 0; i < workbookList.size(); i++) { String excelName = null; if(i == 0){ excelName = "巡察公告数据"; } if(i == 1){ excelName = "题库数据"; } if(i == 2){ excelName = "巡察计划数据"; } if(i == 3){ excelName = "民主测评数据"; } ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(); zipOutputStream.putArchiveEntry(new ZipArchiveEntry(excelName + ".xls")); workbookList.get(i).write(byteArrayOutputStream); InputStream is = new ByteArrayInputStream(byteArrayOutputStream.toByteArray()); IOUtils.copy(is, zipOutputStream); zipOutputStream.closeArchiveEntry(); } zipOutputStream.close(); return "导出成功"; }
Java Excel多文件导出压缩包
最新推荐文章于 2023-06-10 20:14:35 发布