This project has moved. For the latest updates, please go here.

CopyTo seems to be slow while copying a lot of lines.

Jun 11, 2013 at 1:03 PM
Since the InsertRowBelow() don't keeps the formats and formulas from the root row, I have to copy from the root row. At last i fill in certain values in to the created rows.

rad = ws.Cell("KontoSaldo").Address.RowNumber;
ws.Row(rad).InsertRowsBelow(2000);
for (int i = 1; i <= 2000r; i++)
{
ws.Row(rad).CopyTo(ws.Row(rad + i));
}
FillTheRowsWithValues()

It seems that the CopyTo takes longer time for each time it's copying. On my machine it took about 10 sec the first 200 items, when it comes to about 1000 it's only makes about 20 for each 10 sec.