栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

easyexcel导出非固定的表头的zip上传至oss报错Destroy object failed问题探讨

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

easyexcel导出非固定的表头的zip上传至oss报错Destroy object failed问题探讨

依赖情况:

            
                com.alibaba
                easyexcel
                2.2.6
            
            
                org.apache.poi
                poi
                4.1.2
            
        
            org.apache.poi
            poi-ooxml-schemas
            4.1.2
        
        
            org.apache.poi
            poi-ooxml
            4.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  不知道什么原因,求大神帮看看

再次感谢大神,补充解决问题的代码图片:

 

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/978038.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号