Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to export QTP results to an .xls file?

Answer Posted / 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

Is This Answer Correct ?    2 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does qtp identify the object in the application?

975


give me the code to save all messages of inbox of gmail into a folder and notepad

2109


What is the registration process and examination fees?

1086


What is object spy in quicktest professional?

1118


suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?

1844


what is the diff between manual test plan document and automation test plan doc.can u explain indetail.

2119


Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19

1634


How can i get the image text that changes dynamically? Here i have used "GetROProperty", but it's not working. I used like Ex:Browser("webmail").Page("inbox").image ("captchaimage).getroproperty("innertext/text/value")

1859


Describe synchronization point.

1151


What is the difference between a Function and Procedure in QTP?

1198


Hi Sudhananda, plz send me the QTP framework with any diagram and PPTS . I want to switch to automatio, I done QTP from professional person, but he does not give me his knowledge properly. so pls help me Thaks send me on following address mirajkar.akash@gmail.com

2385


Where to use function or action?

1179


How many types of object repository in qtp?

1108


What is the use of defining a newobject in the object repository "Define New TestOject". How to use this further. If we define new testobject, how can it recognizes the objects properties of any application.

2097


How you calling actions in qtp?

1053