永洪社区

标题: Excel数据集上传Excel文件读取失败 [打印本页]

作者: dwx    时间: 2022-5-26 15:59
标题: Excel数据集上传Excel文件读取失败


作者: anna    时间: 2022-5-26 15:59
请问报错是什么?
作者: dwx    时间: 2022-5-26 16:22
anna 发表于 2022-5-26 16:00
请问报错是什么?

[2022-05-26 15:58:23.562] |-[ERROR] |-[d59870e2e84c43fb9ac00750d5084841] |-[admin] |-[g5.sv.qry.req.GetSheetsReq.process0(GetSheetsReq.java:115)] |-[QUERY: [未命名-2<未命名-2>][ErrCode: 0]  Failed to get file sheet!]
java.io.FileNotFoundException: no such entry: "Workbook", had: [EncryptedPackage, EncryptionInfo]
        at org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.java:333) ~[thirds.jar:?]
        at org.apache.poi.poifs.filesystem.DirectoryNode.createDocumentInputStream(DirectoryNode.java:147) ~[thirds.jar:?]
        at org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocumentInputStream(POIFSFileSystem.java:830) ~[thirds.jar:?]
        at g5.qry.excel.impl.XLSFileReader.getAllSheets(XLSFileReader.java:179) ~[product.jar:?]
        at g5.qry.excel.impl.XLSFileReader.getSheetNames(XLSFileReader.java:106) ~[product.jar:?]
        at g5.sv.qry.req.GetSheetsReq.process0(GetSheetsReq.java:112) [product.jar:?]
        at g5.sv.Req.process(Req.java:41) [product.jar:?]
        at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:175) [product.jar:?]
        at g5.sv.qry.QueryProc.procReq(QueryProc.java:141) [product.jar:?]
        at g5.sv.qry.QueryProc.service(QueryProc.java:61) [product.jar:?]
        at g5.sv.ServletHelper.service(ServletHelper.java:101) [product.jar:?]
        at g5.sv.PortalServlet.service(PortalServlet.java:494) [product.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [catalina.jar:9.0.43]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.43]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.43]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.43]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [catalina.jar:9.0.43]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [catalina.jar:9.0.43]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.43]
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [catalina.jar:9.0.43]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.43]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [catalina.jar:9.0.43]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-coyote.jar:9.0.43]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.43]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-coyote.jar:9.0.43]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-coyote.jar:9.0.43]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.43]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.43]
        at java.lang.Thread.run(Thread.java:834) [?:?]
作者: dwx    时间: 2022-5-26 16:26
anna 发表于 2022-5-26 16:00
请问报错是什么?

我知道原因了,因为我的excel表加密了,我取消加密就好了,谢谢
作者: Wang315    时间: 2022-5-26 17:01





欢迎光临 永洪社区 (https://club.yonghongtech.com/) Powered by Discuz! X3.4