使用模板导出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();}
