导出excel功能编写

@PostMapping("/XXX")
public void getXXXX(@RequestBody Param param,HttpServletResponse response) {
List<XXX> voList = xxxService.getxxx(param);
Workbook sheets =ExcelExportUtil.exportExcel(
        new ExportParams("标题(可以为null)", "表格sheet页的名称"), XXX.class, voList);
try {
    String fileName = URLEncoder.encode("表格名称.xlsx", "UTF-8");
    response.setContentType("application/msexcel;charset=utf-8");
    response.setHeader("Content-disposition", "attachment;filename= " + fileName);
    sheets.write(response.getOutputStream());
} catch (IOException e) {
    throw new RuntimeException(e);
}
}

在导出的实体类属性上需要加上对应注解

@Excel(name = "对应表格的字段名称")
private String xxx;