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
- 18102 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 |
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
hai friends i already ask this question but when i post the question the alignment goes wrong .....my question is we have a WEB TABLE ....assume that web table having 3 row's and 3 column here in 2nd row 3rd column having VISIT FACEBOOK link...now i want to check the VISIT FACEBOOK link is available or not ..if it's there i want to click the link ...then how to find the web table row or column count ....don't write the excel or data table script here friends .....consider that it's a WEB TABLE do a favour ...thank's
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
Why you are Using Descriptive programming instead of Object Repository?
How to explain a banking project in interview as a test engineer???
how would you go for testing a web application like any jobsite?(using manual n qtp)..pls frnds its very urgent ..i need realtime answers...thanks in advance
How to export data in excelsheet to qtp without using datatable.
what type of run time errors you get while you ar edoing rpg program?
How to add multiple values in rows, under a single column of a run time datatable?
who is the best faculty in HYD? Nageshwar rao or GC reddy?
how to do the batch testing in test director using manual testing procedure?
hi friends i have 4 yrs exp in testing and 2 yrsexp in QTP.currently aim working in mnc in north as a permanent employer .iam looking for job in south is there any openings plz let me know my mail id is bjr@aol.in its very urjent
WinRunner 
