Get cell row in excel


After read range activity and getting the data in a datatable variable, “dt”, if i encounter a value “closed” in a row, i want to know what the row number for that value in the excel is.

Can anyone suggest a way to do this?


List(Int32) ListA= (From p in dt.Select
                            where p.itemArray.Contains("closed")
                           Select Convert.ToInt32(dt.Rows.IndexOf(p))).ToList

Now ListA will contain the row index which contains the word “closed”


You can use filter table activity that will filter all your records on the basis of Closed value

Thank you, Mahesh ! It worked !