Column Update in Excel

Hi ,

I have a excel with EmpID, Status in 2 column. I have taken excel data in datatable. In a For loop for excel data based on a user input I am searching for ‘EmpID’. If ‘EmpID’ found then then I need to update ‘Status’ as ‘Success’. Kindly provide some suggestions

Hi,

you need to record the index of ‘EmpID’ and use this index to update the Status.

Hey Thanks for your update. I was trying to do it in for loop. I found the solution by exploring.
row.Item(“Status”) = ‘Success’

2 Likes