Dear All,
I'm newbie using the SimpleODS, im getting in trouble when creating a big
spreadsheet (about 140k rows). When the sheet if growing the performance is
degrated and in a point i got "java.lang.OutOfMemory" exception. There is a
way of work in the sheet object like a file?
The example of my code (reduced):
...
// Cria objetos da planilha
SpreadsheetDocument planilha = SpreadsheetDocument.newSpreadsheetDocument();
Table t = planilha.getSheetByIndex(proxima_sheet);
t.setTableName("WKS_" + proxima_sheet);
//
Cell c = null;
for(int i = 0; i<65000;i++){
<<Logic of Application>>
}
...
Many thanks.,
Wilson.
