导入更新报错

Psyius · 发表于 2021-5-26 11:30:45

本帖最后由 Psyius 于 2021-5-26 11:33 编辑

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.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.invokeAction(Native Method)
      at com.justep.system.action.Engine.invokeAction(Unknown Source)
      at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
      at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
      at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:121)
      at Excel.importExcel(Excel.java:91)
      ... 27 more
Caused by: java.lang.ClassCastException: org.apache.poi.xssf.usermodel.XSSFWorkbook cannot be cast to org.apache.poi.ss.usermodel.Workbook
      at PatentRegisterProcess.patentRegisterProcessAfterImportExcelBeforeAction(PatentRegisterProcess.java:167)
      ... 37 more

Psyius · 发表于 2021-5-26 11:31:45

本帖最后由 Psyius 于 2021-5-26 13:44 编辑

1.excel文件格式03和07的都报错
2.按照https://docs.wex5.com/bex5-ui-question-list-10262/都已经弄好，还是有问题。3.jar包啥的都导入了，import导入了

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;