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 Excel file using POI. 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? FYI, I'm using POI 3.2 final, with jvm setting -Xms512m -Xmx1024m. Any help will be very much appreciated. Cheers, Winarto
