How can we redirect QTP results in to a excel sheet after
the execution

Answers were Sorted based on User's Feedback



How can we redirect QTP results in to a excel sheet after the execution..

Answer / sambasiva rao.m

By default it creates an XML file it displays the results

Is This Answer Correct ?    4 Yes 2 No

How can we redirect QTP results in to a excel sheet after the execution..

Answer / gs

write the results in datatable & export the same

Is This Answer Correct ?    2 Yes 0 No

How can we redirect QTP results in to a excel sheet after the execution..

Answer / rayudu

You have to create a function for that for example



Pass the below values

strTCNo=23 (Test Case No)
strResult=Pass (Result
public function FnTcStatus (strTCNo,strResult)


DtRwCnt= DataTable.GetSheet("Result").GetRowCount

For l=1 to DtRwCnt
DataTable.SetCurrentRow(l)
If DataTable("A","Result")=strTCNo Then
datatable.Value("TC_Status","Result")=uCase(strResult)&"_"&
Now()

End If
Next

strTcNo=""
strResult=""


end function

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More QTP Interview Questions

distinguish between old version and new version QTP features.

0 Answers   CTA,


What are the difference between QTP and Winrunner

5 Answers  


the question was on what techonlogy u been working on i said VB then he asked me the addin for VB in Qtp?

4 Answers   BirlaSoft,


What is QTP’s model for test creation?

0 Answers  


what is flag=0 in qtp tool.. i am strugglin to use flag function , exactly when it is used , any real time expert pls explain clearly?

1 Answers  






How to create Userdefined Function.Please write the steps ans also provide example where exatcly we use it.

1 Answers   HP,


Can anybody post some real time scenario in qtp? please its very urgent.

0 Answers   Kanbay,


What is the difference between CVS and VSS? Are you store QTP SCRIPT In VSS OR CVS? Where you store QTP Script?

1 Answers   Brain Roots, Ordain Solutions,


in process of project exaplnation the defects are says frequently r not?

1 Answers  


How to apporach while starting the automation testing?

3 Answers   Patni,


I had created the new virtual objects for web application buttons. how to add those virtual objects into object repository. Previously i had used Gui map in winrunner for capturing virtual objects for web application. Please help me regarding this. need your answer quickly

1 Answers  


How to call a function in QTP?

4 Answers  


Categories