no such entry: "Workbook" and a possible solution

[Stephen Friedrich <st...@fortis-it.de>]

I am using poi 2.5.1 to read some excel sheets that seem to be generated
with Crystal Reports.
I get a FileNotFoundException with message
    no such entry: "Workbook"

The xls opens fine in excel (2003).

When I debugged the code I found that the problem was that a directory node
contains an entry with "WORKBOOK", but poi is looking for "Workbook".
I managed to get around the problem by storing/retrieving all names in
lower case in DirectoryNode._entries (without changing the actual name of
the entry of course).

What do you think: Is it a valid solution? Does case ever matter here?


---------------------------------------------------------------------
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/

Re: no such entry: "Workbook" and a possible solution

[ac...@apache.org]

Interesting.  I've never seen sheets with "WORKBOOK" before.  Submit a 
patch that looks for both.  Its not a biggy.

Stephen Friedrich wrote:
> I am using poi 2.5.1 to read some excel sheets that seem to be generated
> with Crystal Reports.
> I get a FileNotFoundException with message
>    no such entry: "Workbook"
> 
> The xls opens fine in excel (2003).
> 
> When I debugged the code I found that the problem was that a directory node
> contains an entry with "WORKBOOK", but poi is looking for "Workbook".
> I managed to get around the problem by storing/retrieving all names in
> lower case in DirectoryNode._entries (without changing the actual name of
> the entry of course).
> 
> What do you think: Is it a valid solution? Does case ever matter here?
> 
> 
> ---------------------------------------------------------------------
> 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/
> 
> 


---------------------------------------------------------------------
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/

Re: no such entry:

[Frank Geissler <ca...@deutschepost.de>]

Stephen Friedrich <stephen.friedrich <at> fortis-it.de> writes:
> 
> I am using poi 2.5.1 to read some excel sheets that seem to be generated
> with Crystal Reports.
> I get a FileNotFoundException with message
>     no such entry: "Workbook"
> 
> The xls opens fine in excel (2003).
> 
> When I debugged the code I found that the problem was that a directory node
> contains an entry with "WORKBOOK", but poi is looking for "Workbook".
> I managed to get around the problem by storing/retrieving all names in
> lower case in DirectoryNode._entries (without changing the actual name of
> the entry of course).
> 
> What do you think: Is it a valid solution? Does case ever matter here?
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe <at> jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 

Hi all,

I ran into the same problem and have not found any changes at class 
'DirectoryNode' yet to solve that problem.

What would be the right solution:

1. Making the lookup not case sensitive?
   Like mentioned by Stephen Friedrich

or 

2. Having a second, third ... try on alternative names?
   
Please could you give me a hind especially concerning
your planned activities about that problem.

Thank you in advance

Frank







---------------------------------------------------------------------
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/