QTP DataTable.Import Issue

[Neha Singh]

Hi,

I am trying to import data from xls file using DataTable.Import statement.

But while running it is executing for first row only.
eg: if my xls contains 4 rows then it will run 4 times for first row only.

Settings:
In run settings I have selected "Run for all rows" then also same pronlem

And I have tried below mentioned code also but I can not use that becuase I am using Recovery Scenario, in which I am closing all browser & giving "Proceed to next iteration"
rowcount = Datatable.Getrowcount
For i = 1 to rowcount
Datatable.SetCurrentrow(i)
****Code*****
Next

Thanks & Regards,
Neha Singh