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

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test Interview Questions

Automation Testing AllOther Interview Questions

Question

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

Question Submitted By :: Prasanth

I also faced this Question!!

Rank

Answer Posted By

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

Answer
# 1

By default it creates an XML file it displays the results

Is This Answer Correct ?

2 Yes

2 No

Sambasiva Rao.m

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

Answer
# 2

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 ?

0 Yes

5 No

Rayudu

Question	Asked @	Answers
Other QTP Interview Questions


what is the use of automation objective model?where is used? plz tell me		1
w is active screen	Wipro	2
Did you use flatfiles in your projects?At what situation you used it?How can you upload flatfiles?		1
What is the difference between "Call to copy of action", "Call to existing action" & "Call to winrunner action"?		2
what r advance features u had done in QTP?	HCL	2
Hi Friends, Every one is posting the Answers for the existing questions.Try to post the questions that are asked in Recent Interviews.It will be useful to the other Job seekers.		1
Tel me what was the automation testing process you followed?		2
What is throw object?		1
How to call a function in QTP?Is there any method ? Thanks , PRASANNA		2
How can I replace all the text from the QTP script with some other text. Is there any replace all function in QTP Any one can help me	Livetek	2
Difference between image checkpoint and bitmap checkpoint		2
can anyone proide me reading material on svit00ef27@yahoo.com please thanx in advance		2
using descriptive programming how to close all opend browsers?	Satyam	4
What scripting language QTP of?		4
What is the Difference between Environment variable and Globle variable,.. anybody can give me answer..Thanks in advance...	IBM	2
HI. Plz Clarifie my doubt,having 2+yrs experience in Testing , But My accedamics(Xth,INTER) are Less than 60%, But B.Tech 72%. It creats any problem , When i change to any MNC. plz tell me......... lot of friends told it's a problem, Some people says NO problem, What .............		3
Is it possible to convert QTP scripts to Silk scripts?	Sierra-Atlantica	2
How to change the scripts from Per-Action object repository to shared object repository		1
I have to do testing for XML file using QTP. 1. I was given a sample XML, I had to edit that with my actual data and had to make a new XML-- this part is completed, I did that. 2. Now I have to copy the exact contents of that XML file and have to paste it in a web application as a request message for web appliaction processing, using QTP. So I am unable to copy and paste it in web application, please help me out.		1
hi i have one issue while automating the script using QTP i want scrool down .i cannot do even using scrool down methqad is not working .the object will take WebElement plz is there any code help me		2

For more QTP Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com