Get cell row in excel

excel

#1

Hi,

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?


#2

@cjagwani

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”

Regards,
Mahesh


#3

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


#4

Thank you, Mahesh ! It worked !