阿里巴巴 easyExcel 遇到的问题_dcxmaozi的博客-CSDN博客

安宇雨 - 随手采集
2021-02-23 18:45:16
随手采集
0000-未整理-等待研究

1、easyExcel pom文件中的 POI 的版本要和 easyExcel 中的POI版本一致

2、异常信息

com.alibaba.excel.exception.ExcelGenerateException: Can not close IO.     at com.alibaba.excel.context.WriteContextImpl.finish(WriteContextImpl.java:369)    at com.alibaba.excel.write.ExcelBuilderImpl.finish(ExcelBuilderImpl.java:95)    at com.alibaba.excel.ExcelWriter.finish(ExcelWriter.java:329)    at com.alibaba.excel.write.builder.ExcelWriterSheetBuilder.doWrite(ExcelWriterSheetBuilder.java:62)    at com.ningpai.order.util.EasyExcelUtils.WriteTest.simpleWrite(WriteTest.java:54)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:498)    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)    at com.intellij.junit4.JUnit45ClassesRequestBuilder$1$1$2$2.runChild(JUnit45ClassesRequestBuilder.java:83)    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:48)    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)    at org.junit.runners.ParentRunner.run(ParentRunner.java:292)    at org.junit.runner.JUnitCore.run(JUnitCore.java:157)    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)    at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)Caused by: java.lang.NoClassDefFoundError: org/w3c/dom/ElementTraversal    at java.lang.ClassLoader.defineClass1(Native Method)    at java.lang.ClassLoader.defineClass(ClassLoader.java:763)    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)    at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)    at java.net.URLClassLoader.access$100(URLClassLoader.java:73)    at java.net.URLClassLoader$1.run(URLClassLoader.java:368)    at java.net.URLClassLoader$1.run(URLClassLoader.java:362)    at java.security.AccessController.doPrivileged(Native Method)    at java.net.URLClassLoader.findClass(URLClassLoader.java:361)    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)    at org.apache.xerces.jaxp.DocumentBuilderImpl.newDocument(Unknown Source)    at org.apache.poi.util.DocumentHelper.createDocument(DocumentHelper.java:160)    at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:126)    at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:559)    at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1539)    at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:227)    at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:929)    at com.alibaba.excel.context.WriteContextImpl.finish(WriteContextImpl.java:330)    ... 25 moreCaused by: java.lang.ClassNotFoundException: org.w3c.dom.ElementTraversal    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)    ... 45 more

原因：项目中pom文件中需要加入 xml-apis 依赖

注意各依赖包的版本

原网址: 访问
创建于: 2021-02-23 18:45:16
目录: default
标签: 无

未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到