excel导入报错

zhangql8

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: com.justep.excel.ExcelException: 编码: JUSTEP170010; 提示:
        at com.justep.excel.ExcelException.create(ExcelException.java:32)
        at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:315)
        at com.justep.excel.ImportGenerator.setCellsValue(ImportGenerator.java:238)
        at com.justep.excel.ImportGenerator.generateRecord(ImportGenerator.java:203)
        at com.justep.excel.ImportGenerator.generateSheet(ImportGenerator.java:198)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:131)
        at Excel.importExcel(Excel.java:91)
        ... 30 more
Caused by: java.lang.NumberFormatException: For input string: "容量"
        at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
        at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
        at java.lang.Double.parseDouble(Double.java:538)
        at com.justep.system.transform.SimpleTransform.h(Unknown Source)
        at com.justep.system.transform.SimpleTransform.transToObj(Unknown Source)
        at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:313)
        ... 35 more

<?xml version="1.0" encoding="UTF-8"?>

<mapping>
  <default-config>
    <sheet all="false" start="1" end="1"/>
    <row all="false" start="2"/>
  </default-config>
  <concept name="LA_SAMPLE">
    <relation name="fSAMPLECODE" value-type="string" cell-number="1"/>
    <relation name="fSAMPLETYPECODE" value-type="string" cell-number="2"/>
    <relation name="fSAMPLETYPE" value-type="string" cell-number="3"/>
    <relation name="fSAMPLEICON" value-type="string" cell-number="4"/>
    <relation name="fINITIALCAPACITY" value-type="float" cell-number="5"/>
    <relation name="fAVAILABLECAPACITY" value-type="float" cell-number="6"/>
    <relation name="fUNIT" value-type="string" cell-number="7"/>
    <relation name="fDONOR" value-type="string" cell-number="8"/>
    <relation name="fBOXCODE" value-type="string" cell-number="9"/>
    <relation name="fROW" value-type="integer" cell-number="10"/>
    <relation name="fCOLUMN" value-type="integer" cell-number="11"/>
    <relation name="fTUBE" value-type="integer" cell-number="12"/>
    <relation name="fPARENTIDS" value-type="string" cell-number="14"/>
  </concept>
</mapping>

容量设置float,导入报错

jishuang

确认是不是导入的时候把表头所在的行也设置在了导入范围内

zhangql8

jishuang 发表于 2019-10-28 08:52
确认是不是导入的时候把表头所在的行也设置在了导入范围内

表头没在导入范围内，设置的是从第二行

jishuang

excel中设置为数值类型的，错误就是导入的数据不正确

zhangql8

jishuang 发表于 2019-10-28 13:27
excel中设置为数值类型的，错误就是导入的数据不正确

关闭