I am trying to read an excel file using POI 2.0 (used 1.5 also) , but I get the following error: java.lang.Exception: java.io.IOException: Unable to read entire block; 202 bytes read; expected 512 bytes at csmip.EvpnExcelParser.displayFromExcel(Unknown Source) at csmip.EvpnExcelParser.importExcel(Unknown Source) at _jsps._mds._evpn_excel_import_jsp._jspService(_evpn_excel_import_jsp.java:130) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at com.iplanet.ias.web.jsp.JspServlet$JspServletWrapper.service(JspServlet.java:687) at com.iplanet.ias.web.jsp.JspServlet.serviceJspFile(JspServlet.java:459) at com.iplanet.ias.web.jsp.JspServlet.service(JspServlet.java:375) at javax.servlet.http.HttpServlet.service(HttpServlet.java:908) at org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrapperValve.java:771) at org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.java:118) at org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.java:293) at java.security.AccessController.doPrivileged(Native Method) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:289) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:509) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:509) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:209) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:509) at com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java:157) at com.iplanet.ias.web.WebContainer.service(WebContainer.java:579) It is a web based application where i have to read an excel file. EvpnExcelParser is my own class which uses displayExcel() method to read the xls file. Excel file version is 2002 /2003 piece of code: Hint: xlsPath contains path to the excel file InputStream inputStream = new FileInputStream (xlsPath); POIFSFileSystem fileSystem = null; fileSystem = new POIFSFileSystem (inputStream); HSSFWorkbook workBook = new HSSFWorkbook (fileSystem); HSSFSheet sheet = workBook.getSheetAt (0); Please help me as soon as possible.
Without the file there is nothing to test. I doubt very much that any active developer will patch 1.5.1 for this bug, 1.5.1 was released in August of 2003. Of course you are free to look at the source. It is here: http://archive.apache.org/dist/jakarta/poi/release/src/