Column Update in Excel

excel

#1

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


#2

Hi,

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


#3

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