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

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

Question Posted / prasanth

3 Answers
12987 Views
SAP Labs, Virtusa, I also Faced
E-Mail Answers

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

what are all the fileds present in object repository?

0 Answers Wipro,

when to start the automation?

0 Answers Accenture,

What is difference in global and action sheet in qtp?

0 Answers

Name the different types of recording modes?

0 Answers

1.How to record ,capture and also script to capture the close buttons. 2.How to record ,capture and also script to capture the options ---File ->save and File ->close in a browser and PDF files. 3.How to compare the Excel sheet values in a report using QTP scripting. 4.How to compare 2 PDf reports using QTP scripts as well reording. 5.How to compare 2 Excel reports using QTP scripts as well reording. 6.How to save a PDF report to a folder and then translate the report to an Excel type of report and compare that Excel Report with an other excel report. Please clarify me

0 Answers

what is selective recording ? and normal recording?

1 Answers iSoft,

what are the limitations of automation testing?

2 Answers TCS,

I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...

0 Answers

What are Test case selection criteria for Automation?

2 Answers

Can we create user defined functions in qtp?

0 Answers

Is it possible for QTP to capture the objects in word document.If so please give me the code.Thank you.

2 Answers

Wht are the BY default Add-ins in QTP 9.2 version and what all are differences between 8.2 and 9.2

2 Answers Siemens,

For more QTP Interview Questions Click Here