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

What are the most frequent errors you faced while executing your scripts?

4 Answers   Semantic Space,

When should u feel that u can stop testing now? The following are few of the common Test Stop criteria:

2 Answers  

What is test harness?

2 Answers  

Hi all can any one give me roles and responsibilities for QTP (not WINRUNNER)

0 Answers   Autodesk, EDS, Wipro,

what is a good testcase?

3 Answers   Wipro,

How To clear the AutoComplete?

1 Answers  

How to call a function in QTP?

4 Answers  

HI, Based On The Information Below Write A Data Driven test Script Edit Box 1 Should take Value From Num1 Column Edit Box 2 Should take Value From Num2 Column Click On Add Button, Get The Value Of Exp res Column, Get Value From Actual Result Edit Box , Compare Two Values, Write Pass / Fail Value Into Result Column Thanks In Advance... Kavitha Input.Xls Num1 Num2 Exp res Act res Result 10 30 40 40 Pass 50 40 90 90.5 - - - - - - - - - - - - - - - -

5 Answers   UHG,

why you have standardized functions? plzzz guys with real time exp. do answer

0 Answers  

How to test results for qtp ?

0 Answers  

How to connect QTP to Testdirector

4 Answers   BirlaSoft, Polaris,

How can i get QTP 9.2 software or any webside where i can download ? can anyone help me out , i want to be expert in QTP ,but i don't have the software

3 Answers