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

Hi, Any one have the crack for QTP 10.0,if so could you please send it to phanijuly10@gmail.com

2 Answers  

Hi Suppose u have complex Test scripts which u vl write first and which u vl execute first

2 Answers   Symphony,

1) What is the diff Between GetRoproprty and Gettoproperty? 2)What is Redim?

5 Answers   STC,

Plz someone tell me about user interface testing and backend testing and hw did u use it in ur project.plz give a detail answer i need to explain it to the interviewer. plzzzzzzzzz guys its urgent

2 Answers  

How can i initiate the objects to find uniquely in OR

0 Answers   IBM, Livetek,

suppose u have two send buttons(same width,height,font) on an application write a descriptive programming

1 Answers  

What is diff betwee datatable.importsheet "path" and datatable.import

2 Answers  

Explain abt the File System Object in QTP with ex

3 Answers   Ordain Solutions,

please post the interview questions for QA position in FACTSET

0 Answers   FactSet Systems,

Pls let me know completely about descriptive programming, where it is used, pls explain with a real time example of its occurence and the program code written in qtp.

3 Answers  

HOW TO AUTOMATE CAPCHA IMAGES while creating Gmail account

2 Answers   TCS,

What are the three challenges U faced during automation testing of your application.

2 Answers   L&T,