When trying to read the attached Excel file, I got the following error: java.io.FileNotFoundException: no such entry: "Workbook" at org.apache.poi.poifs.filesystem.DirectoryNode.getEntry (DirectoryNode.java:282) at org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocumentInputStream (POIFSFileSystem.java:356) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:139) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:175)
Created attachment 10186 [details] Very simple Excel file: Only one number in the first cell
Created attachment 10190 [details] 5.0/95 Format
Created attachment 10191 [details] Windows 2002 format
I encountered this same error report when trying to process an Excel spreadsheet, but it appears to be related to what version I save the document as. I'm using Microsoft Excel 2002 (10.4302.4219) SP-2 to create my documents. If I save the document in the default xls format it processes correctly. However, if I save the document in Microsoft Excel 5.0/95 Workbook (*.xls) format, I receive the same error this bug details. I will attach the two versions I'm working with. Please note that I only process the worksheet titles 'Calls' and ignore the others.
Ahhh. I just saw the other bug report similar to this that mentions you don't support pre-97 formats. Fair enough. I will adjust my application accordingly. Please ignore my posts. -Oh yeah. Thanks for everything. The POI project is _excellent_.
User resolved issue.