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. -- View this message in context: http://old.nabble.com/Unable-to-read-entire-block--202-bytes-read--expected-512-bytes-tp26925822p26925822.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
