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

give the code to count child objects (Total) in the page

1 Answers  


The xls contain data. how to get number of columns form the sheet?

4 Answers   Virtusa,


Could anyone please tell me one situation where you have used recovery scenarion in real time with an example?

4 Answers  


What are the most frequent errors you faced while executing your scripts?

1 Answers  


In QTP for .net application which plug in is used? For Java Application which plug in is used ?

2 Answers   AppLabs, Fraze Tech,


how to get the object property

4 Answers   Covansys,


what is stlc and its contents?

1 Answers  


What is QTP and the use of QTP in TD?

1 Answers   MaxSolPro,


what is Property......End Property loop? how to write sript for it in QTP

1 Answers  


What is time parameter?

1 Answers  


What r the diffrernt file extentions in QTP?

3 Answers  


Plz send one Tracebilitymatrix example? Anybody working on Realtime QTP Plz give contact deatils?

1 Answers  


Categories