java - org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file while trying to read a .csv file using poi -


info: server startup in 1778 ms org.apache.poi.openxml4j.exceptions.invalidoperationexception: can't open specified file: 'c:\users\raj\appdata\local\temp\poifiles\poi-ooxml--2049907849.tmp' @ org.apache.poi.openxml4j.opc.zippackage.(zippackage.java:102) @ org.apache.poi.openxml4j.opc.opcpackage.open(opcpackage.java:199) @ org.apache.poi.openxml4j.opc.opcpackage.open(opcpackage.java:178) @ org.apache.poi.util.packagehelper.open(packagehelper.java:53) @ org.apache.poi.xssf.usermodel.xssfworkbook.(xssfworkbook.java:155) @ com.web.controller.excelreader.processuploadedfile(excelreader.java:83) @ com.web.controller.excelreader.dopost(excelreader.java:68) @ javax.servlet.http.httpservlet.service(httpservlet.java:641) @ javax.servlet.http.httpservlet.service(httpservlet.java:722) @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:305) @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:210) @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:225) @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:169) @ org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:472) @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:168) @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:98) @ org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:927) @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:118) @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:407) @ org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:999) @ org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:565) @ org.apache.tomcat.util.net.jioendpoint$socketprocessor.run(jioendpoint.java:309) @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1110) @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:603) @ java.lang.thread.run(thread.java:722)

apache poi can read excel .xls (via hssf) , excel .xslx (via xssf). cannot open csv files

to work csv files, you'll need use library. alternately, if save file .xls or .xlsx, can use apache poi process it.


Comments