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

Will QTP gets installed on virtual PC.What is the maintenance number to be given

1 Answers  


How to Test the mainframe application?(tell me few basic things)

1 Answers   Covansys, IBM, UST,


if you run one test script in internetexplorer the same test you run in mozilla ffirefox is it possible or not how is it.

1 Answers   Satyam,


Hi, How to export the Checkpoints and Output values(Test area output values) from Object Repository to Excel

3 Answers   Wipro,


we are submitting data one form to another form.defaultly it is time period set as 5sec. but it is taken 15sec what to do

5 Answers   Covansys,


I am not finding pages and links in object spy on web testing. I am only getting window and winobject. where is the problem? thanks

4 Answers  


What are associated files in QTP?

2 Answers  


what is the purpose of QTP?

2 Answers  


How to count no of edit boxes on the page?

3 Answers   IBM,


In QTP how can we recognize objects Without using Object Repository?

3 Answers   IBM, Wipro,


I am getting an error "failed to open the XML checkpoint result viewer" in result window,after clicking on "View XML checkpoint results".Someone suggest me settings,if any...

0 Answers  


hi study this carefully,WHO ARE TEACHING WITH THE HELP OF FLIGHT RESERVATION WINDOW...THOSE FACULTIES ARE VERY BAD...BUT WHO ARE TELLING WITH PROJECT ORIENTED MEANS(NOT FR WINDOW) DIRECTLY OPEN THE BANK WEB PAGES OR ANY OTHER REAL TIME WEB PAGES... BASED ON THAT WEB PAGES, FACULTY TEACH, IN THIS WEB PAGE WHEN UR USING QTP , WHEN UR USING MANUAL... WHERE UR WRITING THE SCRIPTS FOR THIS WEB PAGE.. .LIKE THIS ................THIS IS THE TEACHING FORMAT FOR QTP... 1ST U FIND OUT WHO IS FOLLOWING THIS TYPE OF FORMAT THOSE PEOPLES ARE .BEST FACULTIES AND JOIN THAT INST. THIS IS 100 % TRUEEEEEEEEEEEEE REMEMBER IT........ NOW ONWADS U HATE FLIGHT RESERVATION WINDOW ONLY REAL TIME WEB PAGES........... THAN KU

1 Answers  


Categories