Once we get the Test Result from QTP.,I Have to convert into Excel file f

Advertise your Business Here

Refer this Site

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test 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 ?

0 Yes

0 No

Narayan

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 ?

0 Yes

0 No

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

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

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 ?

0 Yes

0 No

Kishore

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

Question	Asked @	Answers
Other QTP Interview Questions


wht is the difference betn check point and output value?	BirlaSoft	4
what is vmodel?advantages and disadvantages of vmodel?	AZTEC	2
Wher to use DATA TABLE METHODS in Qtp?What is the use of it?	Wipro	3
pls help me with scripting,right from the beginning in QTP		1
How to call script1 into script2?		3
Explain about reusable actions?	IBM	2
HOW TO DO THE BATCH TESTING USING QTP?	Ordain-Solutions	2
for example one window is there, the window contains how many edit box's i want script? i know the script but that is not exact answer.... The script is like this .......... set a=description.creation() a("Native class")="WinEdit" b=window("Flight Reservation").childobject(a).count msgbox b		2
In what situations QTP will not recognize the Objects?	Wipro	4
What is the use of Accessibility check point?		2
How to check the value for variables during run time. Pls anybody can give the answer.. Thanks in advance...	Navis	2
wt is memory leakage?	BSL	5
i have opend 2 gmails i am working with 1 gmail i want to close other gmail by usig script. 2.i have 10 links in a page all of them have same properties& names i want to click on 5link by using script. 3.i have one combobox in that i want to see all the citynames in the combobox and i have to check weather hyderabad is present or not. 4. size of objectrepository. 5.what r problems we get during writing the script. 6.is it possible to compare to excel sheets in qtp if possible wht is the script. 7.example for lowlevelrecording	Semantic-Space	2
WHAT IS THE FRAMEWORK & ARCHITECTURE OF YOUR PROJECT	Wipro	2
How we can add actions in the test using QTP?		1
WHAT IS THE USE OF "FUNCTION GENERATOR" IN QTP?	CTS	7
In Test Director bug rEPORTS, wHAT ARE THE CONTENTS(fIELDS)? iF yoU PREAPARE BUG REPORT IN eXCEL sHEET , hOW U SEND TO dEVELOPMENT TEAM THRW T.D?		1
What is the Dynamic Scenario in QTP? And also anybody give the example for this?		3
The interviewer asked me when u recorded one application.object repository properties are saved with .tsr extention. in qtp expert view wherever mouse is there that snapshot displayed in active screen but some recored script lines are not displyed in actives screen y?	IBM	2
I am using excel sheet to export data to QTP but it selects just one row of data from excel sheel how to import all rows of excel sheet to QTP during runtime	Wipro	8

For more QTP Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

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