EasyExcel写入多个sheet,每个sheet写多个表
下面是实现代码:
public static void main(String[] args) {
ExcelWriter excelWriter = null;
try {
excelWriter = EasyExcel.write("C:\\Users\\curry.s\\Desktop\\ssssss.xlsx").build();
for (int i = 0; i < 5; i++) {
WriteSheet writeSheet = EasyExcel.writerSheet("sheetName" + i)
.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
.needHead(Boolean.FALSE)
.build();
WriteTable accountInfo = EasyExcel.writerTable(0)
.head(AccountExcelDTO.class)
.needHead(Boolean.TRUE)
.build();
WriteTable tweetInfo = EasyExcel.writerTable(1)
.head(TweetExcelDTO.class)
.needHead(Boolean.TRUE)
.build();
List<AccountExcelDTO> accountExcelDTOS = new ArrayList<>();
accountExcelDTOS.add(new AccountExcelDTO());
List<TweetExcelDTO> tweetExcelDTOS = new ArrayList<>();
tweetExcelDTOS.add(new TweetExcelDTO());
excelWriter.write(accountExcelDTOS, writeSheet, accountInfo);
excelWriter.write(tweetExcelDTOS, writeSheet, tweetInfo);
}
} finally {
if (excelWriter != null) {
excelWriter.finish();
}
}
}
ojbk