poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53985] FileNotFoundException: no such entry: "Workbook" while reading data from Excel file
Date Tue, 16 Apr 2013 10:18:48 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53985

Szymon Wilkołazki <wilkolazki@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|3.8                         |3.9
                 OS|All                         |Windows 7

--- Comment #2 from Szymon Wilkołazki <wilkolazki@gmail.com> ---
Hi,

I have the same issue. I have two different excel files from which cannot be
read. Both have the "Book" entry and do not have "Workbook". If I open them  in
Excel 2007 and 'save as => excel 97-2003', then the files successfully open in
POI. 

I have altered my code to try to read 'Book' entry instead of 'Workbook'. Both
files produce following exception: 


org.springframework.web.util.NestedServletException: Request processing failed;
nested exception is org.apache.poi.hssf.record.RecordFormatException: Unable to
construct record instance
   
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894)
   
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
   
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
root cause

org.apache.poi.hssf.record.RecordFormatException: Unable to construct record
instance
   
org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:65)
   
org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:301)
   
org.apache.poi.hssf.record.RecordFactoryInputStream$StreamEncryptionInfo.<init>(RecordFactoryInputStream.java:65)
   
org.apache.poi.hssf.record.RecordFactoryInputStream.<init>(RecordFactoryInputStream.java:182)
   
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:139)
   
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:106)
   
pl.veracomp.service.SpreadsheetImportService.process(SpreadsheetImportService.java:369)
    pl.veracomp.controller.uploadController.onSubmit(uploadController.java:57)
   
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:272)
   
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:268)
   
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
   
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
   
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
   
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
   
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
   
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
   
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
root cause

org.apache.poi.hssf.record.RecordFormatException: Not enough data (0) to read
requested (2) bytes
   
org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:216)
   
org.apache.poi.hssf.record.RecordInputStream.readShort(RecordInputStream.java:233)
   
org.apache.poi.hssf.record.InterfaceHdrRecord.<init>(InterfaceHdrRecord.java:43)
    sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
   
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    java.lang.reflect.Constructor.newInstance(Constructor.java:513)
   
org.apache.poi.hssf.record.RecordFactory$ReflectionConstructorRecordCreator.create(RecordFactory.java:57)
   
org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:301)
   
org.apache.poi.hssf.record.RecordFactoryInputStream$StreamEncryptionInfo.<init>(RecordFactoryInputStream.java:65)
   
org.apache.poi.hssf.record.RecordFactoryInputStream.<init>(RecordFactoryInputStream.java:182)
   
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:139)
   
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:106)
   
pl.veracomp.service.SpreadsheetImportService.process(SpreadsheetImportService.java:369)
    pl.veracomp.controller.uploadController.onSubmit(uploadController.java:57)
   
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:272)
   
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:268)
   
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
   
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
   
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
   
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
   
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
   
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
   
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)


Unfortunatelly I cannot attach the files. They contain confidential data, which
I cannot remove without correcting the files. 

Any ideas? How can I help resolve this issue?

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message