Thanks for the reply pai. I got a same exception with excel 2003 . any clue please ?
jaikiran pai wrote: > > 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 <[EMAIL PROTECTED]> > To: [email protected] > 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: [EMAIL PROTECTED] >> 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/ > -- View this message in context: http://www.nabble.com/Can%27t-even-read-empty-xls-file-tf1180287.html#a7274247 Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
