ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
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
                   ---------  


 Question Submitted By :: Srinivasan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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 ---------
Answer
# 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
 
Is This Answer Correct ?    1 Yes 0 No
Narayan
 
  Re: 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 ---------
Answer
# 2
# 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 0 No
Ch
 
 
 
  Re: 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 ---------
Answer
# 3
i want to copy results in qtp to excel or word how is 
possible pls tell me through qtp only?
 
Is This Answer Correct ?    1 Yes 0 No
Ravikiran
 
  Re: 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 ---------
Answer
# 4
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 0 No
Hari
 
  Re: 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 ---------
Answer
# 5
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 ?    1 Yes 0 No
Kishore
 
  Re: 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 ---------
Answer
# 6
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 ?    0 Yes 0 No
Sirisha
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
What is Virtual object wizard in QTP?  3
what is the Command used to start the QTp from Run.(start-> Run) GE4
what happen in object repository(shared)if we call an existing action from an external action ? and what happen in object repository(peraction)if we call an existing action from an external action ? Covansys2
how to tell about testing a website in interview using qtp?? what r the points to be covered mainly?  2
What is your role and responsibilities in QTP with your current organization?  1
what is debugging testing?  4
What is the difference between Call to Action and Copy Action.?  2
what is risks of testing a project? AppLabs4
I need diffrences between Object Identification, Smart Identification, Regular expresion,Low-Level Recording (enables you to record on any object in your application, whether or not QuickTest recognizes the specific object or the specific operation.) I am working on Web Application. In that object caption will change dynamically. For example, consider “Save” button. On clicking save button the caption changing as “ EDIT ”. From above concept which concept I have to use here? Ordain-Solutions2
How open an excel sheet in QTP(not a run time )? Tech-Mahindra1
How can i open 5 multiple browser at once through QTP VB script and i want to login with 5 different credentials i already tried with this code but its entering credentials only for first browser and am using datatable to parameterize  1
hi all i have qtp 9.0, Active screen is not working means after recording script snap shots not displayed in Active screen window. i have all ready check all setting means Tool...>option...>Active screen...>Default Level button is disabled. Is there other setting is remain to set Pls help i m new for qtp  1
How do you invoke an application using the step generator in qtp?  5
How do we edit the script in QTP. Anybody can explain in detail..Thanks in advacne... IBM2
what is purpose of automation?  2
How do u insert an object during runtime in qtp?  2
Synchronozation types in QTP Diebold10
How to capture data from images in QTP and produce them in Excel sheet ? please ans... Sapient2
w is datatable CTS5
can we use QTP for load testing instead of load runner?  3
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com