How to get the particular Row index for the given value
for example when the value “John” is given it should print its first row index “1”
If “Henry” it should display "3"
hi,
this is one way to do it, use loop index
InternalData data = findTestData(‘SpamData/someSpamTestData’)
def ro = data.getRowNumbers()
println "count of rows "+ro
search = “book”
for (int i = 1; i< ro; i++){
if (data.getValue(1, i).equals(search)){
println ("row index: "+i)
}
}
row index: 3
1 Like
Great Working Cool, Thank You.
Timo_Kuisma1,
how is it possible to get row number of specific column?
My Excel data hast multiple column with different number of rows.
Regards,
Dmiti
Hi,
in a loop as I have added my previously command