public class TableInfo { public String name; public String pkName; public List<Field> fieldList = new ArrayList<>(); //getter/setter }
List<TableInfo> tableInfos = getTableInfos(); //创建参数集合 List<Map<String,Object>> sheetsList = new ArrayList<>() ; for (TableInfo tableInfo : tableInfos) { ExportParams params = new ExportParams() ; // 设置sheet得名称 params.setSheetName(tableInfo.getName()); Map dataMap = new HashMap<>(); dataMap.put("title",params) ;//参数 dataMap.put("entity",Field.class) ;//数据类型 dataMap.put("data",tableInfo.getFieldList());//数据集合 sheetsList.add(dataMap); } Workbook wb=ExcelExportUtil.exportExcel(sheetsList, ExcelType.HSSF);