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

Free Support Forum - aspose.com

How to delete excel rows which are not in sequence

I want to delete rows of indexes 1,4 and 7 If I delete one by one The indexes of the rows will get changed, this might lead to deleting of other rows, Is there any approach where we can delete un sequence rows?


No, there is no such feature or relevant overloads available to remove rows in un-sequential way in Aspose.Cells APIs. So, you have to remove row by row for your needs.

You should delete row in reverse order (higher row index to lower row index). This will fix your issue.