EasyExcel写入多Sheet页

EasyExcel写入多Sheet页

接到一个需求是按照城市分组将同一城市的数据写入到一个Sheet页中

ExcelWriter excelWriter = EasyExcel.write("/Users/zhanghe/Desktop/user/temp/all.xls", AllocationExcel.class)
        .build();
int sheetNo = 0;
for(long locationId : locationIdList){
    WriteSheet sheet = EasyExcel.writerSheet(sheetNo, locationName).build();
  sheetNo++;
  // 填充数据
  excelWriter.write(allocationExcelList,sheet);
}
// 一定要所有的sheet页都写完在finish，finish代表整个Excel写数据完成
excelWriter.finish();