Hi Karsten, I've managed to reduce the number of objects that I'm creating (i.e. reuse the existing object instead of using 'new' keyword), and it has help to parse more records than before. However outofmemoryerror is now always pointing to the creation of POI object, which I don't have much control. Just for comparison, my XMLSS test file has about 2.5 million lines, and I'm expecting around 6 million lines in production. Hi Anthony, Thanks for your pointer, I'll try to search the archive. Cheers, Winarto
________________________________ From: [email protected] [mailto:[email protected]] Sent: Fri 09-Jan-09 19:13 To: [email protected] Subject: RE: Write a (very) huge Excel file. Hi Winarto, sorry for not seeing that you configured your JVM. I had ASCII-files with about 170.000 lines, which I transferd in an Excel spreadsheet (the *.xls was about 50MB). This worked fine with POI 3.1. Ok your files are about 4 times bigger, but it should work out too. Best regards... Karsten --------------------------------------------------------------------- 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]
