Interested to Buy Any Domain ? << Click Here >> for more details...
I am using excel sheet to export data to QTP but it
selects just one row of data from excel sheel how to import
all rows of excel sheet to QTP during runtime
- 10 Answers
- 48444 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / uday kumar_anem
Here i am sharing a small snippet script, to import the
data from Excel sheet to QTP during runtime and using the
values.
I have an Excel sheet which contains OrderNumber column and
its values. After that i am displaying the order numbers in
excel during runtime.
datatable.Import("E:\Programming Samples\QTP
Samples\OrderNumbers.xls")
datatable.GetSheet(1)
rowCount=datatable.GetRowCount
For i=1 to rowCount
datatable.SetCurrentRow(i)
val=datatable.Value("OrderNumber","Global")
msgbox(val)
Next
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak
Pls can anyone give me the entire code for the Keyword driven framework with respect to he Flight Reservation Window in detail with explanation. Pls explain in detail stepwise. Thanks a lot. Pls very urgent?.
How many types of parameters are available in quicktest professional (qtp)?
How does you test a weblink which is changing dynamically?
Explain the difference between check point and output value?
What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)
ACTUALLY I AM WORKING IN THE DISTRIBUTION DOMAIN.MY COMPANY IS PROVIDING DISTRIBUTION SOFTWARE FOR PHARMA AND FMCG DISTRIBUTORS.HERE I AM USING QTP 9.2.HERE IN MY APPLICATION WHILE RECORDING ONE WINDOW APPEARS.IN THAT I CAN SELECT THE ITEM OR NO NEED TO SELECT.BUT WHILE RUNNING THE SAME SCRIPT THE WINDOW MAY NOT APPEAR OR APPEAR.HOW TO WRITE SCRIPT FOR THIS
Where is the resultset of a sqlquery (which is fired by rsobj.open sqlquery,xxxx,xxxx) stored ?
How the exception handling can be done using quicktest professional?
How you can make an action as re-usable action?
How to use transactions in qtp?
i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.
If u r using library files (Instead of Check Points) , How do u do bitmap check ?
Can the user toggle between using Local OR and shared OR for the same action?
