If you can, the first thing to do would be to update to the current version of the API as both of those you are using are quite old now. It could very well be that the problem you are experiencing was reported and addressed in the time between version 2.0 and 3.6 and if it has, the advice can only and will be to upgrade I suspect. However, if you cannot do this for some reason - and I would strongly advise that you do - can you attach the problematic file please so that the developers can look into the issue?
Mark B thikkar wrote: > > 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-tp26925822p26925944.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]
