java使用EasyExcel模板导出并下载

野性酷女 2024-02-21 07:06 18阅读 0赞

### 导语 ###

![c3f718c7dc55488985febfe53339bed7.png][]

![3a9c4592f6f94e7eaf4e0110124b977a.png][]

对于类似这种的不规则excel表格导出，可以使用阿里的EasyExcel开源工具中的模板导出功能实现，只需要在excel文件对应的单元格中挖空，就可以根据任意类中字段的名称自动填入内容到对应的空中，非常方便

### 正片 ###

#### 1:引入依赖 ####

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

#### 2:Controller接口 ####

@PostMapping("/export/{id}")
        @ApiOperation(value = "导出")
        public void export(@PathVariable(value = "id") Long id,HttpServletResponse response) {
            service.export(id,response);
        }

#### 3：Service ####

@Override
        public void export(Long id , HttpServletResponse response){
            //模板路径
            String path="/data/aaa.xlsx";
            //查实体
            AppealVO appeal = getOneDetails(id);
            //导出
            templateExport(path, "目标文件名",appeal,response);
        }
    
        @SneakyThrows
        public static void templateExport(String templatePath,String fileName,Object input, HttpServletResponse response) {
            String suffix=".xlsx";
            if (!fileName.contains(suffix)) {
                fileName += suffix ;
            }
            //设置下载文件名
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            if (ObjectUtil.isNotEmpty(fileName)) {
                fileName = URLEncoder.encode(fileName, StandardCharsets.UTF_8.toString());
                response.setHeader("Content-Disposition", "attachment; filename=\"" + fileName  + "\"; filename*=utf-8''" + fileName);
            }
            response.setCharacterEncoding("utf-8");
    
            // sheet：第0个
            EasyExcel.write(response.getOutputStream()).withTemplate(templatePath).sheet(0).doFill(input);
        }

####  ####

[c3f718c7dc55488985febfe53339bed7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/21/c14da27147124d4da03c488e91bccfff.png
[3a9c4592f6f94e7eaf4e0110124b977a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/21/1df39917f54341f28aaffda63e8cc6d9.png