Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 are the different attribute used with regular expression?

0 Answers  


Object repositories types, which and when to use?

0 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,


Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?

0 Answers  


In an output value text checkpoint, where does the output value stored by default ?

4 Answers   Ordain Solutions,






give one example where you have used regular expression?

6 Answers   Ordain Solutions,


I need Major Help with a Script I recorded in QTP 9.5. I am recording scripts for a Web-based application(s) I have all the URLs for each application in Excel spreadhsheet so that QTP can pull that particular application from the spreadsheet and run it. The problem is QTP isn't recognizing one particular URL so when I hit run in QTP to run this script it opens the internet Explorer but isn't open the URL I have in the Excel spreadsheet. I've retyped the URL and still QTP won't open this Particular one for some reason. The site its self is working fine but for whatever reason QTP won't open it. How do I resolve this? I have a deadline of next Friday the 7th to complete this task so please help me in any way you can. Thanks in advance

0 Answers  


what type automation is fofollowed in the project?

1 Answers   Satyam,


what is the difference between call to copy action and call to an existing action

5 Answers  


How can i select multiple values from drop down list using vb script in qtp? and wt is the script for clicking msg box box automatically with a specific time. Thanks in advance...Kalyani.

2 Answers   Accenture, CSC,


Iam trying to write script for Rediffmail Page,in doing so the script line for go button is not accepting. Is their any other way other than . Browser("micClass:=browser").Page("micClass:=Page").Link ("micClasss:=Link","name=go")

2 Answers  


How to export QTP results to an ".xls" file?

3 Answers  






Categories