easyexcel怎么设置表头宽度_EasyExcel的不确定表头（根据数据生成表头）的excel导出和二级表头以及设置表头的宽度自适应...

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("资金流入预算导出模板