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 does you test a weblink which is changing dynamically?
Explain the concept of how quicktest professional identifies object?
can we create recorset with out using database connection in vbscript?
Can anyone tell me how i used QTP 9.2 use for GIS based S/w with an example?
I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format, as i'm not in a possition to afford any 'Fee' to join in any institutions. Hence, if possible, kinldy mail PDF file to my mail-ID: chakri_avala@yahoo.co.in Regards, Chakradhar Yadav.
95 Answers Cap Gemini, Citrix, CTS, IBM, Logistics, QA InfoTech,
Is it possible to merge two object repository files in qtp?
can we test an windows application using qtp
In a QTP project lets say there are 100+ function library and incorrectly we have duplicate some function in multiple libraries. How to find those duplicate functions and remove them?
How to change the run-time value of a property for an object in QTP?
How do you invoke an application using the step generator in qtp?
what is difference between calling a function and reusing an action?
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