依赖情况:
com.alibaba easyexcel2.2.6 org.apache.poi poi4.1.2 org.apache.poi poi-ooxml-schemas4.1.2 org.apache.poi poi-ooxml4.1.2
伪代码如下:
ByteArrayOutputStream zipos = new ByteArrayOutputStream();
ZipOutputStream out = new ZipOutputStream(zipos);
ByteArrayOutputStream os = new ByteArrayOutputStream();
try{
int i = 0;
for(String key : headMap.keySet()){
ExcelWriter excelWriter = EasyExcel.write().excelType(ExcelTypeEnum.XLS).build();
WriteSheet writeSheet = EasyExcel.writerSheet("sheet0").build();
WriteTable writeTable = EasyExcel.writerTable().head(headMap.get(key)).needHead(Boolean.TRUE).build();
excelWriter.write(map.get(key), writeSheet, writeTable);
String excelName = "a" + i + ".xls";
ZipEntry zipEntry = new ZipEntry(excelName);
out.putNextEntry(zipEntry);
Workbook workbook = excelWriter.writeContext().writeWorkbookHolder().getWorkbook();
workbook.write(out);
}
out.flush();
}catch(Exception e){
log.error(e.getMessage(),e);
}finally{
os.close();
out.close();
zipos.close();
}
ByteArrayInputStream inputStream = new ByteArrayInputStream(zipos.toByteArray());
try{
ossClientUtilByIO.upload2OSS(inputStream, path, fileName);
}catch(Exception e){
log.error(e.getMessage(),e);
}finally{
inputStream.close();
}
代码运行成功,zip下载也成功了,但是在运行一段时间之后的报错:
[Finalizer] WARN c.a.e.ExcelWriter - [finalize,342] - Destroy object failed
com.alibaba.excel.exception.ExcelGenerateException: Can not close IO.
at com.alibaba.excel.context.WriteContextImpl.finish(WriteContextImpl.java:378)
at com.alibaba.excel.write.ExcelBuilderImpl.finish(ExcelBuilderImpl.java:95)
at com.alibaba.excel.ExcelWriter.finish(ExcelWriter.java:329)
at com.alibaba.excel.ExcelWriter.finalize(ExcelWriter.java:340)
at java.lang.System$2.invokeFinalize(System.java:1270)
at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:98)
at java.lang.ref.Finalizer.access$100(Finalizer.java:34)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:210)
Caused by: java.lang.NullPointerException: null
at org.apache.poi.poifs.nio.ByteArrayBackedDataSource.copyTo(ByteArrayBackedDataSource.java:92)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.writeFilesystem(POIFSFileSystem.java:719)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1375)
at com.alibaba.excel.context.WriteContextImpl.finish(WriteContextImpl.java:339)
... 7 common frames omitted
参考了大神的博客使用EasyExcel导出Excel抛异常 Can not close IO_ghimi的博客-CSDN博客_easyexcel invoke抛出异常在使用 EasyExcel 中的遇到的一个异常场景。由于不影响线上,而且抛出的异常比较古怪,所以拖了很久,今天终于找到问题原因了,这里做下总结。Issue1872背景首先说明一下我遇到的异常的场景,我这里主要抛出的异常是[Finalizer] WARN [com.alibaba.excel.ExcelWriter] ExcelWriter.java:342 - [] - Destroy object failedcom.alibaba.excel.exception.ExcelGenerateExhttps://blog.csdn.net/qq_19922839/article/details/124132207也没有解决,困扰较久了。@ghimi 不知道什么原因,求大神帮看看
再次感谢大神,补充解决问题的代码图片:



