how do u import the test cases written in excel sheet to qtp? and how do

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

how do u import the test cases written in excel sheet to 
qtp? and how do u generate the script in qtp for the 
testcase in excel sheet? plzzzz do answer this question 
thanks in advance

Question Submitted By :: Niturao

I also faced this Question!!

Rank

Answer Posted By

Re: how do u import the test cases written in excel sheet to qtp? and how do u generate the script in qtp for the testcase in excel sheet? plzzzz do answer this question thanks in advance

Answer
# 1

1.goto QTP
2.datatable.Addsheet "xyz"
3.datatable.import"C:\a.xls",1,3
1 is source sheet of a.xls
3 is destination sheet of xyz
a=datatable.getsheet(3)

Is This Answer Correct ?

1 Yes

2 No

Sunita

Re: how do u import the test cases written in excel sheet to qtp? and how do u generate the script in qtp for the testcase in excel sheet? plzzzz do answer this question thanks in advance

Answer
# 2

Sunita's Discussion was something about Importing some test 
data in to the data sheet of QTP by that data we can 
conduct RETESTING by a process called parameterization (or 
else we can create For loops...) but Nitu Rao's Question is 
about test cases, they were already written in Excel sheet 
and importing in to QTP test pane to automatically generate 
script for those test cases....
The answer could be...
1) Let me take a test case for Login, written already in 
Excel sheet===Enter valid inputs in to User Id and Pass 
word. enter "ok" button....this is the test case and let us 
not worry about the Actual and Expected values and so on
2) Let me "write" the script for the same scenarion of 
Login:
if the login is a dialog box...then
Dialog("Login").WinEdit("Agent Name:")Set "niturao"
Dialog("Login").WinEdit("Passwrod:")Setsecure "*****"
Dialog("Login").WinButton("OK").Click

here what I would like to emphasize is We must "write" the 
Script in QTP or the script can automatically be generated 
only during RECORDING.
so, if you import test cases in Excel sheet I THINK IT 
WOULD NOT WORK. only test data can be imported.
I think you got it
sivaprasadnunna79@yahoo.co.in

Is This Answer Correct ?

0 Yes

2 No

Siva

Re: how do u import the test cases written in excel sheet to qtp? and how do u generate the script in qtp for the testcase in excel sheet? plzzzz do answer this question thanks in advance

Answer
# 3

Yes Siva, The solution what ur given is correct.

Hi Niturao, The Excel sheet contains manual test cases. so 
QTP don't undestand what ur writen in ur manual testing. If 
it is a VB script u can download from qtp and run not 
other. So u want to prepare the test scripts in QTP 
separately. like what siva given. or simply u can record 
tests.

Is This Answer Correct ?

1 Yes

0 No

Pandu

Re: how do u import the test cases written in excel sheet to qtp? and how do u generate the script in qtp for the testcase in excel sheet? plzzzz do answer this question thanks in advance

Answer
# 4

thanks a lot siva for the explanation.
thanks pandu

Is This Answer Correct ?

0 Yes

0 No

Niturao

Question	Asked @	Answers
Other QTP Interview Questions


hello everyone, can anybody please tell me what are the different recording modes of QTP, and where these recording modes are present in QTP 9.2. Thanks in advance, Gaytri		7
Tell me Three major differences between QTP & Winrunner?		5
I installed QTP 9.5 on vista. Can someone please provide me the license key of the same. Thanks, Avi		2
1) after inserting the check point how to change the expected value that was captured while inserting the check point	TCS	2
Can any one tell the different properties and values of differnt objects like Browser,Page,link,webedit,webcombobox,webradio botton,webcheckbox and web button.Because I am facing a lot of problems in interviews with Descriptive Programing.I never worked on web Application...Pls help any one as soon as possible....		2
How we can add actions in the test using QTP?		4
Give me an example where you have used a COM interface in your QTP project?		1
Suppose U change the script whether it affect the object properties of the object in the object repository	IBM	3
How to import excel sheet to QC?		1
Check point what is how many types of checkpoint and explain	Accenture	2
take one example and write vbscript on one web application in qtp? explian descriptive programe with one example?	IBM	2
I am using Shared OR, and my collegues are also using Shared OR. How to merge Object Repositories?		6
After running scripts how you report results ,there is any specific report form		1
what is the difference between call to copy action and call to an existing action		5
hi all need one help . i want scroll down and up but thing the holl page is taking webtable. i need to scroll down and up using scroll tab any bodu knows plz help its urjent regards balaji		5
How do u write script in qtp? where do u write?		2
I have 5 no.of Action in my Test. Out off which i should make 3rd action as my start-up action. How should i make it?		1
How should i find out whether the cursor is moving horizantally. when tabbing continuously	Livetek	2
While creating Recovery Scenario for Pop-up window..In 'Recovery operation' we have to call a function. Can u tell me that function.	Ordain-Solutions	4
How do u write regular expression for a window name which is changing for each build ? i.e. in first build the window name is : "computer graphics are very ...." . in second build the window name is : "computer graphics can be created" . - Appreciate proper replies	Semantic-Space	4

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