We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

What is the most effecient method to delete large numbers of rows?

I am have a process that deletes a large number of rows - from several hundred to several thousand.
Are there any best practices for deleting rows?

Thanks, Mitch


Thanks for your query.

It depends upon the complexity of references and formulas etc. in your workbook. If you have to delete entire rows and no references are to be updated, then use WorkSheet.Cells.DeleteRows() with updateReference = false. If selected range is to be deleted, use DeleteRange() function. There is no option to delete rows in parallel from different segments of the file.

Aspose.Cells also provides LightCells API for reading/writing large files. You may please visit following link if it can be of any help to you.

Using LightCells API