|
|
| 版本: |
BeX5V3.2 |
小版本号: |
|
|
|
| 数据库: |
Oracle |
服务器操作系统: |
|
应用服务器: |
|
| 客户端操作系统: |
Windows 7 |
浏览器: |
|
|
|
做的一个excel导入的功能 ，
客户下载模板后，使用wps编辑excel文件后，该EXCEL都无法导入，报的是请求编码错误：200，
同样的文档，经过office打开后，注意是只打开一下，没有保存，在导入的时候，导入了，
同时，在用wps软件打开excel,只是打开一下，在导入的时候，报的是请求编码错误：200，请问这是什么情况啊，
下面是错误说明
2018-02-01 16:26:30 [Action Time]action执行时间：9ms,/rkyOA/cwgl/bmjf/process/jfbx/jfbxProcess,mainActivity,uploadImportExcel
2018-02-01 16:26:30 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=\"UI\" excel-file=\"D:\\developer\\BeX5_V3.2.1_pre\\apache-tomcat\\temp\\b1a2a70c-5fc8-4f2e-8742-e93a0c86af3c.excel.tmp\" mapping-file=\"D:\\developer\\BeX5_V3.2.1_pre\\apache-tomcat\\temp\\e8d13db8-8d22-429c-bc43-e7422f7d65b7.excel.tmp\"><data><concept name=\"T_APP_JFBX_CWBXFORXM_YWLWF\"><relation name=\"F_ACCOUNT\" type=\"String\"/><relation name=\"F_AMOUNT\" type=\"Float\"/><relation name=\"F_BANK\" type=\"String\"/><relation name=\"F_BXID\" type=\"String\"/><relation name=\"F_CODE\" type=\"String\"/><relation name=\"F_CONTENT\" type=\"String\"/><relation name=\"F_IS\" type=\"String\"/><relation name=\"F_ISRED\" type=\"String\"/><relation name=\"F_KM\" type=\"String\"/><relation name=\"F_KSSM\" type=\"String\"/><relation name=\"F_LASTAMOUNT\" type=\"Float\"/><relation name=\"F_NAME\" type=\"String\"/><relation name=\"F_REMARK\" type=\"String\"/><relation name=\"F_TAX\" type=\"Float\"/><relation name=\"F_TYPE\" type=\"String\"/><relation name=\"T_APP_JFBX_CWBXFORXM_YWLWF\" type=\"String\"/><relation name=\"calcCheckBox\" type=\"String\"/><relation name=\"version\" type=\"Integer\"/></concept></data></config>"},"createActionParam":{"action":"createT_APP_JFBX_CWBXFORXM_YWLWFAction","activity":"mainActivity","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"T_APP_JFBX_CWBXFORXM_YWLWF","idColumnName":"T_APP_JFBX_CWBXFORXM_YWLWF","idColumnType":"String","model":"/rkyOA/cwgl/bmjf/data","relationAlias":"F_ACCOUNT,F_AMOUNT,F_BANK,F_BXID,F_CODE,F_CONTENT,F_IS,F_ISRED,F_KM,F_KSSM,F_LASTAMOUNT,F_NAME,F_REMARK,F_TAX,F_TYPE,version","relationTypes":"String,Float,String,String,String,String,String,String,String,String,Float,String,String,Float,String,Integer","relations":"T_APP_JFBX_CWBXFORXM_YWLWF.F_ACCOUNT,T_APP_JFBX_CWBXFORXM_YWLWF.F_AMOUNT,T_APP_JFBX_CWBXFORXM_YWLWF.F_BANK,T_APP_JFBX_CWBXFORXM_YWLWF.F_BXID,T_APP_JFBX_CWBXFORXM_YWLWF.F_CODE,T_APP_JFBX_CWBXFORXM_YWLWF.F_CONTENT,T_APP_JFBX_CWBXFORXM_YWLWF.F_IS,T_APP_JFBX_CWBXFORXM_YWLWF.F_ISRED,T_APP_JFBX_CWBXFORXM_YWLWF.F_KM,T_APP_JFBX_CWBXFORXM_YWLWF.F_KSSM,T_APP_JFBX_CWBXFORXM_YWLWF.F_LASTAMOUNT,T_APP_JFBX_CWBXFORXM_YWLWF.F_NAME,T_APP_JFBX_CWBXFORXM_YWLWF.F_REMARK,T_APP_JFBX_CWBXFORXM_YWLWF.F_TAX,T_APP_JFBX_CWBXFORXM_YWLWF.F_TYPE,T_APP_JFBX_CWBXFORXM_YWLWF.version","updateMode":"whereVersion"}}},"process":"/rkyOA/cwgl/bmjf/process/jfbx/jfbxProcess"}},"process":"/rkyOA/cwgl/bmjf/process/jfbx/jfbxProcess"}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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 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 com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:40)
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: org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
at org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:65)
at org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:300)
at org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.java:270)
at org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:236)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:442)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:263)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:188)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:305)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:286)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)
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:88)
... 28 more
Caused by: java.lang.IllegalArgumentException: Name is too long: 鵝藧剿c3禇 [?a+俸兂6f?藱8懤?0蹾錻餻场?炜?h
#mC?*愅睍鋱Z欆弛瘌6忦=.Ve璳?謁%7O"椛瘃g锎F":`m~蓵4By餾?
at org.apache.poi.hssf.record.WriteAccessRecord.setUsername(WriteAccessRecord.java:104)
at org.apache.poi.hssf.record.WriteAccessRecord.<init>(WriteAccessRecord.java:72)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:57)
... 41 more
|
|
IP卡
狗仔卡
发表于 2018-2-1 16:27:41
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2018-2-1 16:53:21
楼主