Remove empty row in the excel

[badita (Mihai Badita)]

I doubt that this will work. Does it?

The reason explained here - the collection you iterate through can not be modified within the iterator

How to delete a row in excel using invoke method

Let’s suppose that reading in batches has been solved. Now we need to remove the rows that falls under a specific condition. There are two remarks here: There’s no need to use Invoke Method as there is a dedicated activity for this Remove Data Row. As a parenthesis, if you want to use Invoke Method for removing rows the target object should be dt.Rows and not dt.Columns You need to iterate through your Rows collection but you can NOT use a For Each Loop. The reason is that you will get a…

However, @aksh1yadav method here works too, just use RemoveDataRow instead of InvokeMethod

Delete data row from data table

Hey @mgangrade7 To delete rows from datatable, you could use the logic like this: Use the select function on the datatable to filter the rows that match your condition and this will return an array of Datarows. Then use a for each loop and remove each row from the Array of Datarows using datatable.Rows.Remove(row); For Your Reference find the attached sample solution: Delete_Data_Row_From_Datatable.zip (7.7 KB) Regards…!! Aksh