poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Lowe" <rml...@rmlowe.com>
Subject RE: Excel cannot open HSSF file with 30,000 rows generated by POI 2.0 pre-release 3
Date Fri, 10 Oct 2003 12:44:42 GMT
I belive this was changed somewhere between the latest "release" version
(1.5.1) and the 2.0 prerelease.

In 2.0 prerelease 3, the createRow method takes an int.

- Rob


-----Original Message-----
From: Rao Anand [mailto:maroju_anand@hotmail.com]
Sent: Friday, October 10, 2003 8:24 PM
To: poi-user@jakarta.apache.org
Subject: RE: Excel cannot open HSSF file with 30,000 rows generated by
POI 2.0 pre-release 3


but is it possible for me to read/create a row greater than 32767. the
parameter for the method getRow()/createRow takes short value (max 32767).

how do i read from an excel file containing more than 32767 rows?

>From: "Robert Lowe" <rmlowe@rmlowe.com>
>Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
>To: "POI Users List" <poi-user@jakarta.apache.org>
>Subject: RE: Excel cannot open HSSF file with 30,000 rows generated by POI
>2.0 pre-release 3
>Date: Thu, 9 Oct 2003 02:01:24 +0800
>
>Done:
>
>http://nagoya.apache.org/bugzilla/show_bug.cgi?id=23628
>
>And I tested with a build from CVS and confirmed that it's fixed there.
>
>- Rob
>
>
>-----Original Message-----
>From: Danny Mui [mailto:danny@muibros.com]
>Sent: Thursday, October 09, 2003 1:41 AM
>To: POI Users List
>Subject: Re: Excel cannot open HSSF file with 30,000 rows generated by
>POI 2.0 pre-release 3
>
>
>It's best for you to attach this to bugzilla so we dont lose track.
>
>http://nagoya.apache.org/bugzilla/buglist.cgi?product=POI
>
>Thanks for the test case, that will assist us in fixing your problem
>immensely.
>
>danny
>
>Robert Lowe wrote:
>
> >Hi,
> >
> >I'm having problems generating an HSSF file with around 30,000 rows using
> >the 2.0 pre-release 3.
> >
> >Initially I encountered OutOfMemory errors, however after increasing the
>JVM
> >heap size the program that generates the file appeared to run correctly.
> >However, Excel 2000 cannot open the output file produced. (There's no
>error
> >message--the document window just flashes up on the screen for a split
> >second before disappearing.)
> >
> >I managed to produce a simple test case that demonstrates the
>problem--see
> >HssfTest.java. (If anyone's interested I can send you the output file
> >generated, but I don't want to send it to the list as it's about 1.3 MB.)
> >
> >This problem does not occur on the latest stable release version, 1.5.1.
> >
> >Any workarounds would be greatly appreciated! (I can't go back to 1.5.1
> >because I need the cloneSheet() method... :-( )
> >
> >Best regards,
> >
> >Robert Lowe
> >http://RMLowe.com/
> >
> >
> >
> >------------------------------------------------------------------------
> >
> >---------------------------------------------------------------------
> >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
>

_________________________________________________________________
Make fun prints Click here to order. http://www.kodakexpress.co.in  Delivery
anywhere in India.


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


Mime
View raw message