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

I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.

1719


In qtp, explain what is qrs file?

581


Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com

1346


Why to use descriptive programming?

561


How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?

612






Give the syntax to load function at run time.

621


How QTP identify the system time that's changes every seconds?

590


How to use setroproperty?

568


How you will rate urself in QTP in the range of 0 to 5

1743


Can the user toggle between using Local OR and shared OR for the same action?

554


How can you write the scripts that operate on different objects depending on run-time information?

2114


How to handle Java tree in QTP?

742


i have doubt suppose iam purly working in manual, when i will get work to do on sql and performence testing? pls any one clarify doubt?

1552


What are the advantages of Object Repository?

585


breef description of batch testing ?

1705