I have inputed certain text into msgbox which is available in certain row of excel table.Now using for each row i am trying to read the respective next column data if condition matches like ‘row(1).ToString=S_Class’
If I use the code of index it give me the row number matching ‘BET.Rows.IndexOf(row)+1’ and if I give Row(3).tostring it give validation error.
I could not attach the workflow as it says new user.
To explain in detail: If I am reading row 3 of excel cell (3,1) then how to get data on the cell (3,2).