Issue while invoking method to remove a data row

[sparsh (Sparsh sinha)]

Hi All,

I am automating a process, where i have two excel sheets and i have to match the first one with the second one and remove the entries from the second one whenever there is a match. Basically, second one is the master sheet and the first one is the subset of second one. And at the end of the execution, i want the second sheet devoid of the entries of the first one. To do that, i did a for each inside a for each, applied an if condition and whenever there is a match, invoked the method to remove that row from the first second sheet. But i am getting an error as: “For Each Row: Collection was modified; enumeration operation might not execute”. Can you please help me out.

@aksh1yadav

Regards
Sparsh

[J0ska]

Already discussed many times in the forum. You should search first before asking

e.g. here:

Problems Adding/Removing Rows from DataTables

There might be: strRowOutput = String.Join(",", row.ItemArray.Select(Function(x) x.ToString)) This also might work but can’t test now: strRowOutput = String.Join(",", row.ItemArray) String.Join takes 2 parameters - values separator (here it’s a colon) and a collection of strings or values directly convertible to string. In the shorter version we pass as 2nd argument row.ItemArray which is an array of all values in a row (stored as objects). In the longer version we take that array and sel…