poi.1045710.n5.nabble.com/Write-a-very-huge-Excel-file-tp2303623p3341728.html
Sent from the POI - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
Sent: Saturday, 10 January 2009 00:07
To: POI Users List
Subject: RE: Write a (very) huge Excel file.
Just had a quick search myself and found the response from Yegor that I
was looking for. It will not work for you however as I think he is
talking about creating large xml files. Have pasted his reply
List
Subject: RE: Write a (very) huge Excel file.
Just had a quick search myself and found the response from Yegor that I
was looking for. It will not work for you however as I think he is
talking about creating large xml files. Have pasted his reply below;
Unfortunately poi-ooxml has quite a
ri, 1/9/09, Winarto wrote:
From: Winarto
Subject: RE: Write a (very) huge Excel file.
To: "POI Users List"
Date: Friday, January 9, 2009, 7:28 AM
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&
: k...@work09.softwing.de [mailto:k...@work09.softwing.de]
Sent: Fri 09-Jan-09 19:13
To: user@poi.apache.org
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
sp
guidance I can
offer is that it was in the last two to three months of last year.
--- On Fri, 1/9/09, Winarto wrote:
From: Winarto
Subject: Write a (very) huge Excel file.
To: "POI Users List"
Date: Friday, January 9, 2009, 1:33 AM
Hi all,
I'm currently converting an XMLSS based f
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...
Hi Winarto,
>It is always throwing java.lang.OutOfMemoryError:
>Java heap space error in around 15-16k records. Is there any tips or
>advise that I can use to avoid that error?
had the same problem, just give the Java virtual machine more heap.
%jre_path%java -Xms128m -Xmx512m -classpath ...
Th
Hi all,
I'm currently converting an XMLSS based file into a real Excel file. The
XMLSS based file is about 100-200MB (yes it's one hundred to two hundred
megabytes) containing about 30k records. I have been able to parse the
XML file within 10-20seconds, but the problem comes when creating the