导入excel报错

lugangboy

导入excel报错了，昨天还能导进入，今天我加了写字段，就导不进去了，再恢复回来还是导不进去，报这个Cannot get a numeric value from a text cell

1. //控制台错误信息
   
2. 2017-09-07 14:12:41 [Action Time]action执行时间：14ms,/ht/htmanage/process/htRegist/htRegistProcess,mainActivity,uploadImportExcel
   
3. 导入前
   
4. 2017-09-07 14:12:41 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="F:\\qibuX5\\BeX5_V3.6\\apache-tomcat\\temp\\5a3dcc46-5bed-436b-b0e9-a1465fb24c23.excel.tmp" mapping-file="F:\\qibuX5\\BeX5_V3.6\\apache-tomcat\\temp\\3a4f1c0c-dc1f-4852-b509-b2810be6892a.excel.tmp"><data><concept name="HT_info"><relation name="HT_info" type="String"/><relation name="amount" type="Decimal"/><relation name="beginTime" type="Date"/><relation name="businessType" type="String"/><relation name="checkPerson" type="String"/><relation name="checkRemark" type="String"/><relation name="checkResult" type="String"/><relation name="checkState" type="String"/><relation name="checkdate" type="Date"/><relation name="code" type="String"/><relation name="djAttachment" type="Text"/><relation name="djRemark" type="String"/><relation name="endTime" type="Date"/><relation name="fFID" type="String"/><relation name="firstCompany" type="String"/><relation name="incomePrecent" type="Decimal"/><relation name="isEnable" type="String"/><relation name="isImportant" type="String"/><relation name="kjhtcode" type="String"/><relation name="moneyType" type="String"/><relation name="name" type="String"/><relation name="operationType" type="String"/><relation name="phone" type="String"/><relation name="principal" type="String"/><relation name="property" type="String"/><relation name="recordCode" type="String"/><relation name="recordDate" type="DateTime"/><relation name="registrant" type="String"/><relation name="signDate" type="Date"/><relation name="startOrg" type="String"/><relation name="status" type="String"/><relation name="totalIncome" type="Decimal"/><relation name="type1" type="String"/><relation name="type2" type="String"/><relation name="version" type="Integer"/></concept></data></config>"},"createActionParam":{"action":"createHT_infoAction","activity":"mainActivity","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"HT_info","idColumnName":"HT_info","idColumnType":"String","model":"/ht/htmanage/data","relationAlias":"amount,beginTime,businessType,checkPerson,checkRemark,checkResult,checkState,checkdate,code,djAttachment,djRemark,endTime,fFID,firstCompany,incomePrecent,isEnable,isImportant,kjhtcode,moneyType,name,operationType,phone,principal,property,recordCode,recordDate,registrant,signDate,startOrg,status,totalIncome,type1,type2,version","relationTypes":"Decimal,Date,String,String,String,String,String,Date,String,Text,String,Date,String,String,Decimal,String,String,String,String,String,String,String,String,String,String,DateTime,String,Date,String,String,Decimal,String,String,Integer","relations":"HT_info.amount,HT_info.beginTime,HT_info.businessType,HT_info.checkPerson,HT_info.checkRemark,HT_info.checkResult,HT_info.checkState,HT_info.checkdate,HT_info.code,HT_info.djAttachment,HT_info.djRemark,HT_info.endTime,HT_info.fFID,HT_info.firstCompany,HT_info.incomePrecent,HT_info.isEnable,HT_info.isImportant,HT_info.kjhtcode,HT_info.moneyType,HT_info.name,HT_info.operationType,HT_info.phone,HT_info.principal,HT_info.property,HT_info.recordCode,HT_info.recordDate,HT_info.registrant,HT_info.signDate,HT_info.startOrg,HT_info.status,HT_info.totalIncome,HT_info.type1,HT_info.type2,HT_info.version","updateMode":"whereVersion"}}},"process":"/ht/htmanage/process/htRegist/htRegistProcess"}},"process":"/ht/htmanage/process/htRegist/htRegistProcess"}
   
5. java.lang.reflect.InvocationTargetException
   
6.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
7.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
8.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
9.         at java.lang.reflect.Method.invoke(Method.java:497)
   
10.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
11.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
12.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
13.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
14.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
15.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
16.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
17.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
18.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
19.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
20.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
21.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
22.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
23.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
24.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
25.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
26.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
27.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
28.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
29.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
30.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
31.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
32.         at java.lang.Thread.run(Thread.java:745)
    
33. Caused by: java.lang.reflect.InvocationTargetException
    
34.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
35.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
36.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
37.         at java.lang.reflect.Method.invoke(Method.java:497)
    
38.         at com.justep.system.action.Engine.invokeAction(Native Method)
    
39.         at com.justep.system.action.Engine.invokeAction(Unknown Source)
    
40.         at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
    
41.         at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
    
42.         at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:121)
    
43.         at Excel.importExcel(Excel.java:88)
    
44.         ... 27 more
    
45. Caused by: java.lang.IllegalStateException: Cannot get a numeric value from a text cell
    
46.         at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:843)
    
47.         at org.apache.poi.xssf.usermodel.XSSFCell.getNumericCellValue(XSSFCell.java:208)
    
48.         at HtRegistProcess.htRegistProcessAfterImportExcelBeforeAction(HtRegistProcess.java:37)
    
49.         ... 37 more
    

复制代码

jishuang

java中调试看看