SpringBoot 导出多个Excel文件，压缩成.zip格式下载

转x33g5p2x  于2022-07-20 转载在 Spring  
字(8.4k)|赞(0)|评价(0)|浏览(943)

前言

之前写过一篇极其简单的excel导入导出，是单个文件的：
Springboot 最简单的结合MYSQL数据实现EXCEL表格导出及数据导入_小目标青年的博客-CSDN博客

还有指定模板的： 

Springboot 指定自定义模板导出Excel文件_小目标青年的博客-CSDN博客

今天有人问到，多个文件导出，放到zip压缩包里面怎么搞？

不多说，开搞。

正文 

三步：

  1. 引入 核心依赖

  2. 复制粘贴已经给你们写好的工具类

  3. 送一步，自测看效果

第一步，引依赖

  1. <!-- 导入和导出-->
  2. <dependency>
  3.     <groupId>cn.afterturn</groupId>
  4.     <artifactId>easypoi-base</artifactId>
  5.     <version>3.0.3</version>
  6. </dependency>
  7. <dependency>
  8.     <groupId>cn.afterturn</groupId>
  9.     <artifactId>easypoi-web</artifactId>
  10.     <version>3.0.3</version>
  11. </dependency>
  12. <dependency>
  13.     <groupId>cn.afterturn</groupId>
  14.     <artifactId>easypoi-annotation</artifactId>
  15.     <version>3.0.3</version>
  16. </dependency>

第二步，加工具类

ExcelUtil.java

  1. import cn.afterturn.easypoi.excel.ExcelExportUtil;
  2. import cn.afterturn.easypoi.excel.entity.ExportParams;
  3. import org.apache.poi.ss.usermodel.Workbook;
  4. import javax.servlet.http.HttpServletResponse;
  5. import java.io.ByteArrayOutputStream;
  6. import java.io.IOException;
  7. import java.net.URLEncoder;
  8. import java.util.List;
  10. /**
  11.  * @Author: JCccc
  12.  * @Date: 2022-7-13 16:02
  13.  * @Description: excel工具类
  14.  */
  15. public class ExcelUtil {
  17.     /**
  18.      * 导出
  19.      * @param list
  20.      * @param title
  21.      * @param sheetName
  22.      * @param pojoClass
  23.      * @param fileName
  24.      * @param response
  25.      */
  26.     public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, HttpServletResponse response) {
  27.         defaultExport(list, pojoClass, fileName, response, new ExportParams(title, sheetName));
  28.     }
  30.     /**
  31.      * 导出excle转换成 bytes
  32.      * @param list
  33.      * @param title
  34.      * @param sheetName
  35.      * @param pojoClass
  36.      * @param fileName
  37.      * @param response
  38.      * @return
  39.      * @throws IOException
  40.      */
  41.     public static byte[] getExportExcelBytes(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, HttpServletResponse response) throws IOException {
  42.         Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(title, sheetName), pojoClass, list);
  43.         ByteArrayOutputStream os = new ByteArrayOutputStream();
  44.         workbook.write(os);
  45.         return os.toByteArray();
  46.     }
  48.     private static void defaultExport(List<?> list, Class<?> pojoClass, String fileName, HttpServletResponse response, ExportParams exportParams) {
  49.         Workbook workbook = ExcelExportUtil.exportExcel(exportParams, pojoClass, list);
  50.         downLoadExcel(fileName, response, workbook);
  51.     }
  52.     private static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {
  53.         try {
  54.             response.setCharacterEncoding("UTF-8");
  55.             response.setHeader("content-Type", "application/vnd.ms-excel");
  56.             response.setHeader("Content-Disposition",
  57.                     "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
  58.             workbook.write(response.getOutputStream());
  59.         } catch (IOException e) {
  60.             throw new RuntimeException(e.getMessage());
  61.         }
  62.     }
  64. }

ZipUtils.java

  1. import java.io.*;
  2. import java.util.List;
  3. import java.util.Map;
  4. import java.util.Objects;
  5. import java.util.zip.ZipEntry;
  6. import java.util.zip.ZipOutputStream;
  7. import static org.springframework.util.StreamUtils.BUFFER_SIZE;
  9. /**
  10.  * @Author: JCccc
  11.  * @Date: 2022-7-13 16:02
  12.  * @Description: zip工具类
  13.  */
  14. public class ZipUtils {
  16.     /**
  17.      * 传入文件file
  18.      * @param outputStream
  19.      * @param fileList
  20.      */
  21.     public static void downloadZipForFiles(OutputStream outputStream, List<File> fileList){
  23.         ZipOutputStream zipOutputStream = null;
  24.         try {
  25.             zipOutputStream = new ZipOutputStream(outputStream);
  26.             for (File file : fileList) {
  27.                 ZipEntry zipEntry = new ZipEntry(file.getName());
  28.                 zipOutputStream.putNextEntry(zipEntry);
  29.                 byte[] buf = new byte[BUFFER_SIZE];
  30.                 int len;
  31.                 FileInputStream in = new FileInputStream(file);
  32.                 while ((len = in.read(buf)) != -1) {
  33.                     zipOutputStream.write(buf, 0, len);
  34.                     zipOutputStream.flush();
  35.                 }
  36.             }
  37.             zipOutputStream.flush();
  38.             zipOutputStream.close();
  40.         } catch (IOException e) {
  41.             e.printStackTrace();
  42.         } finally {
  43.             // 关闭流
  44.             try {
  45.                 if (zipOutputStream != null ) {
  46.                     zipOutputStream.close();
  47.                 }
  48.                 if (outputStream != null) {
  49.                     outputStream.close();
  50.                 }
  51.             } catch (IOException e) {
  52.                 e.printStackTrace();
  53.             }
  54.         }
  56.     }
  58.     /**
  59.      * 传入文件的 byte[]
  60.      * Map<String,byte[]> fileBufMap key是文件名（包含后缀），value是文件的byte[]
  61.      * @param outputStream
  62.      * @param fileBufMap
  63.      */
  64.     public static void downloadZipForByteMore(OutputStream outputStream,Map<String,byte[]> fileBufMap)  {
  66.             ZipOutputStream zipOutputStream = null;
  67.             try {
  68.                 zipOutputStream = new ZipOutputStream(outputStream);
  69.                 for (String fileName:fileBufMap.keySet()){
  70.                     ZipEntry zipEntry = new ZipEntry(fileName);
  71.                     zipOutputStream.putNextEntry(zipEntry);
  72.                     if (Objects.nonNull(fileBufMap.get(fileName))){
  73.                         byte[] fileBytes = fileBufMap.get(fileName);
  74.                         zipOutputStream.write(fileBytes);
  75.                         zipOutputStream.flush();
  76.                     }
  77.                 }
  78.                 zipOutputStream.flush();
  79.                 zipOutputStream.close();
  81.             } catch (IOException e) {
  82.                 e.printStackTrace();
  83.             }finally {
  84.                 // 关闭流
  85.                 try {
  86.                     if (zipOutputStream != null ) {
  87.                         zipOutputStream.close();
  88.                     }
  89.                     if (outputStream != null) {
  90.                         outputStream.close();
  91.                     }
  92.                 } catch (IOException e) {
  93.                     e.printStackTrace();
  94.                 }
  95.             }
  96.     }
  98.     /**
  99.      * 返回zip包的 byte[]
  100.      *
  101.      * @param fileBufMap
  102.      * @return
  103.      */
  105.     public static byte[] getZipForByteMore(Map<String,byte[]> fileBufMap)  {
  106.         ByteArrayOutputStream totalZipBytes = null;
  107.         ZipOutputStream zipOutputStream = null;
  108.         try {
  109.             totalZipBytes = new ByteArrayOutputStream();
  110.             zipOutputStream = new ZipOutputStream(totalZipBytes);
  111.             for (String fileName:fileBufMap.keySet()){
  112.                 ZipEntry zipEntry = new ZipEntry(fileName);
  113.                 zipOutputStream.putNextEntry(zipEntry);
  114.                 if (Objects.nonNull(fileBufMap.get(fileName))){
  115.                     byte[] fileBytes = fileBufMap.get(fileName);
  116.                     zipOutputStream.write(fileBytes);
  117.                     zipOutputStream.flush();
  118.                 }
  119.             }
  120.             zipOutputStream.close();
  121.             byte[] bytes = totalZipBytes.toByteArray();
  122.             totalZipBytes.close();// 关闭流
  123.             return bytes;
  124.         } catch (IOException e) {
  125.             e.printStackTrace();
  126.         } finally {
  127.             // 关闭流
  128.             try {
  129.                 if (totalZipBytes != null) {
  130.                     totalZipBytes.close();
  131.                 }
  132.                 if (zipOutputStream != null) {
  133.                     zipOutputStream.close();
  134.                 }
  136.             } catch (IOException e) {
  137.                 e.printStackTrace();
  138.             }
  139.         }
  140.         return null;
  141.     }
  143. }

第三步，使用工具类，看看效果

回顾一下，单个excel导出，写过使用场景接口：
 

  1. @RequestMapping("exportUserExcel")
  2.     public void exportUserExcel(HttpServletResponse response){
  3.        // List<User> userList = userService.queryUserInfo();
  4.         List<User> userList=new ArrayList<>();
  5.         User user1=new User(1,"a","12");
  6.         User user2=new User(1,"b","12");
  7.         User user3=new User(1,"c","12");
  8.         userList.add(user1);
  9.         userList.add(user2);
  10.         userList.add(user3);
  11.         //导出操作
  12.         ExcelUtil.exportExcel(userList,"用户信息","sheet1",User.class,"users.xls",response);
  13.     }

调用一下：

多个文件导出，zip方式下载：

① 已经知道存在的文件路径

接口使用代码： 

  1. /**
  2.      * 将指定文件打包成zip并下载
  3.      */
  4.     @RequestMapping("exportExcelZipWithFile")
  5.     public void exportExcelZipWithFile(HttpServletResponse response) throws IOException {
  6.         // 这里还是和上面一样
  7.         String[] filePath = new String[]{"D:\\ziptest\\11.xls", "D:\\ziptest\\22.xls"};
  8.         List<File> fileList = new ArrayList<>();
  9.         for (String s : filePath) {
  10.             File file = new File(s);
  11.             fileList.add(file);
  12.         }
  13.         response.setHeader("content-type", "application/octet-stream");
  14.         response.setContentType("application/octet-stream");
  15.         response.setHeader(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=configDetail.zip");
  16.         ZipUtils.downloadZipForFiles(response.getOutputStream(), fileList);
  17.     }

效果：

②直接生成excel，转换成byte再导出zip

  1. /**
  2.      * 将excel文件的Byte[]打包成zip并下载
  3.      */
  4.     @RequestMapping("exportExcelZipWithByte")
  5.     public void exportExcelZipWithByte(HttpServletResponse response) throws IOException {
  7.         Map<String,byte[]> fileBufMap=new HashMap<>();
  9.         List<Account> accountList=new ArrayList<>();
  10.         Account account1=new Account(1,"1234");
  11.         Account account2=new Account(2,"12222");
  12.         Account account3=new Account(3,"1431546");
  13.         accountList.add(account1);
  14.         accountList.add(account2);
  15.         accountList.add(account3);
  16.         //导出操作 1
  17.         byte[] exportAccountExcelBytes = ExcelUtil.getExportExcelBytes(accountList, "账号信息", "sheet1", Account.class, "accounts.xls", response);
  19.         List<User> userList=new ArrayList<>();
  20.         User user1=new User(1,"a","12");
  21.         User user2=new User(1,"b","12");
  22.         User user3=new User(1,"c","12");
  23.         userList.add(user1);
  24.         userList.add(user2);
  25.         userList.add(user3);
  26.         //导出操作
  27.         byte[] exportUserExcelBytes =   ExcelUtil.getExportExcelBytes(userList,"用户信息","sheet1",User.class,"users.xls",response);
  29.         fileBufMap.put("accounts.xls",exportAccountExcelBytes);
  30.         fileBufMap.put("users.xls",exportUserExcelBytes);
  32.         response.setHeader("content-type", "application/octet-stream");
  33.         response.setContentType("application/octet-stream");
  34.         response.setHeader(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=configDetail.zip");
  35.         ZipUtils.downloadZipForByteMore(response.getOutputStream(), fileBufMap);
  36.     }

代码简析：

这个map，key 是zip压缩包里面的文件名， vlaue是 excel文件的字节流： 

生成excel文件，我们直接返回 byte[]流:

把多份excel文件的byte[] 都丢到map里面：

把每一个excel文件的 byte[]都放入 zip流：

实现效果：

好吧，该篇就到这。

版权说明 : 本文为转载文章, 版权归原作者所有 版权申明

原文链接 : https://blog.csdn.net/qq_35387940/article/details/125790362

内容来源于网络，如有侵权，请联系作者删除！

Javaexcelspringbootzip导出多份

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com