data sheet row count

[rushil]

I am using the below steps to get the rows count of a table. Instead of printing once the vlue of the rows count the print statment is printed "rowVal" times. That is if I have 8 rows in the data sheet it prints 8 times. Any help appreciated.
Thank you

Code:

DataTable.ImportSheet "C:\QTPD1\QTPcomplete\flights.xls" ,1 ,"Global"
rowVal = DataTable.GetSheet("Global").GetRowCount
print "there are "&rowVal & " rows in the table"

[SteveS]

Under Test Settings\Run you have it set to run on all rows, change this to Run one iteration only.

[rushil]

Thank you. It worked.