easypoi 怎么去动态拉取字典表的数据
@Excel(name="性别",replace = { "男_0", "女_1" })
private Integer sex;
数据导出的时候我看了下代码是写死的,并没有从字典表里面查询出对应的name值,如果动态去拉取字典表有什么思路
-
2019-04-15
可以查看一下easypoi,有没有解决方案,如果没,就没办法了
-
2020-07-13
GlobalExcelDictHandler implements IExcelDictHandler
public static void exportExcel(HttpServletResponse response, String fileName, Collection<?> list,
Class<?> pojoClass,ExportParams params) throws IOException {
if(StringUtils.isBlank(fileName)){
//当前日期
fileName = DateUtils.format(new Date());
}
params.setDictHandler(new GlobalExcelDictHandler());
Workbook workbook = ExcelExportUtil.exportExcel(params, pojoClass, list);
response.setCharacterEncoding("UTF-8");
response.setHeader("content-Type", "application/vnd.ms-excel");
response.setHeader("Content-Disposition",
"attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xls");
ServletOutputStream out = response.getOutputStream();
workbook.write(out);
out.flush();
}