Once we get the Test Result from QTP.,I Have to convert
into Excel file format..Is it possible..Can any gudie me
regarding this...

For Example :

Total Test Case is : XXXXX
Test Case passed : XXX
Test Case Failed : XXX
--------
Total XXXXXX
---------


Answer Posted / kishore

first creat an object to excel sheet
Set fso1 = CreateObject("Excel.Application")
Set objExce2 = fso1
for m=1 to n 'here m is row value
objExcel2.cells(m,1).Value=" Test Case Passed" 'here 1 ia
coloumn value
else
objExcel2.cells(m,1).Value=" Test Case failed"

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different properties of an web object

1430


can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com

1763


What is an object repository?

612


Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.

1613


why should we give deliver good quality software?

1630






What is the difference between per-action and shared?

592


what is review

1616


I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...

1723


Explain different checkpoints in qtp.

723


Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.

2427


What are the different attribute used with regular expression?

537


we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?

1583


What is the difference between QTP and WinRunner? Why do you choose only QTP for automation among remaing tools like Rational robot and silk test? Write the VBscript for any functionality in your project ? What is the cost of QTP ? If you entered into yahoo mail with your valid user name then you will get FOR EXAMPLE , " welcome to krishna " on the top of inbo page , how can you test it in QTP? What type of testing you can do, when we gave you 5 screens and how can you test that application? What type of framework you are using in your company and explain it?

1797


What is action? How many types of actions are there in qtp?

616


Can anyone pls tell me in realtime (descriptive programming) how will the properties of the object be given to the test team. R they given in an excel sheet and is the same sheet also given to the development team and by whom is this given? Thanks a lot.

1566