easyexcel导出实例

官方文档 https://alibaba-easyexcel.github.io/index.html

添加依赖包

 <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.0.5</version>
        </dependency>
         <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.15</version>
        </dependency>

下载失败会返回json

@PostMapping("download")
    public void download(HttpServletResponse response, @RequestBody Map request) throws IOException {
   
        // 这里注意 有同学反应使用swagger 会导致各种问题，请直接用浏览器或者用postman
        try {
   
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding("utf-8");
            // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
            String fileName = URLEncoder.encode("TEST", "UTF-8");
            response.setHeader("Content-disposition"</