一個sheet動態導出、偽代碼，創建填充后的workbook對象

List<Map<String, Object>>list = new ArrayList<Map<String, Object>>();
HashMap<String, Object> map = new HashMap<>();
map.put("name", "小明");
map.put("age", "18");
list1.add(map);
List<ExcelExportEntity> entitys=new ArrayList<>();
entitys.add(new ExcelExportEntity("名字" ,"name"));
entitys.add(new ExcelExportEntity("年齡" ,"age"));
ExportParams exportParams = new ExportParams(null, "sheet1名字");
exportParams.setType(ExcelType.XSSF);
Workbook workbook = ExcelExportUtil.exportExcel(exportParams, entitys, list);

多個sheet動態導出、偽代碼，創建填充后的workbook對象

List<Map<String, Object>> sheet1ListMap= new ArrayList<Map<String, Object>>();List<Map<String, Object>> sheet2ListMap= new ArrayList<Map<String, Object>>();List<ExcelExportEntity> sheet1List=new ArrayList<>();
sheet1List.add(new ExcelExportEntity("名字" ,"name"));
sheet1List.add(new ExcelExportEntity("年齡" ,"age"));List<ExcelExportEntity> sheet2List=new ArrayList<>();
sheet2List.add(new ExcelExportEntity("學號" ,"sno"));
sheet2List.add(new ExcelExportEntity("課程" ,"course"));ExportParams exportParams1 = new ExportParams(null, "sheet1名字");
exportParams1.setType(ExcelType.XSSF);ExportParams exportParams2 = new ExportParams(null, "sheet2名字");
exportParams2.setType(ExcelType.XSSF);Workbook workbook = new XSSFWorkbook();
ExcelExportService service = new ExcelExportService();
// 創建sheet1,執行的先后順序
service.createSheetForMap(workbook, exportParams1, sheet1List, sheet1ListMap);
// 創建sheet2
service.createSheetForMap(workbook, exportParams2, sheet2List, sheet2ListMap);

參考文檔:easy-poi實現動態列(標題)、多sheet導出excel文檔等操作-附完整測試用例