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

please send detail navigation for merging of object ripositories in QTP 8.2

3 Answers   Infosys, Ordain Solutions,


How to get data from excel sheet to the script? write the script.

6 Answers   Ever, Liquid Hub,


What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????

0 Answers   Infotech,


What is the use of text output value in quicktest professional?

0 Answers  


how to write vbscript on web applications in qtp. explian with one example?

4 Answers   Wipro,






Is there any vbscript in QTP for Data Driven Test instead of using the option provided by QTP?

2 Answers  


How can we display the names of the buttons in the toolbar of a webpage

1 Answers  


suppose i give valid user id and password to open an web base application on qtp.how qtp will know itis a valid user id and password

3 Answers  


Hai Guys, can anybody show me how to write automaed test cases using VB scprit(examples)...i had an interviw soon...please guyz send as quickly as possible

5 Answers  


How many add-ins comes by default with quicktest professional (qtp)?

0 Answers  


How to handle the exceptions using recovery scenario manager in QTP?

0 Answers   Crea, CTS,


waht is the difference between QTP 8.2 and 9.0 version

15 Answers   AppLabs, CTS, Polaris,


Categories