And are there ways to reduce the memory needed?
Our application is using a table control to display a large array of data items. Each column could contain dates, integers, reals, or strings. In one of our tests the table contained just over 61000 rows.
We take this data and put it into a 2 dimensional object array which in turn we move into a sheet. I can create the sheet without the data inserted into the cells using cell.setValue. Is there a more efficient way to create a sheet this large? (I found some suggestions in the forum related to adding cells one row at a time and we are doing that.)
I can only seem to process about 25500 rows with 5 columsn of data before the OutOfMemory occurs.
FYI, I just downloaded Cells Java 1.9.5 and tried that and it didn't help.
Or is there some way to know that we will hit an OutOfMemory error creating a large spreadsheet before it happens instead of getting the java.lang.OutOfMemoryError which we can't catch?