Hi All, I am using below Linq Query to update datatable and it is working as expected. Query: dt.Select(“Subject=‘XYZ’”).ToList.ForEach(Sub(x) x(“Status”)=“Spike In cases”) But the problem is I am unable to read excel with Add header property checked as it is throwing exception as “Status column …

Linq - Updating column in Datatable by accessing it by column index

kumar.varun2 (Varun Kumar) August 9, 2022, 10:28am 13

You can also try this approach provided by @ppr in the blow post

Topic		Replies	Views
Linq query for updating a value in a datatable based on a condition Studio studio , question , activities_panel	10	1404	September 23, 2022
Check column name if found header same Activities excel , activities , question	5	1555	March 7, 2022
Update a datatable column with a specific value using linq Studio studio , question , activities_panel	9	5911	September 15, 2022
Need help on LINQ to update the duplicate rows status in datatable Studio excel , studio , linq-query	2	1589	October 13, 2022
How to update column's value in datatable with LINQ? Studio studio , question , activities_panel	21	7206	January 28, 2022