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

How to Identify broken links in QTP

2 Answers   Ness Technologies,


What is the use of "New Property" in "Add properties" of testobject properties in object repository. How can i use "New properties" while writing scripts if i have assign some values to the testobject properties Can anyone help me? plz

0 Answers   Livetek,


How to add synchronisation points in qtp?

0 Answers  


What is the difference between qtp and selenium?

0 Answers  


How do you find out whether the string is Numeric or Alpha numenric.Suppose..'QTP is an automation testing tool 12345' How should I know it is alphanumeric.Can any one please write the code for this

4 Answers  






Few basic questions on commonly used Excel VBA functions.

1 Answers  


When we use 'ERR' object to handle the exceptions in the script, do we need to include any statement in the beginning of the script..??

2 Answers   DST Global Solutions,


Hi, I am learning QTP. can someone please tell me a site from where i can learn QTP scripting Thanks in advance

0 Answers  


I am just a beginner in QTP. Could any one explain me in detail how to automate adding two numbers and getting the result in QTP. Also I would like to parameterize the inputs. I have tried but getting an error like 'Can't use sub.....'(can't recollect the exact error)

2 Answers  


In the QTP the snap shots obtained during the recording time will appear in the active screen, if we have to use the snapshots from where we have to access. in which memory location of QTP they will be stored?

1 Answers  


What do you mean by checkpoints in qtp?

0 Answers  


What is the latest version of QTP? aster googling i found it 9.5 . but somewhere in my frnds resume i hve seen 10.0 so i am a bit confused pls let me know.

4 Answers   NCR,


Categories