How to export QTP results to an .xls file?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 12 Yes | 0 No |
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)
Is This Answer Correct ? | 20 Yes | 11 No |
Answer / barun choudhary
(a) By default it creates an "XML" file and displays the results
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen rana
By default it creates an "XML" file and displays the results
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jayadev acharam
Datatable.Export("C:\Results\Actuals.xls")
Is This Answer Correct ? | 14 Yes | 16 No |
Answer / lija
Datatable.export and also given path where ever you want
to the result
Datatable.Export("C:\Documents and
Settings\\Desktop\result.xls")
Is This Answer Correct ? | 4 Yes | 6 No |
Answer / jyoshna.e
hai deep can you plz write comments for the script like
what is this name an 1 like these
Is This Answer Correct ? | 3 Yes | 12 No |
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
Is This Answer Correct ? | 3 Yes | 12 No |
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.
Is This Answer Correct ? | 2 Yes | 12 No |
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
Is This Answer Correct ? | 2 Yes | 14 No |
What is the current version of QTP and now it is the product of Mercury or HP
Suppose one object is changed in a project after delivering the project.Where we will update that object? it can be present in many scripts so can we update all the scripts?
Can anybody give the script to addsheet, add column,add values under that column in the rows??
Login to flight app, in window flight reservation set the date field and select flyfrom as Frankfurt and verify whether flyto list box has the item FrankFurt, log the results.
What is the difference between QTP 8.2 and QTP 9.2
Suppose i have given 10 test cases all the test cases should be automated?
what is virtual object?
what is the difference between rational rose and QTP? WHICH TOOL IS BETTER TO LEARN? PLEASE SEND ME AT sana_50218@yahoo.com sandeep@epuratech.com
Can we record a video in qtp recording??
can we run the scripts of qtp 8.2 in the qtp7.0?
hi i have one isuue on selecting webcheckbox .there are 15 wecheckboxex i want to select every time 9 th one how can i select plese help me regards balaji
in login module login button chage regularly(means login button change to submit button).What is the code for it.