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

Hi Frenz... I would like to take up the QTP certification . Can anyone tell me what is the procedure. n if anybody have the study materials pls fwd it to jkpunathil@gmail.com

0 Answers  


where we save the scripts created in one project?

6 Answers   IBM,


Deal All, Recently i face one interview question in one company. str="test12@#3456" In This i want to print like special character and numeric ,word in one script please tell me how to write the code for this Thanks Balaji

1 Answers  


What is the "Release Notes", what it cosists? Key components in Release Notes ?

2 Answers  


Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris

0 Answers  


Explain quicktest professional testing process?

0 Answers  


how do check the links in a webpage ?

7 Answers   Accenture, Wipro,


If you have given 1000 manual test scripts, what test you will do? and how?

2 Answers  


wt is playback facilityin qtp?

2 Answers   IBM,


with out using import sheet came is it possible to get the excel sheet ?

2 Answers   Ordain Solutions,


Plz Explain AUTOMATION REFERENCE MODEL?

0 Answers  


difference Between Call Run action and copy of action?

1 Answers  


Categories