You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Chris Cheshire <cc...@bigredwire.com> on 2003/11/17 20:38:46 UTC
xls generation problem
I am using POI to build spreadsheets of data read from the database,
which then get emailed out as internal reports once a week. Up until
last week I was using a 1.9 dev release and everything worked fine, but
I got an excel (2000) error box saying "Unable to read file". I tried
opening the spreadsheet on open office on a unix machine and it opened
fine except for an error saying it exceeded 32000 rows. I know the
spreadsheet doesn't have enough data to exceed 64000 though. This week I
updated to the 2.0RC1 build, and got exactly the same problem. Can
anyone point me in the right direction to how to track this error down
please?
Thanks
Chris
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: xls generation problem
Posted by av...@itellix.com.
Cool! Glad to be of help.
Regards
-
Avik
Quoting Chris Cheshire <cc...@bigredwire.com>:
> Avik,
>
> Thanks for the sanity check. I was still using the old jar in the
> classpath. I have really changed to the 2.0RC1 this time, and yes it
> does work properly.
>
> Thanks
>
> Chris
>
> avik.sengupta@itellix.com wrote:
>
> >Well, thats strange .. RC1 is supposed to fix a major file corruption issue
> for
> >large files.. see bug 15375 in bugzilla... many people have tested the
> fix....
> >http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375
> >
> >
> >Are you sure you you had RC1 in the classpath?
> >
> >If RC1 still has that problem, its unfortunately back to reading BiffViewer
> >dumps. What you can do is try to isolate the problem thru trial and error,
> and
> >see which cell is causing the error. Thats the usual approach to this kind
> of an
> >issue.. it aint pretty!
> >
> >If you can isolate the problem enuf to send the list a testcase that
> replicates
> >the problem, we can have a look at it.
> >
> >Regards
> >-
> >Avik
> >
> >Quoting Chris Cheshire <cc...@bigredwire.com>:
> >
> >
> >
> >>I am using POI to build spreadsheets of data read from the database,
> >>which then get emailed out as internal reports once a week. Up until
> >>last week I was using a 1.9 dev release and everything worked fine, but
> >>I got an excel (2000) error box saying "Unable to read file". I tried
> >>opening the spreadsheet on open office on a unix machine and it opened
> >>fine except for an error saying it exceeded 32000 rows. I know the
> >>spreadsheet doesn't have enough data to exceed 64000 though. This week I
> >>updated to the 2.0RC1 build, and got exactly the same problem. Can
> >>anyone point me in the right direction to how to track this error down
> >>please?
> >>
> >>Thanks
> >>
> >>Chris
> >>
> >>
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >
> >
> >
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: xls generation problem
Posted by Chris Cheshire <cc...@bigredwire.com>.
Avik,
Thanks for the sanity check. I was still using the old jar in the
classpath. I have really changed to the 2.0RC1 this time, and yes it
does work properly.
Thanks
Chris
avik.sengupta@itellix.com wrote:
>Well, thats strange .. RC1 is supposed to fix a major file corruption issue for
>large files.. see bug 15375 in bugzilla... many people have tested the fix....
>http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375
>
>
>Are you sure you you had RC1 in the classpath?
>
>If RC1 still has that problem, its unfortunately back to reading BiffViewer
>dumps. What you can do is try to isolate the problem thru trial and error, and
>see which cell is causing the error. Thats the usual approach to this kind of an
>issue.. it aint pretty!
>
>If you can isolate the problem enuf to send the list a testcase that replicates
>the problem, we can have a look at it.
>
>Regards
>-
>Avik
>
>Quoting Chris Cheshire <cc...@bigredwire.com>:
>
>
>
>>I am using POI to build spreadsheets of data read from the database,
>>which then get emailed out as internal reports once a week. Up until
>>last week I was using a 1.9 dev release and everything worked fine, but
>>I got an excel (2000) error box saying "Unable to read file". I tried
>>opening the spreadsheet on open office on a unix machine and it opened
>>fine except for an error saying it exceeded 32000 rows. I know the
>>spreadsheet doesn't have enough data to exceed 64000 though. This week I
>>updated to the 2.0RC1 build, and got exactly the same problem. Can
>>anyone point me in the right direction to how to track this error down
>>please?
>>
>>Thanks
>>
>>Chris
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>
>>
>>
>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: xls generation problem
Posted by av...@itellix.com.
Well, thats strange .. RC1 is supposed to fix a major file corruption issue for
large files.. see bug 15375 in bugzilla... many people have tested the fix....
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375
Are you sure you you had RC1 in the classpath?
If RC1 still has that problem, its unfortunately back to reading BiffViewer
dumps. What you can do is try to isolate the problem thru trial and error, and
see which cell is causing the error. Thats the usual approach to this kind of an
issue.. it aint pretty!
If you can isolate the problem enuf to send the list a testcase that replicates
the problem, we can have a look at it.
Regards
-
Avik
Quoting Chris Cheshire <cc...@bigredwire.com>:
> I am using POI to build spreadsheets of data read from the database,
> which then get emailed out as internal reports once a week. Up until
> last week I was using a 1.9 dev release and everything worked fine, but
> I got an excel (2000) error box saying "Unable to read file". I tried
> opening the spreadsheet on open office on a unix machine and it opened
> fine except for an error saying it exceeded 32000 rows. I know the
> spreadsheet doesn't have enough data to exceed 64000 though. This week I
> updated to the 2.0RC1 build, and got exactly the same problem. Can
> anyone point me in the right direction to how to track this error down
> please?
>
> Thanks
>
> Chris
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org