How do you export an output to a excel sheet?
Ex: I get my answer by using Msgbox"..." &R. How do I
displayed the result of the Msgbox (such as R) to an excel
sheet? Please let me know.Thanks

Answers were Sorted based on User's Feedback



How do you export an output to a excel sheet? Ex: I get my answer by using Msgbox"..." &..

Answer / amit kumar srivastava

I think after capturing the run time value by using command
like x=window("").something.....getroproperty("text") then
do like -
Datable.export("path where u want to see the data")
set datatable.value(x,1)

try this ,if you face any probelem then let me know.I have
another way for this also.

Is This Answer Correct ?    4 Yes 0 No

How do you export an output to a excel sheet? Ex: I get my answer by using Msgbox"..." &..

Answer / madhavi

We can capture the proprty of the message box throug
getroproperty("innertext").Pass this to a variable.After
that use MID function to retrieve 'R'.After that we can
create an external excel object and pass the value to that
sheet.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More QTP Interview Questions

In how many ways we can add check points to an application using QTP.

4 Answers  


How should i get name of the screen? Ex:There is a "submit" button.If i clicked on the submit button it opens a screen. I want that screen name.How can i get that screen name I dont have any property regarding that screen. If suppose we cliked on the screen , Then QTP captures the screen properties then i can get the screen name by using GETROPROPERTY But i want the screen name without clicking the screen. ("I am using the "settoproperty" for Second screen by using fist screen properties") Please tell me anyone

3 Answers   Livetek,


Hello, I am facing problem to check textpoint for mercury application . I have inserted checkpoint to check flight summary for place of departure and arrival with datatable and script look like "Browser("Find a Flight: Mercury").Page("Book a Flight: Mercury").Check CheckPoint("Book a Flight: Mercury_4")" but while I am executing this script at last my check point gets fail and display Text Checkpoint: captured "" between Summary and 4/31/2008FLIGHT , expected "Acapulco" Match case: ON Exact match: OFF Ignore spaces: ON I think value from data table is not fatched so please guide me what I have to do to overcome this problem.. Thanks

0 Answers  


Hi, Hope you viewers are doing fine with good health. What are the steps and connection parameters to connect to Oracle db ? Can you connect with just the Oracle client or Oracle XE ? Cheers!!

0 Answers   Infosys,


Hi. GetRoProperty and OUTPUT Value Both are same purpose or not? plz explain in deatil with example?

5 Answers  






Approach for Installation,comaptibility,system testing

0 Answers   Diebold,


how to create user defined functions in QTP? can any one expalin me with example.. Thanks in Advance for help

4 Answers  


How good are you in writing VBscript code for your application? Can you completely write VBscrit for your project with out using recording mode in QTP?

3 Answers   CTS,


Other than using import sheet statement for importing the data from excel sheet, is there any other method that can be used?

2 Answers  


Hey friends i m facing a problem when i m running my script in qtp it waits for about 5-10 secs before starting execution why it is so can any one solve my problem .Previously it was running fine

1 Answers  


what are the disadvantages of qtp? can linux support qtp9.2? how could get web address throu vbscript?

6 Answers   Quintegra,


how to get childobject from .net application. i tried but its showing child object count zero. but window has child objects.the following script i written... pls help me how to get. set parent=SwfWindow("winodw name") CheckObjectDescription parent, SwfButton Public Function CheckObjectDescription(parent, oDesc) Set oDesc = Description.Create() oDesc("micClass:").Value ="Swfbutton" Set children = parent.ChildObjects(oDesc) cntObj=children.count msgbox(cntObj) End function

1 Answers  


Categories