Why i am getting this error when i am trying to compare two different excel sheets columns?Any solution?

[Anjali_Rani]

Trying to writing this Linq query for comparing and updating excel sheets.But this Exception is thrown.

[Manish540 (Manish Shettigar)]

Check this below link @Anjali_Rani

Linq - Update Values in Datatable

@noam 1.update new value for all rows in a specific column - for example update all the values in column number 4 (no matter what was the old value) to new value You can play on provided xaml with following (Col 3 is updated with NewValue String) (From d In dtData.AsEnumerable Let ra= New Object(){d(0),d(1),“NewValue”} Select dtResult.Rows.Add(ra)).CopyToDataTable for second request have a look here: Reset_StatusCol_MultiContains_KwordList.xaml (8.0 KB)

Hope this may help you