导入报错

dh_n

com.justep.excel.ExcelException: 编码: JUSTEP170010; 提示:
        at com.justep.excel.ExcelException.create(ExcelException.java:32)
        at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:318)
        at com.justep.excel.ImportGenerator.setCellsValue(ImportGenerator.java:241)
        at com.justep.excel.ImportGenerator.generateRecord(ImportGenerator.java:206)
        at com.justep.excel.ImportGenerator.generateSheet(ImportGenerator.java:201)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:134)
        at Excel.importExcel(Excel.java:90)
        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 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.NumberFormatException: For input string: " "
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:569)
        at java.lang.Integer.parseInt(Integer.java:615)
        at com.justep.system.transform.SimpleTransform.j(Unknown Source)
        at com.justep.system.transform.SimpleTransform.transToObj(Unknown Source)
        at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:316)
        ... 32 more
2018-01-23 11:49:48 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:\\BeX5_V3.6p\\apache-tomcat\\temp\\324cf018-537d-41fa-baab-576d27f3a1ab.excel.tmp\" mapping-file=\"D:\\BeX5_V3.6p\\apache-tomcat\\temp\\65b38210-8565-467f-9c10-90f7c9cef334.excel.tmp\"><data><concept name=\"ERP_MM_DeliveryPlan\"><relation name=\"ERP_MM_DeliveryPlan\" type=\"String\"/><relation name=\"fActivityFName\" type=\"String\"/><relation name=\"fActivityLabel\" type=\"String\"/><relation name=\"fAttachment\" type=\"String\"/><relation name=\"fBPANo\" type=\"String\"/><relation name=\"fBillStatus\" type=\"String\"/><relation name=\"fBizState\" type=\"String\"/><relation name=\"fBizStateName\" type=\"String\"/><relation name=\"fCARTONNOMEAS\" type=\"String\"/><relation name=\"fCode\" type=\"String\"/><relation name=\"fCountryOfManufacture\" type=\"String\"/><relation name=\"fCountryOfOrigin\" type=\"String\"/><relation name=\"fCureDate\" type=\"Date\"/><relation name=\"fCurrency\" type=\"String\"/><relation name=\"fCurrentActivities\" type=\"String\"/><relation name=\"fCurrentExecutors\" type=\"String\"/><relation name=\"fCustomer\" type=\"String\"/><relation name=\"fCustomerCode\" type=\"String\"/><relation name=\"fCustomerIdentificationStatus\" type=\"String\"/><relation name=\"fDate\" type=\"String\"/><relation name=\"fDateCode\" type=\"String\"/><relation name=\"fDelete\" type=\"String\"/><relation name=\"fDescription\" type=\"String\"/><relation name=\"fDockCode\" type=\"String\"/><relation name=\"fDrawingNo\" type=\"String\"/><relation name=\"fDrawingVersion\" type=\"String\"/><relation name=\"fFAIRSupplied\" type=\"String\"/><relation name=\"fGROSSWEIGHTCTN\" type=\"String\"/><relation name=\"fImportDate\" type=\"Date\"/><relation name=\"fImportName\" type=\"String\"/><relation name=\"fInvoiceNo\" type=\"String\"/><relation name=\"fLine\" type=\"Integer\"/><relation name=\"fLineItem\" type=\"Integer\"/><relation name=\"fLotNo1\" type=\"String\"/><relation name=\"fLotNo2\" type=\"String\"/><relation name=\"fMARKSNo\" type=\"String\"/><relation name=\"fMRD\" type=\"Date\"/><relation name=\"fManufacturingDateCode\" type=\"Date\"/><relation name=\"fMarketConfirmation\" type=\"String\"/><relation name=\"fNETWEIGHTCTN\" type=\"String\"/><relation name=\"fNetDueQuantity\" type=\"Float\"/><relation name=\"fOrderSource\" type=\"String\"/><relation name=\"fOrderStatus\" type=\"String\"/><relation name=\"fOrganName\" type=\"String\"/><relation name=\"fOutboundCode\" type=\"String\"/><relation name=\"fPOItemAuth\" type=\"String\"/><relation name=\"fPackNo\" type=\"String\"/><relation name=\"fPackageCount\" type=\"String\"/><relation name=\"fPartNumber\" type=\"String\"/><relation name=\"fPartRev\" type=\"String\"/><relation name=\"fPreMeasurement\" type=\"Integer\"/><relation name=\"fQty\" type=\"Float\"/><relation name=\"fQtyShipped\" type=\"Float\"/><relation name=\"fQualityTesting\" type=\"String\"/><relation name=\"fReceivedQuantity\" type=\"Float\"/><relation name=\"fRemark\" type=\"String\"/><relation name=\"fRequestedShipDate\" type=\"Date\"/><relation name=\"fShelfLifeExpDate\" type=\"Date\"/><relation name=\"fShipTo\" type=\"String\"/><relation name=\"fShipVia\" type=\"String\"/><relation name=\"fShipment\" type=\"Integer\"/><relation name=\"fState\" type=\"String\"/><relation name=\"fStateName\" type=\"String\"/><relation name=\"fStatus\" type=\"String\"/><relation name=\"fStockNotice\" type=\"String\"/><relation name=\"fSuccessOrError\" type=\"String\"/><relation name=\"fTOTALCTN\" type=\"String\"/><relation name=\"fTOTALGROSSWT\" type=\"String\"/><relation name=\"fTOTALNETWT\" type=\"String\"/><relation name=\"fUnitPrice\" type=\"Float\"/><relation name=\"fUseStatusName\" type=\"String\"/><relation name=\"fWarehouseStock\" type=\"String\"/><relation name=\"version\" type=\"Integer\"/></concept></data></config>"},"createActionParam":{"action":"createERP_MM_DeliveryPlanAction","activity":"mainActivity","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"ERP_MM_DeliveryPlan","idColumnName":"ERP_MM_DeliveryPlan","idColumnType":"String","model":"/erp/marketSys/data","relationAlias":"fActivityFName,fActivityLabel,fAttachment,fBPANo,fBillStatus,fBizState,fBizStateName,fCARTONNOMEAS,fCode,fCountryOfManufacture,fCountryOfOrigin,fCureDate,fCurrency,fCurrentActivities,fCurrentExecutors,fCustomer,fCustomerCode,fCustomerIdentificationStatus,fDate,fDateCode,fDelete,fDescription,fDockCode,fDrawingNo,fDrawingVersion,fFAIRSupplied,fGROSSWEIGHTCTN,fImportDate,fImportName,fInvoiceNo,fLine,fLineItem,fLotNo1,fLotNo2,fMARKSNo,fMRD,fManufacturingDateCode,fMarketConfirmation,fNETWEIGHTCTN,fNetDueQuantity,fOrderSource,fOrderStatus,fOrganName,fOutboundCode,fPOItemAuth,fPackNo,fPackageCount,fPartNumber,fPartRev,fPreMeasurement,fQty,fQtyShipped,fQualityTesting,fReceivedQuantity,fRemark,fRequestedShipDate,fShelfLifeExpDate,fShipTo,fShipVia,fShipment,fState,fStateName,fStatus,fStockNotice,fSuccessOrError,fTOTALCTN,fTOTALGROSSWT,fTOTALNETWT,fUnitPrice,fUseStatusName,fWarehouseStock,version","relationTypes":"String,String,String,String,String,String,String,String,String,String,String,Date,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Date,String,String,Integer,Integer,String,String,String,Date,Date,String,String,Float,String,String,String,String,String,String,String,String,String,Integer,Float,Float,String,Float,String,Date,Date,String,String,Integer,String,String,String,String,String,String,String,String,Float,String,String,Integer","relations":"ERP_MM_DeliveryPlan.fActivityFName,ERP_MM_DeliveryPlan.fActivityLabel,ERP_MM_DeliveryPlan.fAttachment,ERP_MM_DeliveryPlan.fBPANo,ERP_MM_DeliveryPlan.fBillStatus,ERP_MM_DeliveryPlan.fBizState,ERP_MM_DeliveryPlan.fBizStateName,ERP_MM_DeliveryPlan.fCARTONNOMEAS,ERP_MM_DeliveryPlan.fCode,ERP_MM_DeliveryPlan.fCountryOfManufacture,ERP_MM_DeliveryPlan.fCountryOfOrigin,ERP_MM_DeliveryPlan.fCureDate,ERP_MM_DeliveryPlan.fCurrency,ERP_MM_DeliveryPlan.fCurrentActivities,ERP_MM_DeliveryPlan.fCurrentExecutors,ERP_MM_DeliveryPlan.fCustomer,ERP_MM_DeliveryPlan.fCustomerCode,ERP_MM_DeliveryPlan.fCustomerIdentificationStatus,ERP_MM_DeliveryPlan.fDate,ERP_MM_DeliveryPlan.fDateCode,ERP_MM_DeliveryPlan.fDelete,ERP_MM_DeliveryPlan.fDescription,ERP_MM_DeliveryPlan.fDockCode,ERP_MM_DeliveryPlan.fDrawingNo,ERP_MM_DeliveryPlan.fDrawingVersion,ERP_MM_DeliveryPlan.fFAIRSupplied,ERP_MM_DeliveryPlan.fGROSSWEIGHTCTN,ERP_MM_DeliveryPlan.fImportDate,ERP_MM_DeliveryPlan.fImportName,ERP_MM_DeliveryPlan.fInvoiceNo,ERP_MM_DeliveryPlan.fLine,ERP_MM_DeliveryPlan.fLineItem,ERP_MM_DeliveryPlan.fLotNo1,ERP_MM_DeliveryPlan.fLotNo2,ERP_MM_DeliveryPlan.fMARKSNo,ERP_MM_DeliveryPlan.fMRD,ERP_MM_DeliveryPlan.fManufacturingDateCode,ERP_MM_DeliveryPlan.fMarketConfirmation,ERP_MM_DeliveryPlan.fNETWEIGHTCTN,ERP_MM_DeliveryPlan.fNetDueQuantity,ERP_MM_DeliveryPlan.fOrderSource,ERP_MM_DeliveryPlan.fOrderStatus,ERP_MM_DeliveryPlan.fOrganName,ERP_MM_DeliveryPlan.fOutboundCode,ERP_MM_DeliveryPlan.fPOItemAuth,ERP_MM_DeliveryPlan.fPackNo,ERP_MM_DeliveryPlan.fPackageCount,ERP_MM_DeliveryPlan.fPartNumber,ERP_MM_DeliveryPlan.fPartRev,ERP_MM_DeliveryPlan.fPreMeasurement,ERP_MM_DeliveryPlan.fQty,ERP_MM_DeliveryPlan.fQtyShipped,ERP_MM_DeliveryPlan.fQualityTesting,ERP_MM_DeliveryPlan.fReceivedQuantity,ERP_MM_DeliveryPlan.fRemark,ERP_MM_DeliveryPlan.fRequestedShipDate,ERP_MM_DeliveryPlan.fShelfLifeExpDate,ERP_MM_DeliveryPlan.fShipTo,ERP_MM_DeliveryPlan.fShipVia,ERP_MM_DeliveryPlan.fShipment,ERP_MM_DeliveryPlan.fState,ERP_MM_DeliveryPlan.fStateName,ERP_MM_DeliveryPlan.fStatus,ERP_MM_DeliveryPlan.fStockNotice,ERP_MM_DeliveryPlan.fSuccessOrError,ERP_MM_DeliveryPlan.fTOTALCTN,ERP_MM_DeliveryPlan.fTOTALGROSSWT,ERP_MM_DeliveryPlan.fTOTALNETWT,ERP_MM_DeliveryPlan.fUnitPrice,ERP_MM_DeliveryPlan.fUseStatusName,ERP_MM_DeliveryPlan.fWarehouseStock,ERP_MM_DeliveryPlan.version","updateMode":"whereVersion"}}},"process":"/erp/marketSys/process/DeliveyPlan/deliveyPlanProcess"},"saveActionParam":{"action":"saveERP_MM_DeliveryPlanAction","activity":"mainActivity","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"ERP_MM_DeliveryPlan","idColumnName":"ERP_MM_DeliveryPlan","idColumnType":"String","model":"/erp/marketSys/data","relationAlias":"fActivityFName,fActivityLabel,fAttachment,fBPANo,fBillStatus,fBizState,fBizStateName,fCARTONNOMEAS,fCode,fCountryOfManufacture,fCountryOfOrigin,fCureDate,fCurrency,fCurrentActivities,fCurrentExecutors,fCustomer,fCustomerCode,fCustomerIdentificationStatus,fDate,fDateCode,fDelete,fDescription,fDockCode,fDrawingNo,fDrawingVersion,fFAIRSupplied,fGROSSWEIGHTCTN,fImportDate,fImportName,fInvoiceNo,fLine,fLineItem,fLotNo1,fLotNo2,fMARKSNo,fMRD,fManufacturingDateCode,fMarketConfirmation,fNETWEIGHTCTN,fNetDueQuantity,fOrderSource,fOrderStatus,fOrganName,fOutboundCode,fPOItemAuth,fPackNo,fPackageCount,fPartNumber,fPartRev,fPreMeasurement,fQty,fQtyShipped,fQualityTesting,fReceivedQuantity,fRemark,fRequestedShipDate,fShelfLifeExpDate,fShipTo,fShipVia,fShipment,fState,fStateName,fStatus,fStockNotice,fSuccessOrError,fTOTALCTN,fTOTALGROSSWT,fTOTALNETWT,fUnitPrice,fUseStatusName,fWarehouseStock,version","relationTypes":"String,String,String,String,String,String,String,String,String,String,String,Date,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Date,String,String,Integer,Integer,String,String,String,Date,Date,String,String,Float,String,String,String,String,String,String,String,String,String,Integer,Float,Float,String,Float,String,Date,Date,String,String,Integer,String,String,String,String,String,String,String,String,Float,String,String,Integer","relations":"ERP_MM_DeliveryPlan.fActivityFName,ERP_MM_DeliveryPlan.fActivityLabel,ERP_MM_DeliveryPlan.fAttachment,ERP_MM_DeliveryPlan.fBPANo,ERP_MM_DeliveryPlan.fBillStatus,ERP_MM_DeliveryPlan.fBizState,ERP_MM_DeliveryPlan.fBizStateName,ERP_MM_DeliveryPlan.fCARTONNOMEAS,ERP_MM_DeliveryPlan.fCode,ERP_MM_DeliveryPlan.fCountryOfManufacture,ERP_MM_DeliveryPlan.fCountryOfOrigin,ERP_MM_DeliveryPlan.fCureDate,ERP_MM_DeliveryPlan.fCurrency,ERP_MM_DeliveryPlan.fCurrentActivities,ERP_MM_DeliveryPlan.fCurrentExecutors,ERP_MM_DeliveryPlan.fCustomer,ERP_MM_DeliveryPlan.fCustomerCode,ERP_MM_DeliveryPlan.fCustomerIdentificationStatus,ERP_MM_DeliveryPlan.fDate,ERP_MM_DeliveryPlan.fDateCode,ERP_MM_DeliveryPlan.fDelete,ERP_MM_DeliveryPlan.fDescription,ERP_MM_DeliveryPlan.fDockCode,ERP_MM_DeliveryPlan.fDrawingNo,ERP_MM_DeliveryPlan.fDrawingVersion,ERP_MM_DeliveryPlan.fFAIRSupplied,ERP_MM_DeliveryPlan.fGROSSWEIGHTCTN,ERP_MM_DeliveryPlan.fImportDate,ERP_MM_DeliveryPlan.fImportName,ERP_MM_DeliveryPlan.fInvoiceNo,ERP_MM_DeliveryPlan.fLine,ERP_MM_DeliveryPlan.fLineItem,ERP_MM_DeliveryPlan.fLotNo1,ERP_MM_DeliveryPlan.fLotNo2,ERP_MM_DeliveryPlan.fMARKSNo,ERP_MM_DeliveryPlan.fMRD,ERP_MM_DeliveryPlan.fManufacturingDateCode,ERP_MM_DeliveryPlan.fMarketConfirmation,ERP_MM_DeliveryPlan.fNETWEIGHTCTN,ERP_MM_DeliveryPlan.fNetDueQuantity,ERP_MM_DeliveryPlan.fOrderSource,ERP_MM_DeliveryPlan.fOrderStatus,ERP_MM_DeliveryPlan.fOrganName,ERP_MM_DeliveryPlan.fOutboundCode,ERP_MM_DeliveryPlan.fPOItemAuth,ERP_MM_DeliveryPlan.fPackNo,ERP_MM_DeliveryPlan.fPackageCount,ERP_MM_DeliveryPlan.fPartNumber,ERP_MM_DeliveryPlan.fPartRev,ERP_MM_DeliveryPlan.fPreMeasurement,ERP_MM_DeliveryPlan.fQty,ERP_MM_DeliveryPlan.fQtyShipped,ERP_MM_DeliveryPlan.fQualityTesting,ERP_MM_DeliveryPlan.fReceivedQuantity,ERP_MM_DeliveryPlan.fRemark,ERP_MM_DeliveryPlan.fRequestedShipDate,ERP_MM_DeliveryPlan.fShelfLifeExpDate,ERP_MM_DeliveryPlan.fShipTo,ERP_MM_DeliveryPlan.fShipVia,ERP_MM_DeliveryPlan.fShipment,ERP_MM_DeliveryPlan.fState,ERP_MM_DeliveryPlan.fStateName,ERP_MM_DeliveryPlan.fStatus,ERP_MM_DeliveryPlan.fStockNotice,ERP_MM_DeliveryPlan.fSuccessOrError,ERP_MM_DeliveryPlan.fTOTALCTN,ERP_MM_DeliveryPlan.fTOTALGROSSWT,ERP_MM_DeliveryPlan.fTOTALNETWT,ERP_MM_DeliveryPlan.fUnitPrice,ERP_MM_DeliveryPlan.fUseStatusName,ERP_MM_DeliveryPlan.fWarehouseStock,ERP_MM_DeliveryPlan.version","sys.count":1030,"sys.rowid":"ERP_MM_DeliveryPlan","updateMode":"whereVersion"}}},"process":"/erp/marketSys/process/DeliveyPlan/deliveyPlanProcess"}},"process":"/erp/marketSys/process/DeliveyPlan/deliveyPlanProcess"}
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 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.RuntimeException: 导入excel失败!
        at Excel.importExcel(Excel.java:93)
        ... 27 more

jishuang

确认导入的数据跟关系的数据库类型匹配吗

dh_n

匹配，之前导入都没有问题的

jishuang

具体做了什么操作后才报错的？
现在的错误就是给的值不正确

dh_n

结贴，有一个空格。。