incubator-odf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wilson Barbosa <wilson.barb...@gmail.com>
Subject HugeData in a Spreadsheet
Date Mon, 24 Oct 2011 12:49:12 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message