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
- 48370 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / jay desai
When you are importing an excel sheet into QTP, the
datatable defaults to the first row. Below is an example
that will help you importing all the data into QTP.
Dim jj,Rows
Rows=DataTable.LocalSheet.GetRowCount
For jj=1 to Rows
DataTable.LocalSheet.SetCurrentRow(jj)
.......
<Perform your operation>
.......
Next
'I hope the above code will work.
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
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
If I give some thousand tests to execute in two days what do you do?
I want two test two agents login for the flight website. Here is the scenario: I want to go through 1-3 rows for one user login and other user login I want to go though 3-5 rows. How would you set this up in qtp. Thank You
How you calling actions in qtp?
Is it possible to use two instances of UFT on the same machine? If not why?
How to create Reusable and Multiple Actions?
What the differences are and best practical application of Object Repository?
when u script reveiwing in which area u more concentrates?
What are the properties you would use for identifying a browser and page when using descriptive programming?
I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.
what is the hierarchy to use properties in descriptive programming
am not having intrest in coding lang like c c++ java etc can i choose Testing tools as my carrier and please suggest me which tool is good (suitable for me)
Which environments are supported by hp qtp?
hi to all, i need a code.. in flight application 1.i need to login first then i need to insert 3 new orders... 2.i have to log out 3.i have to login again with different user 4.need to insert 2 new orders 5.then need to log out 6.then again login with different user 7.3 new orders create and log out 8.but we hv to do this using data table and actions please help me
Both static and dynamic arrays are handled by the vb script. Is it true?
