Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

what is option explicit? what is the use of it?

9 Answers   Syntel,


How to run an integrated test scenario using Multiple Actions? How to use the QTP Step Generator?

0 Answers  


What is the default add-ins in qtp?

0 Answers  


hi i have one doubt i have 4 yrs exp in testing and iam working one mnc in north but i have completed my degree correspodene is the companies are accept in south side some people are tellig they won't agree but i need correct answer plz let me know which companies are taking and not taking thanks in advance

8 Answers  


QTP identifying the child tabs in a maintab like tab_1,tab_2,tab_3,tab_4 while using a for loop for these tabs.its not proceeding from _1 to _2. How can i use "for loop "

2 Answers   Livetek,


Explain the concept of object repository and how qtp recognises objects?

0 Answers  


HO DO U CALL A ACTION?

3 Answers   BirlaSoft,


7. Given scenario is like this: One Web table is there and you have to search and retrieve a cell data which is equal to the given number say:123. Assume you have given with the column name/id of the table where the number may exist. So now you have to go to the given column and search for the number 123 and retrieve it along with the row number of it.

4 Answers  


Hi, How Accessibility checkpoint in QTP can be implemented in the test script?

0 Answers  


what is action in QTP?

1 Answers   Infosys,


How to use regular expression in descriptive programming?

0 Answers  


what's the difference in between function and sub and give some code as well

3 Answers   Patni,


Categories