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

淩亂°似流年 2023-09-28 15:11 151阅读 0赞

# 前言 #

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

还有指定模板的：

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

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

![8e25c90d6d3542feb7dd0096942bc322.png][]

不多说，开搞。

# 正文 #

三步：

1. 引入 核心依赖

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

3. 送一步，自测看效果

## 第一步，引依赖 ##

>     
>     <dependency>
>         <groupId>cn.afterturn</groupId>
>         <artifactId>easypoi-base</artifactId>
>         <version>3.0.3</version>
>     </dependency>
>     <dependency>
>         <groupId>cn.afterturn</groupId>
>         <artifactId>easypoi-web</artifactId>
>         <version>3.0.3</version>
>     </dependency>
>     <dependency>
>         <groupId>cn.afterturn</groupId>
>         <artifactId>easypoi-annotation</artifactId>
>         <version>3.0.3</version>
>     </dependency>

## 第二步，加工具类 ##

ExcelUtil.java

import cn.afterturn.easypoi.excel.ExcelExportUtil;
    import cn.afterturn.easypoi.excel.entity.ExportParams;
    import org.apache.poi.ss.usermodel.Workbook;
    import javax.servlet.http.HttpServletResponse;
    import java.io.ByteArrayOutputStream;
    import java.io.IOException;
    import java.net.URLEncoder;
    import java.util.List;
    
    
    /**
     * @Author: JCccc
     * @Date: 2022-7-13 16:02
     * @Description: excel工具类
     */
    public class ExcelUtil {
    
        /**
         * 导出
         * @param list
         * @param title
         * @param sheetName
         * @param pojoClass
         * @param fileName
         * @param response
         */
        public static void exportExcel(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, HttpServletResponse response) {
            defaultExport(list, pojoClass, fileName, response, new ExportParams(title, sheetName));
        }
    
        /**
         * 导出excle转换成 bytes
         * @param list
         * @param title
         * @param sheetName
         * @param pojoClass
         * @param fileName
         * @param response
         * @return
         * @throws IOException
         */
        public static byte[] getExportExcelBytes(List<?> list, String title, String sheetName, Class<?> pojoClass, String fileName, HttpServletResponse response) throws IOException {
            Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(title, sheetName), pojoClass, list);
            ByteArrayOutputStream os = new ByteArrayOutputStream();
            workbook.write(os);
            return os.toByteArray();
        }
    
        private static void defaultExport(List<?> list, Class<?> pojoClass, String fileName, HttpServletResponse response, ExportParams exportParams) {
            Workbook workbook = ExcelExportUtil.exportExcel(exportParams, pojoClass, list);
            downLoadExcel(fileName, response, workbook);
        }
        private static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {
            try {
                response.setCharacterEncoding("UTF-8");
                response.setHeader("content-Type", "application/vnd.ms-excel");
                response.setHeader("Content-Disposition",
                        "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
                workbook.write(response.getOutputStream());
            } catch (IOException e) {
                throw new RuntimeException(e.getMessage());
            }
        }
    
    }

ZipUtils.java

import java.io.*;
    import java.util.List;
    import java.util.Map;
    import java.util.Objects;
    import java.util.zip.ZipEntry;
    import java.util.zip.ZipOutputStream;
    import static org.springframework.util.StreamUtils.BUFFER_SIZE;
    
    /**
     * @Author: JCccc
     * @Date: 2022-7-13 16:02
     * @Description: zip工具类
     */
    public class ZipUtils {
    
        /**
         * 传入文件file
         * @param outputStream
         * @param fileList
         */
        public static void downloadZipForFiles(OutputStream outputStream, List<File> fileList){
    
            ZipOutputStream zipOutputStream = null;
            try {
                zipOutputStream = new ZipOutputStream(outputStream);
                for (File file : fileList) {
                    ZipEntry zipEntry = new ZipEntry(file.getName());
                    zipOutputStream.putNextEntry(zipEntry);
                    byte[] buf = new byte[BUFFER_SIZE];
                    int len;
                    FileInputStream in = new FileInputStream(file);
                    while ((len = in.read(buf)) != -1) {
                        zipOutputStream.write(buf, 0, len);
                        zipOutputStream.flush();
                    }
                }
                zipOutputStream.flush();
                zipOutputStream.close();
    
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
                // 关闭流
                try {
                    if (zipOutputStream != null ) {
                        zipOutputStream.close();
                    }
                    if (outputStream != null) {
                        outputStream.close();
                    }
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
    
        }
    
        /**
         * 传入文件的 byte[]
         * Map<String,byte[]> fileBufMap key是文件名（包含后缀），value是文件的byte[]
         * @param outputStream
         * @param fileBufMap
         */
        public static void downloadZipForByteMore(OutputStream outputStream,Map<String,byte[]> fileBufMap)  {
    
                ZipOutputStream zipOutputStream = null;
                try {
                    zipOutputStream = new ZipOutputStream(outputStream);
                    for (String fileName:fileBufMap.keySet()){
                        ZipEntry zipEntry = new ZipEntry(fileName);
                        zipOutputStream.putNextEntry(zipEntry);
                        if (Objects.nonNull(fileBufMap.get(fileName))){
                            byte[] fileBytes = fileBufMap.get(fileName);
                            zipOutputStream.write(fileBytes);
                            zipOutputStream.flush();
                        }
                    }
                    zipOutputStream.flush();
                    zipOutputStream.close();
    
                } catch (IOException e) {
                    e.printStackTrace();
                }finally {
                    // 关闭流
                    try {
                        if (zipOutputStream != null ) {
                            zipOutputStream.close();
                        }
                        if (outputStream != null) {
                            outputStream.close();
                        }
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
        }
    
        /**
         * 返回zip包的 byte[]
         *
         * @param fileBufMap
         * @return
         */
    
        public static byte[] getZipForByteMore(Map<String,byte[]> fileBufMap)  {
            ByteArrayOutputStream totalZipBytes = null;
            ZipOutputStream zipOutputStream = null;
            try {
                totalZipBytes = new ByteArrayOutputStream();
                zipOutputStream = new ZipOutputStream(totalZipBytes);
                for (String fileName:fileBufMap.keySet()){
                    ZipEntry zipEntry = new ZipEntry(fileName);
                    zipOutputStream.putNextEntry(zipEntry);
                    if (Objects.nonNull(fileBufMap.get(fileName))){
                        byte[] fileBytes = fileBufMap.get(fileName);
                        zipOutputStream.write(fileBytes);
                        zipOutputStream.flush();
                    }
                }
                zipOutputStream.close();
                byte[] bytes = totalZipBytes.toByteArray();
                totalZipBytes.close();// 关闭流
                return bytes;
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
                // 关闭流
                try {
                    if (totalZipBytes != null) {
                        totalZipBytes.close();
                    }
                    if (zipOutputStream != null) {
                        zipOutputStream.close();
                    }
    
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
            return null;
        }
    
    }

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

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

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

调用一下：  
![a207dd2c626c4458ba7f516e207ce68e.png][]

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

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

![340d411758fb415d935c0496e5ec1f78.png][]

接口使用代码：

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

效果：  
![3000ed7290d0410ca79eedf9a556b005.png][]

![9218893ffb8e4d87b61533e0c3243b60.png][]

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

/**
         * 将excel文件的Byte[]打包成zip并下载
         */
        @RequestMapping("exportExcelZipWithByte")
        public void exportExcelZipWithByte(HttpServletResponse response) throws IOException {
    
            Map<String,byte[]> fileBufMap=new HashMap<>();
    
            List<Account> accountList=new ArrayList<>();
            Account account1=new Account(1,"1234");
            Account account2=new Account(2,"12222");
            Account account3=new Account(3,"1431546");
            accountList.add(account1);
            accountList.add(account2);
            accountList.add(account3);
            //导出操作 1
            byte[] exportAccountExcelBytes = ExcelUtil.getExportExcelBytes(accountList, "账号信息", "sheet1", Account.class, "accounts.xls", response);
    
    
            List<User> userList=new ArrayList<>();
            User user1=new User(1,"a","12");
            User user2=new User(1,"b","12");
            User user3=new User(1,"c","12");
            userList.add(user1);
            userList.add(user2);
            userList.add(user3);
            //导出操作
            byte[] exportUserExcelBytes =   ExcelUtil.getExportExcelBytes(userList,"用户信息","sheet1",User.class,"users.xls",response);
    
    
            fileBufMap.put("accounts.xls",exportAccountExcelBytes);
            fileBufMap.put("users.xls",exportUserExcelBytes);
    
            response.setHeader("content-type", "application/octet-stream");
            response.setContentType("application/octet-stream");
            response.setHeader(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=configDetail.zip");
            ZipUtils.downloadZipForByteMore(response.getOutputStream(), fileBufMap);
        }

代码简析：

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

![50f011086f7b455bb94085876bcd12b4.png][]

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

![523bb891eac6460fa7867db6ff301c4e.png][]

![f30548f27ace4de4b3c25562e56b9dec.png][]

把多份excel文件的byte\[\] 都丢到map里面：  
![9ddd13e6b9ec4923af6f5aed9e0d6f67.png][]

把每一个excel文件的 byte\[\]都放入 zip流：  
![cc96a2da9d1543eea8fcff93083d3be5.png][]

实现效果：  
  
![36e481eb9cac40d9ba6c46cdc42af280.png][]

![7600bb57d5b7448ebf64e82d0b609d27.png][]

好吧，该篇就到这。

[Springboot _MYSQL_EXCEL_-CSDN]: https://blog.csdn.net/qq_35387940/article/details/88967572
[Springboot _Excel_-CSDN]: https://blog.csdn.net/qq_35387940/article/details/125804467
[8e25c90d6d3542feb7dd0096942bc322.png]: https://img-blog.csdnimg.cn/8e25c90d6d3542feb7dd0096942bc322.png
[a207dd2c626c4458ba7f516e207ce68e.png]: https://img-blog.csdnimg.cn/a207dd2c626c4458ba7f516e207ce68e.png
[340d411758fb415d935c0496e5ec1f78.png]: https://img-blog.csdnimg.cn/340d411758fb415d935c0496e5ec1f78.png
[3000ed7290d0410ca79eedf9a556b005.png]: https://img-blog.csdnimg.cn/3000ed7290d0410ca79eedf9a556b005.png
[9218893ffb8e4d87b61533e0c3243b60.png]: https://img-blog.csdnimg.cn/9218893ffb8e4d87b61533e0c3243b60.png
[50f011086f7b455bb94085876bcd12b4.png]: https://img-blog.csdnimg.cn/50f011086f7b455bb94085876bcd12b4.png
[523bb891eac6460fa7867db6ff301c4e.png]: https://img-blog.csdnimg.cn/523bb891eac6460fa7867db6ff301c4e.png
[f30548f27ace4de4b3c25562e56b9dec.png]: https://img-blog.csdnimg.cn/f30548f27ace4de4b3c25562e56b9dec.png
[9ddd13e6b9ec4923af6f5aed9e0d6f67.png]: https://img-blog.csdnimg.cn/9ddd13e6b9ec4923af6f5aed9e0d6f67.png
[cc96a2da9d1543eea8fcff93083d3be5.png]: https://img-blog.csdnimg.cn/cc96a2da9d1543eea8fcff93083d3be5.png
[36e481eb9cac40d9ba6c46cdc42af280.png]: https://img-blog.csdnimg.cn/36e481eb9cac40d9ba6c46cdc42af280.png
[7600bb57d5b7448ebf64e82d0b609d27.png]: https://img-blog.csdnimg.cn/7600bb57d5b7448ebf64e82d0b609d27.png