Answer / madivalappa patil

I hope this answer will suit your query:

After you execute QTP tests the result will be stored in
report.xml file under current test directory.
Open blank excel-->Data-->Import External Data-->Import Data

you will get select Datasource Dialog box then browse your
test report.xml and click ok.

Answer / deeps

Hi,

DataTable.Export("file path")

DataTable.ExportSheet("filepath","DTsheet")

DTsheet:index or name of the sheet which u want to export
to excel file.

Ex:
Datatable.Exportsheet("c:\name.xls","name")

Datatable.exportsheet("c:\name.xls",1)

Answer / barun choudhary

(a) By default it creates an "XML" file and displays the results

Answer / naveen rana

By default it creates an "XML" file and displays the results

Answer / jayadev acharam

Datatable.Export("C:\Results\Actuals.xls")

Answer / lija

Datatable.export and also given path where ever you want
to the result
Datatable.Export("C:\Documents and
Settings\\Desktop\result.xls")

Answer / jyoshna.e

hai deep can you plz write comments for the script like
what is this name an 1 like these

Answer / shavali

I THINK IT IS NOT CLEAR . WE HAVE PASS THE RESULT DIRECTLY
INTO THE XL SHEET. SUPPOSE IF LOGIN PAGE IS VALID THAT IS
USERID AND PASSWORD AND LOGINBUTTON IS WORKING THEN THESE
TEST CASES SHOULD BE DISPLAYED IN XLFILE
IF POSSIBLE I WILL TRY THIS CODE


CORRECT ME IF IAM WRONG

Answer / sagar kumar sutar

Hi Deeps all the above answers are absolutely wrong. Can
any one please answer properly. We are not going to export
our sheet. That is DataTable object every body knows it.
But i want QTP results to export in .xls format. Awaitnig
ur reply soon.

Answer / sathish

It is not possible to Export the Results Directely into
Excel File,but it is possible to Export the Results into
Runtime Datatable.

EX:
datatable.AddSheet "venu"
datatable.DeleteSheet "Global"
datatable.DeleteSheet "Action1"
datatable.ImportSheet "C:\Documents and
Settings\Administrator\Desktop\Mallik.xls",1,"venu"
For i=1 to 9
datatable.SetCurrentRow(i)
systemutil.Run "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"
Dialog("Login").WinEdit("Agent Name:").Set datatable
("A","venu")
Dialog("Login").WinEdit("Password:").Set datatable
("B","venu")
Dialog("Login").WinButton("OK").Click
Window("Flight Reservation").WinMenu
("Menu").Select "File;Open Order..."
Window("Flight Reservation").Dialog("Open
Order").WinCheckBox("Order No.").Set "ON"
Window("Flight Reservation").Dialog("Open Order").WinEdit
("Edit_2").Set datatable("C","venu")
Window("Flight Reservation").Dialog("Open Order").WinButton
("OK").Click
x = Window("Flight Reservation").WinEdit
("Name:").GetVisibleText()
Datatable("D","venu")=x
Window("Flight Reservation").Close
Next

Results:x values will be Printed into Runtime Datatatable
in D column

I want to know can we integrate visual source safe tool with QTP and QC for our version controlling process? WE know QTP and QC 10.0 version is having the version control inbuilt in it but I want to know the merits and demerits of the inbuilt version control tool and the visual source safe tool using QTP and QC.

0 Answers   Wipro,

how can i use text check point in descriptive programming. or else is there any way to compare the text in the application and the text in data table.

2 Answers  

What is the architecture of framework

0 Answers  

can u please explain what is the exact difference between qtp8.2 and 9.0

0 Answers  

how to invoke the web application through script in qtp

8 Answers   Synechron,

what r the main benefits of automation?

2 Answers  

Find the 'String' from excel sheet and save to another sheet.But we don't know the string column number and row number?

4 Answers  

What is Curd testing?

0 Answers   Wipro,

What is the difference between a Function and Action in QTP?

0 Answers   Wells Fargo,

Shall we add Local Repository to shared object repository,if yes,how we add

4 Answers  

Iam doing automation in Oracle App's using QTP? In App's because of some functional setup, keep on changing my script flow. for this how can i use the recovery sceanrio?? Please help me?

1 Answers  

Do we get any issues if we run the testscript on different browsers? what are the options we need to st in QTP?

2 Answers   BirlaSoft,