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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

.have you ever written compiled module? if yes , tell me about some of the function that you wrote.

1790


how to find that tools work well with ur existing system?

1463


how can i pass a "cript"as a parameter in to a function

1543


what is the difference between built-i function and In-built function?

1729


Differentiate the type of test cases which can be automated and which cannot be automated?

663






what is the difference betn QTP 8.0 AND PREVIOUS VERSION

2057


What is an expert view and keyword view?

663


When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.

1751


how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?

2023


What is the use of sendkeys and what are send keys

2053


what is clean sweep?

1621


am not having intrest in coding lang like c c++ java etc can i choose Testing tools as my carrier and please suggest me which tool is good (suitable for me)

1360


What is an optional step in qtp ?

732


What are the flaws in water fall model and how to overcome it?

645


How to get the format of a webedit class in qtp. How can i know that particular webedit accept what type of format like "mm/dd/yyyy" or "$" or Alphanumeric

1740