Had seen this recently. Apparently, the xls file was saved in 95 format. Changed the format
to 2003 and it worked.
----- Original Message ----
From: demi <finddemi@gmail.com>
To: poi-user@jakarta.apache.org
Sent: Friday, 10 November, 2006 3:27:06 PM
Subject: Re: Can't even read empty xls file
Hi Stephen..Did you happen to fix the java.io.FileNotFoundException: no such
entry: "Workbook.
IF so could you please guide us appropriately.
Thanks
Best Regards
Demi.
Stephen Friedrich wrote:
>
> I created a new workbook in Excel 2003 and saved the xls using
> "Microsoft Excel 5.0/95-Arbeitsmappe" as file type.
> When I tried to read that file I get this exception:
> Exception in thread "main" java.io.FileNotFoundException: no such entry:
> "Workbook"
> at
> org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.java:245)
> at
> org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocumentInputStream(POIFSFileSystem.java:322)
> at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:157)
> at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:130)
>
> When I set a breakpoint at the throw statement and examine the contents of
> the
> "_entries" hash map that gets queried, it shows that it contains only
> these keys:
> \u0005SummaryInformation
> \u0005DocumentSummaryInformation
> Book
>
> So I guess for some reasons execel uses "Book" as aname when hssf expects
> "Workbook".
> I have seen similar problems with xls files from other sources (report
> generators),
> which used for example "WORKBOOK" (all upper case).
>
> So basically it seems that excel uses a different strategy to determine
> which entry
> actually represents the workbook.
>
> If I only knew which one, I'd implement a patch.
>
> Anayway: Any comment is highly appreciated.
>
> (Here's what I wanted to do originally: Since I cannot create pivot tables
> with hssf,
> I wanted to try wether I can create a 'template' xls in Excel which
> contains the
> pivot table in sheet 1 refering to actual data in sheet 2. That way I can
> maybe read
> the file, fill it with data and write it back. Should this work?)
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
--
View this message in context: http://www.nabble.com/Can%27t-even-read-empty-xls-file-tf1180287.html#a7274106
Sent from the POI - User mailing list archive at Nabble.com.
__________________________________________________________
Yahoo! India Answers: Share what you know. Learn something new
http://in.answers.yahoo.com/
|