Poor performance writing data using putValue


#1

Hi,

I’m working on generating fast reporting component that outputs in excel format using your aspose.excel.dll .net component (v. 3.1.1.0). During performance testing, found out that it’s taking too long of a time to simply output values in the cell. Here’s an example of the code:

Range rng = ws.Cells.CreateRange(ws.Cells.MaxRow+1, 0, groupedRows.Count20+3, 20);

int ridx = 2;
for (int r=0; r < groupedRows.Count; r++)
for (byte c=0; c < 10; c++)
rng[ridx,c].PutValue(ridx
100+c);ridx++;

I’ve logged the time it takes to execute this segment for groupedRows.Count = 325 and it took on my PIII 1GHz, 512Mb ram, about 30 sec…this is way too slow for mere 325 rows.

Can you please let me know what’s causing this slowness? it’s essencial for my fast reporting component.
Thanks.


#2

Yes. It’s really too slow. I optimize my code and now it runs much faster. Please try this attached fix.


#3

Thanks…it’s fast now…< 1 sec.