QTP and Excel

[Brian]

Hi Sonia,

Im assuming that your test run settings are set to "run on all rows". You could try and set this to run on one iteration only and then have a do-while-loop inside your script which can set the data table row. Also important to only import the excel sheet once at the start so this shouldnt be included in the while loop.
code could look something like this....

Code:

DataTable.Import("C:\ExcelSheet.xls")
Do
Row = Row + 1
DataTable.SetCurrentRow(Row)
.......
some code here using a row of data from the datatable.....
.......
Row = Row + 1
Loop while (True)

Hope this helps,
Regards,
Brian