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
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 |
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 |
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 |
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 |
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 |
How many tables r created during the recording in QTP?
What is meant by Repository?
7 Answers ALFiNE IT Solutions, Four soft,
Explain how you can find length of array in qtp?
please give me the code for doing retesting of gmail login page using functions so the function has to give the value
How do you do batch testing in QTP, if so explain?
wht is the difference between action and functio?
What are the Features & Benefits of Quick Test Pro ?
How do u write script in qtp? where do u write?
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.
How do you capture tooltip using QTP?
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?
How you perform smoke and sanity testing using qtp?