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 everybody.. I m using QTP 9.2 version., plz send me licence key is it seat or concurrent licence key... plzzzzzzzzz plz help me for this one and its Locking code:8-5C740 Maintenance number: 0123-2820602186.,

1 Answers  

what will be there in keyword view and expert view?

2 Answers  

can any one make me confirm about a real time employee with better experience in QTP who is providing QTP course individually in Bangalore???

3 Answers  

is there any addin for remedy user application

0 Answers  

How to use Regular Expressions in QTP

1 Answers  

Once the Actions are splitted , is there any way to merge them

3 Answers  

Think and Reply.. can we parameterize radio buttons, check boxes? as in flight web site on flight preference page, choosing different flight produces trouble if from port and to port been parameterize, and runs. Try it by own you will get the error.

3 Answers   Patni,

how can i call an external action,which is not added external action of an action?

2 Answers   Ordain Solutions,

1. How to capture data from images in QTP and produce them in Excel sheet ? 2. What is Terminal Emulator add-in installation and configuration procedure ? 3. Tell me how do u define action and transaction in QTP ? 4. Is QTP case sensitive ? 5. Problem with XML checkpoint ? 6. When was QTP 8.2 and Loadrunner 8.0 officially released to the market ? 7. Can we record on netscape browser does it require any special settings ? 8. How do I add new object to the object repository to any particular frame ? 9. Do we have rapid test scrpit wizard in QTP ? How to learn all the windows and objects in QTP 10. How to open Exceel sheet using QTP script ? 11. Is it necessary to learn VB script to work with QTP or we can manage with keword driven ? 12. What is descriptive programming in QTP ? 13. How to invoke the QTP from dos prompt and run a test without any interaction with human ? 14. What is the meaning of Context sensitive ? 15. How to retrive the property values from "Resource.mtr" after recording the script with "Standard checkpoints" ? 16. Where should we use accessbility checkpoints. Can u explain me with the example ? 17. How do we add object repository dynamically ? (During runtime) 18. How to record right click of a context menu and click on the selection ? 19. How to connect oracle database to QTP ? 20. How will you load few objects in Active Screen ? 21. Can I compare two DataBases using QTP ? 22. If the the two object have same class then how QTP will find the object ? 23. Can I change the runtime properties of an object ? How can I check if a parameter exists in database ? 24. What is the script for database check point, bitmapchek point, regular expression ? 25. What is QTP environmental variable ?

1 Answers  

Can any one explain about environment variables with examples?

2 Answers  

Write a script to delete a specific row in a webtable.

2 Answers   Tech Mahindra,

How to connect to data base?

2 Answers