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
---------


Answers were Sorted based on User's Feedback



Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / narayan

u can create a column name call result status in the data
table.if test iteration is passed then put "PASS" else
Put "FAIL" in the datatable. onces execution complete u can
check the pass & failed one then import it in to excell or
notepad.
For getting total test case numner,use datatable.rowcount.

Still if you any questions tell me know

Is This Answer Correct ?    3 Yes 1 No

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / ravikiran

i want to copy results in qtp to excel or word how is
possible pls tell me through qtp only?

Is This Answer Correct ?    3 Yes 1 No

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / 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

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / ch

# 1 u can create a column name call result status in the
data
table.if test iteration is passed then put "PASS" else
Put "FAIL" in the datatable. onces execution complete u can
check the pass & failed one then import it in to excell or
notepad.
For getting total test case numner,use datatable.rowcount.

Still if you any questions tell me know


Narayan can u pls tell the process of adding the data to
data table.and how we will know weather iteration is pass
or fail?

Is This Answer Correct ?    1 Yes 1 No

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / sirisha

If u want to convert the Test Result from QTP.
Follow the process
1.Open the report
that is test result template
right click on that report
u have an option says that export to excel
so that al lthe data releasted to the report is posted into
excel sheet

Is This Answer Correct ?    2 Yes 2 No

Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Ca..

Answer / hari

If u use this script the results are stored in u r excel
sheet in u r result column.

If browser("Yahoo").page("Yahoopage").webbutton("Login")
Exist Then
datatable.value("result",3)="Pass"
browser("Yahoo").page("Yahoopage").webbutton("Login").click
elese
datatable.value("result",3)="Fail"
End If

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More QTP Interview Questions

How many tables r created during the recording in QTP?

2 Answers  


What is meant by Repository?

7 Answers   ALFiNE IT Solutions, Four soft,


Explain how you can find length of array in qtp?

0 Answers  


please give me the code for doing retesting of gmail login page using functions so the function has to give the value

0 Answers  


How do you do batch testing in QTP, if so explain?

2 Answers  






wht is the difference between action and functio?

3 Answers  


What are the Features & Benefits of Quick Test Pro ?

1 Answers   Crea,


How do u write script in qtp? where do u write?

2 Answers  


hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.

0 Answers  


How do you capture tooltip using QTP?

0 Answers  


In a webtable, lets say there are 10 records and 1 column. let say "image" is available for 1st,2nd and 3rd records and 4th onwards image is not available. How to recognise for that cell image is available or not?

2 Answers  


How you perform smoke and sanity testing using qtp?

1 Answers   Tech Mahindra,


Categories