Hi RGummadidala,
When you import excel in datatable, it is displayed in the global sheet but it is actually imported in the run time datatable. Check the run time datatable in the results, you will see all the values. But as soon as the run is completed and the script stops execution, the values will disappear from qtp datatable.
There might be 5 rows of data you are improting thats why your script performed 5 iterations eventhough you ran the script only once. Check the Test Settings -- Run tab. Option selected might be "Run on all rows".
When you import excel in datatable, it is displayed in the global sheet but it is actually imported in the run time datatable. Check the run time datatable in the results, you will see all the values. But as soon as the run is completed and the script stops execution, the values will disappear from qtp datatable.
There might be 5 rows of data you are improting thats why your script performed 5 iterations eventhough you ran the script only once. Check the Test Settings -- Run tab. Option selected might be "Run on all rows".