Java导出多个excel压缩成zip下载

LookingNorth

已于 2022-10-08 22:00:23 修改

阅读量1k

点赞数 2

分类专栏：工作学习文章标签： java servlet 开发语言

于 2022-10-08 17:36:48 首次发布

本文链接：https://blog.csdn.net/LookingNorth/article/details/127212833

版权

工作学习专栏收录该内容

10 篇文章 0 订阅

订阅专栏

Java导出多个excel压缩成zip下载

maven

		<!--hutoos工具类根据需要可以导入不同的模块，我这里是导入全部的模块-->
		<dependency>
			<groupId>cn.hutool</groupId>
			<artifactId>hutool-all</artifactId>
			<version>5.8.8</version>
		</dependency>
		<!--poi对excel2007以上版本的支持-->
		<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>4.1.2</version>
		</dependency>

代码


    @SneakyThrows
    @GetMapping("downloads1")
    public void downloads1(HttpServletResponse response){
        // 压缩包名称
        String zipFileName = "student.zip";
        ServletOutputStream servletOutputStream = response.getOutputStream();
        try (ZipOutputStream zipOutputStream = new ZipOutputStream(servletOutputStream)) {

            for (int i = 0; i < 2; i++) {
                Map<String, Object> row1 = new LinkedHashMap<>();
                row1.put("姓名", "张三");
                row1.put("年龄", 23);
                row1.put("成绩", 88.32);
                row1.put("是否合格", true);
                row1.put("考试日期", DateUtil.date());

                Map<String, Object> row2 = new LinkedHashMap<>();
                row2.put("姓名", "李四");
                row2.put("年龄", 33);
                row2.put("成绩", 59.50);
                row2.put("是否合格", false);
                row2.put("考试日期", DateUtil.date());

                ArrayList<Map<String, Object>> rows = CollUtil.newArrayList(row1, row2);

                // 通过工具类创建writer
                ExcelWriter writer = ExcelUtil.getWriter();
                // 合并单元格后的标题行，使用默认标题样式
                writer.merge(row1.size() - 1, "一班成绩单" + i);
                // 写表格数据
                writer.write(rows);

                ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
                // 把Excel刷入输出流
                writer.flush(byteArrayOutputStream);
                // 设置ZipEntry名称（这里等于excel名称）
                zipOutputStream.putNextEntry(new ZipEntry("ExcelName" + i + ".xls"));
                // 将输入流转换成压缩ZipEntry
                zipOutputStream.write(byteArrayOutputStream.toByteArray());
                zipOutputStream.flush();
                // 关闭writer，释放内存
                writer.close();
                zipOutputStream.closeEntry();
            }
            //response为HttpServletResponse对象
            response.setContentType("application/vnd.ms-excel;charset=utf-8");
            //test.xls是弹出下载对话框的文件名，不能为中文，中文请自行编码
            response.setHeader("Content-Disposition", "attachment;filename=test.xls");

            response.setContentType("text/html; charset=UTF-8");
            response.setContentType("application/octet-stream");
            response.setHeader("Content-Disposition", "attachment;filename=".concat(String.valueOf(URLEncoder.encode(zipFileName, "UTF-8"))));
        }
        servletOutputStream.close();
    }