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

what is use of the object repository?

4 Answers  


Hi all please solve this.It is urgent..... When I right clicked on a Web image manually It displayed Open link,open link in new window,save picture as, Email picture,Printpicture,propeties...etc. While automation I have written a code like this 'browser("Google").Page("ramseeker®: Memory and_3").Image ("graphOfModel").Click 10,10,micRightBtn But the right click menu was not displayed. I want to save that image in a seperate folder

6 Answers  


Can Any One Write How to Write the Script for Child Objects

4 Answers  


How to compare source and target database in testing? Can anybody please tell me in detail the procedure how to compare it?

1 Answers  


How to run a script from lines 50 - 100 alone (if the script has 1- 200 lines of code)?

6 Answers  






Which object model ur used in ur project

2 Answers   Cap Gemini,


Reverse a string keeping the words in the string as it is. E.G. "Quick Test Professional" O/P "Professional Test Quick"

5 Answers   Cap Gemini,


I'm quite new at QTP. Im doing a web-based app testing. I create something new item and a new link is created in the home page. This link is dynamic as it changes every 3 seconds. Obviously the new link is not in my Object Repo and I am trying to find a way how can I do a check or get the propery of the link I created. I can do it on keyword, but I need to do a check on expert mode, vbscript. I always get an error that is not identified whenever i try to check it (browser(b),page(p).link(newlink). Any idea?

4 Answers  


I want to know can we integrate visual source safe tool with QTP and QC for our version controlling process? WE know QTP and QC 10.0 version is having the version control inbuilt in it but I want to know the merits and demerits of the inbuilt version control tool and the visual source safe tool using QTP and QC.

0 Answers   Wipro,


Under what conditions would you recommend QTP for future projects?

1 Answers  


Pls can anyone give me the descriptive programing script to find the number of edit boxes in a login window in flights reservation (windows application only not web). Pls anyone, very urgent

1 Answers  


How to differentiate the webedit field like user name and password? Please tell any other best answer is ther

3 Answers   Navis,


Categories