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

what is selective recording ? and normal recording?

1 Answers   iSoft,


WHAT IS THE USE OF "FUNCTION GENERATOR" IN QTP?

2 Answers  


I have a drop down box to show selected number of records in result page.It contains 4 items like 10, 25,50 and 100. when i was recordes script for seelcting each item and checking selecting number of records in the result page( it is in the same page in the table format)it is generating a new page with same controls( objects) in the OR. how to avaid these in OR? is it possible to write DP for only these lines?, remaining(remaingin lines of code) objects i want use from OR only. One more problemis if change ( add /remove properties of an OBJECT in OR , my ( recorded )application is not running.

5 Answers   Virtusa,


Object recognition in QTP is based on which model ? a) COM b) DCOM c) DOM d) None of the above

2 Answers   Ordain Solutions,


How to convert non-reusable action into reusable action in QTP?(i know by default QTP will take it as a non-reuable action )(Chandana) plz urgent?

4 Answers   Wipro,


What is descriptive Programming in qtp.

5 Answers  


What is the diff between doing parametarisation using Data Driven wizard or manually. when do we go for manual para...and when do we use Data driver wizard..can anybody answer it ..Thanks in advance

6 Answers   Siemens,


Can anyone explain about Keyword driven framework in detail and how to use it in case of any project

4 Answers  


what is QTP batch testing tool?

2 Answers  


What is the Test Object model in QTP?

3 Answers  


Hi! Using Descriptive Programming How do we get Parent object for an object by writing script(DP). Say, i want to get a parent object for a "Link" in a web page by writing script in Descriptive Programming.

0 Answers  


How to take screenshots in qtp?

2 Answers   Sonata,


Categories