Spring Boot 配置EasyExcel实现Excel文件导出

ゞ浴缸里的玫瑰 2023-01-14 13:59 144阅读 0赞

### 1 EasyExcel ###

EasyExcel是一个基于Java的简单、省内存的读写Excel的开源项目。在尽可能节约内存的情况下支持读写百M的Excel。

### 2 pom.xml（Maven配置文件） ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>2.1.6</version>
            </dependency>

### 3 EasyExcelController ###

package com.controller;
    
    import com.alibaba.excel.EasyExcel;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import javax.servlet.ServletOutputStream;
    import javax.servlet.http.HttpServletResponse;
    import java.util.ArrayList;
    import java.util.Arrays;
    import java.util.List;
    
    @RestController
    public class EasyExcelController {
        /**
         * 导出excel文件
         *
         * @param response
         */
        @GetMapping("/export")
        public void export(HttpServletResponse response) {
            try {
                List<List<Object>> dataList = new ArrayList<>();
                List<Object> headList = new ArrayList<>(Arrays.asList(new Object[]{"表头1", "表头2", "表头3"}));
                dataList.add(headList);
                String fileName = URLEncoder.encode("文件名称.xlsx", "UTF-8");
                response.addHeader("Content-Disposition", "attachment;filename=" + fileName);
                //设置类型，扩展名为.xls
                response.setContentType("application/vnd.ms-excel");
                ServletOutputStream out = response.getOutputStream();
                EasyExcel.write(out,null).sheet("sheet1").doWrite(dataList);
                response.flushBuffer();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

### 4 调试结果  ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

![20210420213436447.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: /images/20221022/f5b899fa447e4d96aca35ea628e87ed4.png
[20210420213436447.png]: /images/20221022/be0eb3dfaaa8430da6dd54c52d0346be.png