导入xlsx格式报错：org/dom4j/DocumentException

Mxt8106

5.3.8 版本


org/dom4j/DocumentException
[url=]隐藏详细[/url]
java.lang.reflect.InvocationTargetException 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:497) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NoClassDefFoundError: org/dom4j/DocumentException at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:149) at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:136) at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:54) at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:81) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:220) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63) at com.justep.excel.ImportGenerator.LoadExcel(ImportGenerator.java:65) at com.justep.excel.ImportGenerator.init(ImportGenerator.java:58) at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:109) at Excel.importExcel(Excel.java:91) ... 30 more Caused by: java.lang.ClassNotFoundException: org.dom4j.DocumentException at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ... 40 more

jishuang

看tomcat中完整的错误信息

Mxt8106

2022-02-17 09:11:54 excute stream action, params:{"accept":"application/json","action":"importExcel","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"config":{"@type":"xml","xml":"<config use-default=\"true\" to=\"DB\" excel-file=\"D:\\yjjc\\BeX5_V3.8_slq\\apache-tomcat\\temp\\547872f4-2978-43fa-ba15-71777a7fffa3.excel.tmp\" mapping-file=\"D:\\yjjc\\BeX5_V3.8_slq\\apache-tomcat\\temp\\d15e5af2-f5de-48e7-8b84-8b35d08774f2.excel.tmp\"><data><concept name=\"BF_QXDGL\"><relation name=\"BF_QXDGL\" type=\"String\"/><relation name=\"fBGSQR\" type=\"String\"/><relation name=\"fBGSQRBM\" type=\"String\"/><relation name=\"fBK\" type=\"String\"/><relation name=\"fBTZR\" type=\"String\"/><relation name=\"fBTZRBM\" type=\"String\"/><relation name=\"fBTZRDH\" type=\"String\"/><relation name=\"fDRR\" type=\"String\"/><relation name=\"fDRRBM\" type=\"String\"/><relation name=\"fDRSJ\" type=\"DateTime\"/><relation name=\"fFXBM\" type=\"String\"/><relation name=\"fFXBZ\" type=\"String\"/><relation name=\"fFXR\" type=\"String\"/><relation name=\"fFXRBM\" type=\"String\"/><relation name=\"fFXRQ\" type=\"String\"/><relation name=\"fFXSJ\" type=\"String\"/><relation name=\"fGNWZ\" type=\"String\"/><relation name=\"fGZJSRQ\" type=\"String\"/><relation name=\"fGZJSSJ\" type=\"String\"/><relation name=\"fGZKSRQ\" type=\"String\"/><relation name=\"fGZKSSJ\" type=\"String\"/><relation name=\"fJHJSRQ\" type=\"String\"/><relation name=\"fJHJSSJ\" type=\"String\"/><relation name=\"fJHKSRQ\" type=\"String\"/><relation name=\"fJHKSSJ\" type=\"String\"/><relation name=\"fJXFZRDH\" type=\"String\"/><relation name=\"fJZXT\" type=\"String\"/><relation name=\"fKKSZY\" type=\"String\"/><relation name=\"fQXBW\" type=\"String\"/><relation name=\"fQXDBH\" type=\"String\"/><relation name=\"fQXDLX\" type=\"String\"/><relation name=\"fQXDLXBM\" type=\"String\"/><relation name=\"fQXDZT\" type=\"String\"/><relation name=\"fQXDZTBM\" type=\"String\"/><relation name=\"fQXLX\" type=\"String\"/><relation name=\"fQXLXBM\" type=\"String\"/><relation name=\"fQXMS\" type=\"String\"/><relation name=\"fQXXXWB\" type=\"String\"/><relation name=\"fQXYYWB\" type=\"String\"/><relation name=\"fSB\" type=\"String\"/><relation name=\"fSBZR\" type=\"String\"/><relation name=\"fSLDLX\" type=\"String\"/><relation name=\"fTZR\" type=\"String\"/><relation name=\"fTZRBM\" type=\"String\"/><relation name=\"fTZRQ\" type=\"String\"/><relation name=\"fTZSJ\" type=\"String\"/><relation name=\"fXQFZR\" type=\"String\"/><relation name=\"fXQFZRBM\" type=\"String\"/><relation name=\"fXQMS\" type=\"String\"/><relation name=\"fXQQX\" type=\"String\"/><relation name=\"fYQLX\" type=\"String\"/><relation name=\"fYQZRQ\" type=\"String\"/><relation name=\"fYQZSJ\" type=\"String\"/><relation name=\"fYSQKMS\" type=\"String\"/><relation name=\"fYSR\" type=\"String\"/><relation name=\"fYSRBM\" type=\"String\"/><relation name=\"fYSRQ\" type=\"String\"/><relation name=\"fYSSJ\" type=\"String\"/><relation name=\"fYXYSBZ\" type=\"String\"/><relation name=\"fZRBMJHYZ\" type=\"String\"/><relation name=\"fZRBZ\" type=\"String\"/><relation name=\"version\" type=\"Integer\"/></concept></data></config>"},"createActionParam":{"action":"createBF_QXDGLAction","activity":"stt_QXDGL_Activity","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"BF_QXDGL","idColumnName":"BF_QXDGL","idColumnType":"String","model":"/bfs/yxgl/sbqxfxtj/data","relationAlias":"fBGSQR,fBGSQRBM,fBK,fBTZR,fBTZRBM,fBTZRDH,fDRR,fDRRBM,fDRSJ,fFXBM,fFXBZ,fFXR,fFXRBM,fFXRQ,fFXSJ,fGNWZ,fGZJSRQ,fGZJSSJ,fGZKSRQ,fGZKSSJ,fJHJSRQ,fJHJSSJ,fJHKSRQ,fJHKSSJ,fJXFZRDH,fJZXT,fKKSZY,fQXBW,fQXDBH,fQXDLX,fQXDLXBM,fQXDZT,fQXDZTBM,fQXLX,fQXLXBM,fQXMS,fQXXXWB,fQXYYWB,fSB,fSBZR,fSLDLX,fTZR,fTZRBM,fTZRQ,fTZSJ,fXQFZR,fXQFZRBM,fXQMS,fXQQX,fYQLX,fYQZRQ,fYQZSJ,fYSQKMS,fYSR,fYSRBM,fYSRQ,fYSSJ,fYXYSBZ,fZRBMJHYZ,fZRBZ,version","relationTypes":"String,String,String,String,String,String,String,String,DateTime,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Integer","relations":"BF_QXDGL.fBGSQR,BF_QXDGL.fBGSQRBM,BF_QXDGL.fBK,BF_QXDGL.fBTZR,BF_QXDGL.fBTZRBM,BF_QXDGL.fBTZRDH,BF_QXDGL.fDRR,BF_QXDGL.fDRRBM,BF_QXDGL.fDRSJ,BF_QXDGL.fFXBM,BF_QXDGL.fFXBZ,BF_QXDGL.fFXR,BF_QXDGL.fFXRBM,BF_QXDGL.fFXRQ,BF_QXDGL.fFXSJ,BF_QXDGL.fGNWZ,BF_QXDGL.fGZJSRQ,BF_QXDGL.fGZJSSJ,BF_QXDGL.fGZKSRQ,BF_QXDGL.fGZKSSJ,BF_QXDGL.fJHJSRQ,BF_QXDGL.fJHJSSJ,BF_QXDGL.fJHKSRQ,BF_QXDGL.fJHKSSJ,BF_QXDGL.fJXFZRDH,BF_QXDGL.fJZXT,BF_QXDGL.fKKSZY,BF_QXDGL.fQXBW,BF_QXDGL.fQXDBH,BF_QXDGL.fQXDLX,BF_QXDGL.fQXDLXBM,BF_QXDGL.fQXDZT,BF_QXDGL.fQXDZTBM,BF_QXDGL.fQXLX,BF_QXDGL.fQXLXBM,BF_QXDGL.fQXMS,BF_QXDGL.fQXXXWB,BF_QXDGL.fQXYYWB,BF_QXDGL.fSB,BF_QXDGL.fSBZR,BF_QXDGL.fSLDLX,BF_QXDGL.fTZR,BF_QXDGL.fTZRBM,BF_QXDGL.fTZRQ,BF_QXDGL.fTZSJ,BF_QXDGL.fXQFZR,BF_QXDGL.fXQFZRBM,BF_QXDGL.fXQMS,BF_QXDGL.fXQQX,BF_QXDGL.fYQLX,BF_QXDGL.fYQZRQ,BF_QXDGL.fYQZSJ,BF_QXDGL.fYSQKMS,BF_QXDGL.fYSR,BF_QXDGL.fYSRBM,BF_QXDGL.fYSRQ,BF_QXDGL.fYSSJ,BF_QXDGL.fYXYSBZ,BF_QXDGL.fZRBMJHYZ,BF_QXDGL.fZRBZ,BF_QXDGL.version","updateMode":"whereVersion"}}},"process":"/bfs/yxgl/sbqxfxtj/process/sbqxfxtj/sbqxfxtjProcess"},"saveActionParam":{"action":"saveBF_QXDGLAction","activity":"stt_QXDGL_Activity","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"BF_QXDGL","idColumnName":"BF_QXDGL","idColumnType":"String","model":"/bfs/yxgl/sbqxfxtj/data","relationAlias":"fBGSQR,fBGSQRBM,fBK,fBTZR,fBTZRBM,fBTZRDH,fDRR,fDRRBM,fDRSJ,fFXBM,fFXBZ,fFXR,fFXRBM,fFXRQ,fFXSJ,fGNWZ,fGZJSRQ,fGZJSSJ,fGZKSRQ,fGZKSSJ,fJHJSRQ,fJHJSSJ,fJHKSRQ,fJHKSSJ,fJXFZRDH,fJZXT,fKKSZY,fQXBW,fQXDBH,fQXDLX,fQXDLXBM,fQXDZT,fQXDZTBM,fQXLX,fQXLXBM,fQXMS,fQXXXWB,fQXYYWB,fSB,fSBZR,fSLDLX,fTZR,fTZRBM,fTZRQ,fTZSJ,fXQFZR,fXQFZRBM,fXQMS,fXQQX,fYQLX,fYQZRQ,fYQZSJ,fYSQKMS,fYSR,fYSRBM,fYSRQ,fYSSJ,fYXYSBZ,fZRBMJHYZ,fZRBZ,version","relationTypes":"String,String,String,String,String,String,String,String,DateTime,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Integer","relations":"BF_QXDGL.fBGSQR,BF_QXDGL.fBGSQRBM,BF_QXDGL.fBK,BF_QXDGL.fBTZR,BF_QXDGL.fBTZRBM,BF_QXDGL.fBTZRDH,BF_QXDGL.fDRR,BF_QXDGL.fDRRBM,BF_QXDGL.fDRSJ,BF_QXDGL.fFXBM,BF_QXDGL.fFXBZ,BF_QXDGL.fFXR,BF_QXDGL.fFXRBM,BF_QXDGL.fFXRQ,BF_QXDGL.fFXSJ,BF_QXDGL.fGNWZ,BF_QXDGL.fGZJSRQ,BF_QXDGL.fGZJSSJ,BF_QXDGL.fGZKSRQ,BF_QXDGL.fGZKSSJ,BF_QXDGL.fJHJSRQ,BF_QXDGL.fJHJSSJ,BF_QXDGL.fJHKSRQ,BF_QXDGL.fJHKSSJ,BF_QXDGL.fJXFZRDH,BF_QXDGL.fJZXT,BF_QXDGL.fKKSZY,BF_QXDGL.fQXBW,BF_QXDGL.fQXDBH,BF_QXDGL.fQXDLX,BF_QXDGL.fQXDLXBM,BF_QXDGL.fQXDZT,BF_QXDGL.fQXDZTBM,BF_QXDGL.fQXLX,BF_QXDGL.fQXLXBM,BF_QXDGL.fQXMS,BF_QXDGL.fQXXXWB,BF_QXDGL.fQXYYWB,BF_QXDGL.fSB,BF_QXDGL.fSBZR,BF_QXDGL.fSLDLX,BF_QXDGL.fTZR,BF_QXDGL.fTZRBM,BF_QXDGL.fTZRQ,BF_QXDGL.fTZSJ,BF_QXDGL.fXQFZR,BF_QXDGL.fXQFZRBM,BF_QXDGL.fXQMS,BF_QXDGL.fXQQX,BF_QXDGL.fYQLX,BF_QXDGL.fYQZRQ,BF_QXDGL.fYQZSJ,BF_QXDGL.fYSQKMS,BF_QXDGL.fYSR,BF_QXDGL.fYSRBM,BF_QXDGL.fYSRQ,BF_QXDGL.fYSSJ,BF_QXDGL.fYXYSBZ,BF_QXDGL.fZRBMJHYZ,BF_QXDGL.fZRBZ,BF_QXDGL.version","sys.count":0,"sys.rowid":"BF_QXDGL","updateMode":"whereVersion"}}},"process":"/bfs/yxgl/sbqxfxtj/process/sbqxfxtj/sbqxfxtjProcess"}},"process":"/SA/excel/system/systemProcess"}

Mxt8106

java.lang.reflect.InvocationTargetException
        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:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/dom4j/DocumentException
        at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:149)
        at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:136)
        at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:54)
        at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:81)
        at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:220)
        at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
        at com.justep.excel.ImportGenerator.LoadExcel(ImportGenerator.java:65)
        at com.justep.excel.ImportGenerator.init(ImportGenerator.java:58)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:109)
        at Excel.importExcel(Excel.java:91)
        ... 30 more
Caused by: java.lang.ClassNotFoundException: org.dom4j.DocumentException
        at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        ... 40 more

jishuang

把文件转换为xls后缀的导入看看

Mxt8106

jishuang 发表于 2022-2-25 10:39
把文件转换为xls后缀的导入看看

转换为xls后缀没问题，但我看3.3的X5都能导入xlsx的，3.8的反而导入失败

jishuang

同一个文件3.5版本导入没问题？3.8版本就报错吗?应该不会

Mxt8106

jishuang 发表于 2022-3-4 17:23
同一个文件3.5版本导入没问题？3.8版本就报错吗?应该不会

结贴