Suggestions to improve peformance: 1 - Create cells without informing the style increases the file size, always tell the name of the style - decreases the file size; 2 - When was merge, remove the contents of the cell and then do the merge;
Atenciosamente, Rafael Nunes I'm free - Linux Linux User #439174 http://www.linkedin.com/in/mederafael On Fri, Jan 31, 2014 at 9:25 AM, Nicholas Evans <[email protected]>wrote: > Dear ODF users, > > For a project I am working on, I am using the ODF toolkit to create > spreadsheets that can become rather large (>10 000 rows). I have noticed > that as the spreadsheet gets larger, writing the rows becomes very slow. I > have put together a class containing 4 different ways of writing 10 000 > rows of 10 columns to a spreadsheet. The fastest method (using > getRowByIndex and then getCellByIndex) takes 70 seconds. The methods that > use getRowList and getNextRow are much slower, taking about 170 seconds > each. The method using the Iterator<Row> seems to freeze for large inputs, > and doesn't behave as expected for small inputs. > > I would really like to improve this performance. I think this could be > done by manipulating the DOM directly. However, it would great if there > was a way of using the Simple API that I have overlooked that could help me. > > Does anyone have experience with improving the performance of the ODF > toolkit in the context of writing rows to an ods spreadsheet? > > Regards, > Nick >
