unable to import excel data in to data table

[RGummadidala]

Hi All,

I'm also struggling to import an excel file to Datatable. I have an excel by name Sample.xls and my script is as below

Code:

Dim qt
Set qt = createobject("QuickTest.Application")
qt.Launch
qt.Visible=True
DataTable.ImportSheet "C:/Users/Desktop/Sample.xls",1,"Global"

I wrote this in expert view of QTP and ran it. When I run it, I'm seeing the Global sheet of DataTable getting populated (I see the values copied to cell quickly), but at the end of the run, there are no values in the DataTable. I also see 5 iterations of the execution, in the HP results view, where as I ran it only once.

Can somebody throw some light on this ?

[DinakarVadapalli]

u can find the data only during run time...
once execution is done...u can find the data in run time data table of results file

[manishbhalshankar]

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".

[RGummadidala]

Hi,
Thanks for your advice,my problem got sloved.


Regards,
Rgummadidala.

[sriraj]

Hi,
I am having similar kind of code but values are not loading to runtime table and script is failing.
Note:I don't have MS office installed in my server where QTP installed.
Please help on this.

Code:

Code:

globalpath = DataTable.Value("Global_Path","MainAction")
    DataTable.ImportSheet globalpath, "Global","Global"

Thanks,
Sree