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

explain all the check point in QTP?

1 Answers   BirlaSoft,


from where we will retrieve data for data driven tests in qtp?

3 Answers  


what is the diffrence between script and Language ? (Chandana)

6 Answers   Cognizant, Wipro,


how to compare two bitmaps( 1. clients requirement & 2. Designed by dev) in qtp 8.2 wann clear steps

0 Answers  


What is test object model in quicktest professional (qtp)?

0 Answers  


hi, In A Table there are some columns and dynamic rows and in each row in first column there is a link with name. upon clicking on that link it will show some details. write the vbscript to check that link without descriptive programming?

2 Answers   HealthAsyst,


if interviewer asked about the framework used for automation how we will handle the question..means what should be the answer..plz help..which framework u r used in our company?

1 Answers   iGate,


How many types of recording modes in qtp? Which will be used when?

0 Answers  


What are the flaws in water fall model and how to overcome it?

0 Answers  


How to connect the remote desktop using QTP 9.2 explain the method or procedure?

0 Answers   Magna Infotech, Oracle,


While scripting do we use any reference. may be we have 2 0r more same objects that time how do we write scripts

2 Answers  


Hi Frenz... I would like to take up the QTP certification . Can anyone tell me what is the procedure. n if anybody have the study materials pls fwd it to jkpunathil@gmail.com

0 Answers  


Categories