java.lang.ClassCastException: org.apache.poi.hssf.usermodel.HSSFWo...

qbyytec

excel 导入执行到下面这行代码总报错，按照 http://bbs.wex5.com/forum.php?mo ... p;extra=&page=1
做的都检查好几遍了，到底什么原因呢，设置了源码路径，改java文件也没有错误提示。 有点着急，麻烦帮忙看看到底什么问题？

Workbook workBook = (Workbook)ModelUtils.getRequestContext().getActionContext().getParameter("excel");


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:88)
        ... 27 more
Caused by: java.lang.ClassCastException: org.apache.poi.hssf.usermodel.HSSFWorkbook cannot be cast to org.apache.poi.ss.usermodel.Workbook
        at Sipo.sipoProcessAfterImportExcelBeforeAction(Sipo.java:37)
        ... 37 more

jishuang

确认import时导入的类正确吗？
http://bbs.wex5.com/forum.php?mo ... 1&pid=165341164

qbyytec

是正确的，检查好几遍了

qbyytec

好像发现问题原因了，把文件建在 process/bb 下面没问题， 把文件建在 process/cc/aa  下面就出现了上面的报错问题，怎么整啊？目录是根据项目业务层次建的文件夹分类，全都放在process根目录下就没有业务层次了。再说平台也支持在process下面建多层文件夹啊，怎么到了导入就出现这种错误问题？

jishuang

把文件建在 process/cc/aa  下面就出现了上面的报错问题
model.config.xml中引用的正确吗？

qbyytec

你给我远程看一下吧，着急呢

jishuang

先确认引用是否正确

qbyytec

还需要再引什么？

jishuang

你好楼主，该问题需要远程，已经通过技术服务QQ加你为好友了，请及时通过，我们会尽快QQ远程。