how do i read from an excel file containing more than 32767 rows?
From: "Robert Lowe" <[EMAIL PROTECTED]>
Reply-To: "POI Users List" <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Make fun prints Click here to order. http://www.kodakexpress.co.in Delivery anywhere in India.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
