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 qtp handles customised object

1 Answers  


how to check URL using QTP? write vb script with descriptive programm only?

1 Answers   Syntel,


Hi Guys...I just started working with QTP now.The frame work they use hear is Write all the functions in function libraries and pass data using data dictionary either from data table or excel .I kind of understood evrthing but one thing I need to know is How do they recognize objects .Do they use object spy and recognize objects or record them ..Does soemone have any idea how they generally do this is such kind of framework

0 Answers  


What is error handled other than recovery scenario manager?

2 Answers  


OR is full with objects but i want to add 5 more objects,but i tried merging files,shared mode and descriptive ,iwont work.is there any alternative for that

6 Answers   CTS,


How to get data line by line from web element

2 Answers  


How to pass parameters to Actions Pls anybody can give the answer.. Thanks in advance...

2 Answers   Navis,


Hi Friends, I have an application that is having some options to choose. While doing business transaction I need to select one option among from available options. But here the thing is, we won't get one option which we've chosen already and the available options will get automatically from the system with time basis, moreover each and every option having with various label names respective to that option. So obviously if I run my recorded script will automatically gets fail, even though it got pass at first time. Could anyone please give me appropriate solution for this. I would be greatly obliged with you if you give the solution as soon as possible.

1 Answers   Zensar,


In qtp,how to interact tool & application build?

1 Answers  


How to find Operating system information using QTP script?

0 Answers  


How to parameterize in QTP?

4 Answers  


will QTP 9.2 run successfully on Linux(gui) operating system

1 Answers  


Categories