使用模板导出excel文件
@GetMapping("/export")
public void export(String startTime, String endTime,
final HttpServletResponse response) throws Exception {
List<EventStaticResponse> eventStaticResponses = eventStaticService.queryEventStaticByType(startTime, endTime);
String fileName = "事件统计数据.xlsx";
ClassPathResource classPathResource = new ClassPathResource("事件统计数据.xlsx");
ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).withTemplate(classPathResource.getStream()).registerWriteHandler(new CustomCellWriteHandler(0,new int[]{0})).build();
WriteSheet writeSheet = EasyExcel.writerSheet().build();
FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
excelWriter.fill(eventStaticResponses, fillConfig, writeSheet);
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
response.setHeader("content-Type", "application/octet-stream");
excelWriter.finish();
}