1.how can we report the QTP test result in a different excel sheet 2.

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

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

1.how can we report the QTP test result in a different 
excel sheet
2.

Question Submitted By :: Guest

I also faced this Question!!

Rank

Answer Posted By

Re: 1.how can we report the QTP test result in a different excel sheet 2.

Answer
# 1

'Parameterization ... Data Table (Global Sheet) for Flight
Reservation


Invokeapplication "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"
'or
'SystemUtil.Run "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"

Dialog("Login").WinEdit("Agent Name:").Set
DataTable("Agent_Name", dtGlobalSheet)
Dialog("Login").WinEdit("Password:").Set
DataTable("Pword",dtGlobalSheet)
Dialog("Login").WinButton("OK").Click

If Window("Flight Reservation").Exist then
Window("Flight Reservation").WinMenu("Menu").Select "File;Exit"
DataTable.Value("Act_Res")="Pass"
Reporter.ReportEvent 0,"Login Details","Valid Values"
else
Dialog("Login").Activate
Dialog("Login").WinButton("Cancel").Click
DataTable.Value("Act_Res")="Fail"
Reporter.ReportEvent 1,"Login Details","Invalid Values"
End If

er=DataTable("Exp_Res",dtGlobalSheet)
ar=DataTable("Act_Res",dtGlobalSheet)
If Strcomp(er,ar)=0 Then
	DataTable.Value("Remarks")="OK"
	Else
	DataTable.Value("Remarks")="Defect"
End If
DataTable.Export("D:\QTP9\LoginResults.xls")

Note: Create a data table in QTP and enter the following details
Agent_Name  Pword    Act_Res  Exp_Res  Remarks
puneeth     mercury           Pass
pooja       mercury           Pass
soumya      mareiou           Fail
mahesh      miaoreu           Fail
shivakumar  mercury           Pass

Is This Answer Correct ?

5 Yes

0 No

Puneeth

Re: 1.how can we report the QTP test result in a different excel sheet 2.

Answer
# 2

'Parameterization ... Data Table (Global Sheet) for Flight
Reservation


Invokeapplication "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"
'or
'SystemUtil.Run "C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight4a.exe"

Dialog("Login").WinEdit("Agent Name:").Set
DataTable("Agent_Name", dtGlobalSheet)
Dialog("Login").WinEdit("Password:").Set
DataTable("Pword",dtGlobalSheet)
Dialog("Login").WinButton("OK").Click

If Window("Flight Reservation").Exist then
Window("Flight Reservation").WinMenu("Menu").Select "File;Exit"
DataTable.Value("Act_Res")="Pass"
Reporter.ReportEvent 0,"Login Details","Valid Values"
else
Dialog("Login").Activate
Dialog("Login").WinButton("Cancel").Click
DataTable.Value("Act_Res")="Fail"
Reporter.ReportEvent 1,"Login Details","Invalid Values"
End If

er=DataTable("Exp_Res",dtGlobalSheet)
ar=DataTable("Act_Res",dtGlobalSheet)
If Strcomp(er,ar)=0 Then
	DataTable.Value("Remarks")="OK"
	Else
	DataTable.Value("Remarks")="Defect"
End If
DataTable.Export("D:\QTP9\LoginResults.xls")

Note: Create a data table in QTP and enter the following details
Agent_Name  Pword    Act_Res  Exp_Res  Remarks
puneeth     mercury           Pass
pooja       mercury           Pass
soumya      mareiou           Fail
mahesh      miaoreu           Fail
shivakumar  mercury           Pass

Is This Answer Correct ?

0 Yes

5 No

Prasad

Re: 1.how can we report the QTP test result in a different excel sheet 2.

Answer
# 3

Prasad If u know the answer write else dont do any 
thing.Dont copy the answers.

Is This Answer Correct ?

2 Yes

0 No

Ravi

Question	Asked @	Answers
Other QTP Interview Questions


Hi, I want to retrieve the cell data in the WebTable. For that I have defined a new test object under the browser and have given html tag and text as the test object properties. But while I try to identify it it says 'Object description is not unique'. I tried adding innerhtml, outerhtml, innertext and outertext along with the ordinal identifiers; but no use. What more properties need to be added to identify it? Also I want to enable smart identification for this object but the field is disabled in the object repository for this object alone(In QTP tools->object identification the enable smart identification checkbox is enabled). How do I enable it?		1
How can we log a defect in Testdirector from Q.T.P ?	EDS	2
what is the silent mode in WR?		1
How can we make a shared object repository in QTP 9?	Ordain-Solutions	3
What is the difference Between LowLevel and Normal Recording Modes?		1
Have you used TD?		1
What is keyword driven Testing Framework. Anybody can explain it in details... Pls anybody can give the answer.. Thanks in advance...	Navis	1
I am a beginner plz tell me,how do we write scripts in QTP? In my opinion we can write scipts in expert view or there is another option where we can write scripts. plz tell me.		5
what type automation is fofollowed in the project?	Satyam	1
suppose i can done the project , that project have 4 modules in that one module they have many links(web pages).in that time i can say i can work on some links? or total module?		4
anybody give me the real time example for descriptive programming of web application		4
IN EXCEL SHEET OF qtp SUPPOSE I ENTERED 10 NUMBERS RANDOMLY I HAVE TO GET TOTAL OF TEN NUMBERS IN THE 11 COLUMN USING qtp GIVE CODE TO IT USING qtp		2
in QTP, we have options like (record and play,recording modes(normal,analog,low level),object identification,smart identification,object repository,synchronizing test,transactions,checkpoints(std,bitmap,text,text area,DB,XML,accessibility),regular expression,actions,data driving,parameter,parameterization,data tables,recovery scenario(pop up,object state,test run error,application crash). real time users of QTP, pls say and when and at what point u have used all these options ,in ur concerned project.pls give me explanation in accordance with ur real time project handled. real users pls send some time in the aboue case. if u can send the the reply through allinterview or at ref_it_ref@yahoo.co.in		1
Tell me the QTP Advantages and Disadvatages ?		1
WHAT IS THE USE OF "FUNCTION GENERATOR" IN QTP?	CTS	7
To count the no of links present in the yahoo home page i have written the script like this Set fileSysObject=createobject("Scripting.FileSystemObject") Set linksFileName=fileSysObject.opentextfile ("D:\samplelinkfile.txt",2,true) Set linkDescObj=description.Create linkDescObj("micclass").value="Link" Set noOfLinks=browser("yahoo").Page("Yahoo! India").ChildObjects(linkDescObj) For i=0 to noOfLinks.count-1 linkName=noOfLinks(i).getROProperty("name") linksFileName.writeline(linkName) Next linksFileName.close Set fileSysObject=nothing While running the script it showing error that object "yahoo"isnot found in the object repository. Is there any setting before running the script? if yes what is the steps for it.Im using QTP9.0		2
suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query	IBM	1
from what stage you will start automation in your project	TCS	4
How to handle exception when data table is not available in local host system or path is not correct(explain statement with example)		1
what are the qtp tester responsibilities?		2

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