Bug 48445

Summary: Unable to read entire block; 202 bytes read; expected 512 bytes
Product: POI Reporter: Karthik <ckarthiks>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WONTFIX    
Severity: blocker    
Priority: P2    
Version: 1.5.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Karthik 2009-12-26 00:08:44 UTC
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.
Comment 1 David Fisher 2009-12-27 08:22:13 UTC
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/