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

It's very slow when insert new row with bigger rownumber

Apr 30, 2014 at 6:11 AM
Edited Apr 30, 2014 at 7:43 AM
I try to add some rows in the excel,and is used like below:

worksheet.Rows(1).InsertRowsBelow(1000); - OK
worksheet.Rows(1).InsertRowsBelow(10000); - Slow
worksheet.Rows(1).InsertRowsBelow(100000); -Very Slow

And I hope the developer can try fixed it,and now i ues the thread pool to make it faster,like

ThreadPool.QueueUserWorkItem(new WaitCallback((x) =>
        {
            if (_ranges != null)
                _ranges.ForEach(r => r.Dispose());

}));

Coordinator
May 1, 2014 at 4:16 PM
cooper360, I should have a new release soon but in the meantime pick up the latest source code. It has a fix for this issue.