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
---------
- 6 Answers
- 17124 Views
- I also Faced
- E-Mail Answers
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 to pass parameters into an action.Please explain me with examples
How will you send values to a cell in a webtable using QTP?
What are the recording modes and executing modes avialble in QTP?
what is output value in QTP and how it can be used in automation testing
suppose u hav a 10 dialog or window opened on screen with same name & value. now how to test each window? i.e. how qtp indetifies these objects separately?
More details about keyword driven technique in QTP
i need code for how to click on particular mail in utlook mail box .its urjent Thank You Balaji
How can i open 5 multiple browser at once through QTP VB script
what is qtp automation frame work,what is the use of that frame work?
64 Answers Cap Gemini, IBM, iGate, TCS,
WHAT IS THE FUNCTION (HOW TO DO) THE BATCH TESTING IN TEST DIRECTOR USING MANUAL TESTING PROCEDURE?
What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop (i.e. I first connect to remote desktop from my machine in order to run the application). I am able to record the script successfully with QTP running on my machine and application running on remote. However, when i run the recorded script, system fails to run it and indicates me that it does not identify the object. Is it possible to record and play while QTP and AUT are not on same machine?
WinRunner 
