去除代码 忽略最后三列:
//获取数据list
def list = XXService.XX(params)
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
response.setCharacterEncoding("utf-8")
String fileName = URLEncoder.encode("数据统计表(${DateUtil.formatDateTime(new Date())})", "UTF-8").replaceAll("\\+", "%20")
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx")
// 根据用户传入字段 假设我们要忽略
Set<String> excludeColumnFiledNames = new HashSet<String>()
excludeColumnFiledNames.add("\$staticClassInfo")
excludeColumnFiledNames.add("\$staticClassInfo\$")
excludeColumnFiledNames.add("\$callSiteArray")
EasyExcel.write(response.getOutputStream(), ExportExcel.class).excludeColumnFiledNames(excludeColumnFiledNames)
.sheet("统计表").doWrite(planList)