SpringBoot基于EasyExecl实现Execl模板导出

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

@PostMapping("/exportById/{id}")
    public void exportById(HttpServletResponse response, @PathVariable("id") Long id)
    {
        DishesInfo item=dishesInfoService.selectTdById(id);;  //假装有数据
        Map<String,Object> itemMap= BeanUtil.beanToMap(item);
        List<Map<String,Object>> data=new ArrayList(1);
        data.add(itemMap);
        try (ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).withTemplate(config.getTemplatePath()+"/template.xlsx").build()) {
            WriteSheet writeSheet = EasyExcel.writerSheet().build();
            excelWriter.fill(data, writeSheet);
           
            excelWriter.finish();
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");

        } catch (IOException e) {
            e.printStackTrace();
        }
    }

1
2

Workbook workbook = excelWriter.writeContext().writeWorkbookHolder().getWorkbook();
workbook.setForceFormulaRecalculation(true);