I have an excel file. like below.
I know the value of ID field. Based on the ID field can I find the row index. So that I can update the status field in the same row.
I know that we can get the value from a different column like this: FinalListLookUpDataTable.Select().Where(function(x) (x(“ID”).ToString = “abc12345”)).First()(“Email Value”).ToString but I want to get the row id so that I can update the status column.