hutool 自定义excel_hutool导出excel工具和例子

1.导入依赖

cn.hutool

hutool-all

5.3.7

2.代码示例

2.1controller层

@PostMapping(value = "/exportPaperExcel")

public void exportExcel(HttpServletResponse response, @RequestBody SysExcelPaperDTO sysExcelPaperDTO) throws Exception{

if (CollUtil.isEmpty(sysExcelPaperDTO.getCols())){

throw new ExamServerException("导出列不可为空");

}

Map map = MapUtil.of("paperid", "试卷编号");

map.put("papername", "试卷名称");

map.put("papertype", "试卷类型");

map.put("starttime", "开始时间");

map.put("endtime", "结束时间");

map.put("username", "创建人");

FileUtil.exportExcel(response,sysExcelPaperDTO.getCols(),map,syssPaperManageService.exportExcel(sysExcelPaperDTO));

}

2.1.1传入的参数

@Data