Get Row number in excel for a row that contains certain information

Hello,

I have an excel sheet in an excel application scope, in that i use for each row IF the cell contains a certain information, then I would like to get which number row it is?
What activity and condition could I use to get the row number using the above sequence?

@dvn

Please use dtData.Rows.Indexof(row)

2 Likes

Use for each row activity and specify the index variable(intRowIndex) in the output property.
Inside the loop, use an if condition to check the cell value. and if the cell value contains the information, you can use the index variable (intRowIndex)

1 Like