springboot中使用poi导出excel文件，下载简易模板（根据对象实体类生成表头）

柔情只为你懂 2024-04-01 12:07 53阅读 0赞

#### pom依赖 ####

<dependency>
                <groupId>cn.afterturn</groupId>
                <artifactId>easypoi-spring-boot-starter</artifactId>
                <version>4.4.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>4.1.0</version>
            </dependency>

#### 完成代码 ####

@ApiOperation("下载模板")
        @GetMapping("/downloadTemplate")
        public void downloadTemplate(HttpServletResponse response){
        
    
            Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("标题名", "sheet名"), Check.class, new ArrayList<Check>());
            try {
        
                response.setContentType("application/vnd.ms-excel");
                String fileName = URLEncoder.encode("文件名.xlsx", "UTF-8");
                response.setHeader("Content-disposition", "attachment;filename=" + fileName + ";" + "filename*=utf-8''" + fileName);
                // 服务端要在header设置Access-Control-Expose-Headers, 前端才能正常获取到
                response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
                OutputStream output = response.getOutputStream();
                workbook.write(output);
                output.flush();
                output.close();
                workbook.close();
            } catch (IOException e) {
        
                e.printStackTrace();
            }
        }

#### Check实体类中使用 **@Excel** 注解标注即可 ####

![在这里插入图片描述][8c00bd2aa119457494c06c97eb0346fa.png]

[8c00bd2aa119457494c06c97eb0346fa.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/01/f8c3c3e7faad41d88ca9a9d9bb5c995e.png