1、效果如图
2、Controller
@GetMapping("/exportExcel")public void exportExcel(@RequestParam(value = "menu") String menu,
@RequestParam(value= "dwflglId") intdwflglId,
@RequestParam(value= "qjCode") String qjCode,
HttpServletResponse response)throwsIOException {//内容集合
List jthz =getJthz(dwflglId, qjCode);//表头集合
List header =getHeaderOfHz(dwflglId, qjCode);
response.setHeader("Content-Disposition", "attachment; filename=Zjlryshz.xlsx");//响应类型,编码
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
String bigTitle= "资金流入预算表";
EasyExcel.write(response.getOutputStream()).head(getExcelHeader(header, bigTitle)).registerWriteHandler(new Custemhandler()).sheet("资金流入预算导出模板