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

can any body give the banking domain concepts/links

0 Answers  

Why do we go for Qtp? What are the advantages of qtp? Diff between winrunner and Qtp?

3 Answers   Symphony,

What is the difference between qtp and selenium?

0 Answers  

Write code for ,We have a web table with rows and columns like EmpID EName Action 1 ABC Edit Delete 2 XYZ Edit Delete 3 PQR Edit Delete In the above Table the last column has two links we have to click first link based up on EmpID =2

2 Answers  

If a object property is changed in the application. where it should be updated in QTP... Pls anybody can give the answer.. Thanks in advance...

4 Answers   Navis,

can u explain relative path architecture framework in qtp?

0 Answers   Mindlance,

I'm facing this problem while automating my application..its a web based apps.. In my application there are few webtables are displaying in the page.In the different cells there are links and action buttons.Problem is there is link in different web tables corresponding to one name.Hence the properties of the objects(say a link) are same except the x,y co ordinate of the object.So my script is not able to distinguish between the two links present in different cells of web tables with same name.Kindly help on this..

3 Answers  

How to add verification steps to tests?

1 Answers  

Idid my qtp course in 2007 june in mind Q i for got to use this tool ,i want to mention in my resume about this ,how can i rectify this ,pls give me any idea .

2 Answers   Quest,

How to call script1 into script2?

3 Answers  

If 2 gmail browsers are opened in our system, how to enter the mail id and password into second browser by using discriptive program?

7 Answers   Mphasis,

Explain different checkpoints in qtp.

0 Answers