incubator-odf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devin Han <devin...@apache.org>
Subject Re: HugeData in a Spreadsheet
Date Tue, 25 Oct 2011 07:02:15 GMT
Hi Wilson,

I test two cases.

If the <<Logic of Application>> is
            c = t.getCellByPosition(0, i);
            c.setStringValue("i");
There is no exception, everything works well.

If change to:
            c = t.getCellByPosition(i, i);
            c.setStringValue("i");
            System.out.println(i);
"java.lang.OutOfMemoryError" will be thrown when i = 941.

So, Logic of Application, please give more info about it.

2011/10/24 Wilson Barbosa <wilson.barbosa@gmail.com>

> 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.
>



-- 
-Devin

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