获取sheet表的方法:
private <T> Map<String, Object> getSheetMap(String sheetName, List<T> dataList, Class<T> clazz) {
ExportParams exportParams = new ExportParams();
exportParams.setSheetName(sheetName);
Map<String, Object> sheetMap = new HashMap<>();
sheetMap.put("title", exportParams);
sheetMap.put("entity", clazz);
sheetMap.put("data", dataList);
return sheetMap;
}
导出的数据集合:
List<Map<String, Object>> sheetList = new ArrayList<>();
添加数据:
sheetList.add(getSheetMap("项目", sjxtExportOneBos, SjxtExportOneBo.class));
sheetList.add(getSheetMap("性别", kfxtExportTwoBos, KfxtExportTwoBo.class));
sheetList.add(getSheetMap("年龄", kfxtExportThreeBoList, KfxtExportThreeBo.class));
导出:
Workbook workbook = ExcelExportUtil.exportExcel(sheetList, ExcelType.HSSF);
此处用的是 easypoi 的导出工具类。