exportExcel 导出execlType 为excel2007会出错是哪里问题...?

badnjcf

exportExcel组 导出execlType 为excel2007会出错是哪里问题...?
改回excel2003没问题...然后我查了一下..说 是因为缺少有关xmlbeans的jar
..但是不会弄...如果缺少可是excel2003好的.
找到两个目录有xmlbeans.jar文件..
还下了新版放进去...就是没有用...也有找到相关文档...
请管理员帮忙一下..!~~


2022-06-10 09:54:52 excute stream action, params:{"process":"/SA/excel/system/systemProcess","activity":"mainActivity","executor":"","executeContext":"","actionFlag":"__action_0__","action":"exportExcel","contentType":"json","parameters":{"data":{"userdata":{"relationTypes":"String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String","updateMode":"whereVersion","idColumnDefine":"col0","model":"","relations":"ITEM_NO,UNIT,RFILE_NO,MOH_TRAN_DATE,UNIT_PRICE,CURR_DESC,YOURCOLOR,F_CUST_CODE,CUST_PO,QTY_FREE,MOH_FILE_NO,AMT_AF,AMT_BF,SEQ_NO,ITEM_DESCC,W,ACC_CHECK_FLAG,F_QTY,YOURMODEL,POSEQ_NO","idColumnName":"col0","idColumnType":"String","relationAlias":"ITEM_NO,UNIT,RFILE_NO,MOH_TRAN_DATE,UNIT_PRICE,CURR_DESC,YOURCOLOR,F_CUST_CODE,CUST_PO,QTY_FREE,MOH_FILE_NO,AMT_AF,AMT_BF,SEQ_NO,ITEM_DESCC,W,ACC_CHECK_FLAG,F_QTY,YOURMODEL,POSEQ_NO"},"@type":"table","rows":[]},"excelType":"excel2007","from":"UI","config":{"@type":"xml","xml":"<root><config><show-label>true</show-label><start-row>1</start-row></config><concept><relation metaName=\"F_CUST_CODE\" metaLabel=\"客号\" width=\"\" metaCellNo=\"0\" type=\"String\" excelCellNo=\"1\"/><relation metaName=\"MOH_TRAN_DATE\" metaLabel=\"交易日期\" width=\"\" metaCellNo=\"1\" type=\"String\" excelCellNo=\"2\"/><relation metaName=\"MOH_FILE_NO\" metaLabel=\"发货单号\" width=\"\" metaCellNo=\"2\" type=\"String\" excelCellNo=\"3\"/><relation metaName=\"SEQ_NO\" metaLabel=\"序号\" width=\"\" metaCellNo=\"3\" type=\"String\" excelCellNo=\"4\"/><relation metaName=\"RFILE_NO\" metaLabel=\"订单号\" width=\"\" metaCellNo=\"4\" type=\"String\" excelCellNo=\"5\"/><relation metaName=\"ITEM_NO\" metaLabel=\"物料编码\" width=\"\" metaCellNo=\"5\" type=\"String\" excelCellNo=\"6\"/><relation metaName=\"UNIT\" metaLabel=\"单位\" width=\"\" metaCellNo=\"6\" type=\"String\" excelCellNo=\"7\"/><relation metaName=\"CUST_PO\" metaLabel=\"客PO\" width=\"\" metaCellNo=\"7\" type=\"String\" excelCellNo=\"8\"/><relation metaName=\"POSEQ_NO\" metaLabel=\"订单序号\" width=\"\" metaCellNo=\"8\" type=\"String\" excelCellNo=\"9\"/><relation metaName=\"ITEM_DESCC\" metaLabel=\"物料描述\" width=\"\" metaCellNo=\"9\" type=\"String\" excelCellNo=\"10\"/><relation metaName=\"YOURMODEL\" metaLabel=\"客款\" width=\"\" metaCellNo=\"10\" type=\"String\" excelCellNo=\"11\"/><relation metaName=\"YOURCOLOR\" metaLabel=\"客色\" width=\"\" metaCellNo=\"11\" type=\"String\" excelCellNo=\"12\"/><relation metaName=\"F_QTY\" metaLabel=\"数量\" width=\"\" metaCellNo=\"12\" type=\"String\" excelCellNo=\"13\"/><relation metaName=\"W\" metaLabel=\"重量\" width=\"\" metaCellNo=\"13\" type=\"String\" excelCellNo=\"14\"/><relation metaName=\"UNIT_PRICE\" metaLabel=\"单价\" width=\"\" metaCellNo=\"14\" type=\"String\" excelCellNo=\"15\"/><relation metaName=\"CURR_DESC\" metaLabel=\"币别\" width=\"\" metaCellNo=\"15\" type=\"String\" excelCellNo=\"16\"/><relation metaName=\"QTY_FREE\" metaLabel=\"免费数量\" width=\"\" metaCellNo=\"16\" type=\"String\" excelCellNo=\"17\"/><relation metaName=\"AMT_BF\" metaLabel=\"税前金额\" width=\"\" metaCellNo=\"17\" type=\"String\" excelCellNo=\"18\"/><relation metaName=\"AMT_AF\" metaLabel=\"税后金额\" width=\"\" metaCellNo=\"18\" type=\"String\" excelCellNo=\"19\"/><relation metaName=\"ACC_CHECK_FLAG\" metaLabel=\"审\" width=\"\" metaCellNo=\"19\" type=\"String\" excelCellNo=\"20\"/></concept></root>"}},"accept":"application/json"}
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:741)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
        at com.justep.excel.ExportGenerator.generate(ExportGenerator.java:178)
        at Excel.exportExcel(Excel.java:88)
        ... 40 more
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1358)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1180)
        ... 42 more

jishuang

数据中有什么特殊的吗？是不是数据不支持office2007的

badnjcf

jishuang 发表于 2022-7-6 18:54
数据中有什么特殊的吗？是不是数据不支持office2007的

没有哇...所有的都不能用excel2007..
是不是又跟多租户有关系?因为,我看到一篇好像说跟登录有关.!~

jishuang

放了新版本的之前的版本删除，多个jar不一定加载的就是新的

同样的数据可以用没有配置多租户的环境测试看看