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

Answers were Sorted based on User's Feedback



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

Answer / sunita

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 ?    5 Yes 3 No

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

Answer / pandu

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 ?    2 Yes 0 No

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

Answer / niturao

thanks a lot siva for the explanation.
thanks pandu

Is This Answer Correct ?    1 Yes 0 No

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

Answer / siva

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 ?    1 Yes 2 No

Post New Answer

More QTP Interview Questions

QTP9.1 does not support to text checkpoint in Windows application? Is this correct? If this is correct, what is alternative for Text checkpoint?

2 Answers  


What is the BPT(bussiness process testing ).and what is the main difference between BPT and QTP

3 Answers   EDS, GL Noble Denton, IIST,


I have a list box which contains duplicate values e.g. A,A,A,B,B,B,C,C,C.Now write a code in qtp to test the list box . Scenario #1 : I have to check whether any values are there? Scenario #2 : If duplicate values are there,then how many time it is getting duplicated? Svenario #3 : how can I test presence of items in list box ommiting duplicate values?

6 Answers   NIIT,


Give me brief idea about QTP automation object model?

5 Answers   TCS,


How to create a Runtime property for an object in QTP?

6 Answers  






how to click the link in webpage by using QTP Script????????

3 Answers  


write a script for allinterview-submit Question first we've to select Choose Category,second select Sub- Category(Which is comes in to runtime)third select Question Type.for that give some descriptive and vb script

0 Answers  


in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?

2 Answers   Polaris,


what are the disadvantages of qtp? can linux support qtp9.2? how could get web address throu vbscript?

6 Answers   Quintegra,


what is use of the object repository?

4 Answers  


in how many ways we can write the user defined functions one way i know that i.e storing it in .vbs another way i does not know my friend said that .qtf or something but start with q letter can any buddy knows about this

3 Answers   DigiTech, Infotech,


can anyone please tell me what are all the shortcut keys used for qtp9.2? Thanks in advance..i expect ur valuable reply that help us our team???

1 Answers  


Categories