Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 13231 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / niturao
thanks a lot siva for the explanation.
thanks pandu
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
How do we connect QC by using QTP?
How to handle Recovery scenario in QTP. give detailed explanation about recovery scenario.
in which case & which method we can use "native" property of an object ?
Differences between QTP & Winrunner?
Can u call txt extension file in QTP?
Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..
How many ways we can parameterize data in QTP?
What are benefits of qtp?
Explain abt the File System Object in QTP with ex
How to recognize and read data from pdf file using Descriptive Programming in QTP?
I AM TRYING PORT CODE FROM WINRUNNER TO QTP AND DON'T KNOW TO HOW TO CHECK THE ERRORS. IN WINRUNNER FUNCTION RETURNS EIGHER 0 OR -1 AGAINST WHICH RESULT CAN BE MADE PASS OR FAIL BUT IN QTP I DON'T SEE FUNCTIONS RETURNING ANY VALUE. APPRECIATE IF ANYONE COULD HELP ME CONVERTING FOLLWOING WINRUNNER CODE TO QTP. set_window("Customer Service"); rc = web_obj_get_text("Summary","#2","#4",ssn,""," ",1); if (rc != E_OK) { report_msg("[GetSubscriberSummary] Could Not get subscriber SSN; rc = "&rc); myRC = rc; } else { ssn = StripBlank(ssn); if (DEBUG) report_msg ("[GetSubscriberSummary] SSN: "&ssn); }
What’s the basic concept of QTP?
WinRunner 
