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
- 48713 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
If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?
How do you test the text displayed in the header portion of times of india epaper. Hot news(banner) are scrolling in the top of the page, how do you test using QTP?
What are the features and benefits of quick test pro (qtp 8.0)?
Hi, While recording a Jave based web application, its recording all my actions and the objects.And I have 5 WebEdit objects on the page and all are recorded. But while execution, at the 2 WebEdit object, its entering the value into the object (Its making a call to the AJAX, matching the value), when the control get out of this object the value is erased or cleared. Could anyone please help. I have recoreded 5 more scenarios where WebEdit is in the picture on different webpages and all are working fine. Here is my Script: Browser("Sign In").Page("Matching Workbench_3").WebEdit ("locationLookup").Set "0320 - SEATTLE-KM" Browser("Sign In").Page("Matching Workbench_3").WebEdit ("supplierNameLookup").Set "TRAMMO PETROLEUM INC" *** SupplierNameLookup is the object, which is haing an issue. And also I was using the SendString function, but it didnt work.
How can you close the second opened browser?
What are the different types of functions available in qtp and explain ?
Tell me about qtp?
How to add synchronisation points in qtp?
What is QTP scenario.
What are the methods used in UFT to handle exceptions or run-time errors?
There is an built in window application in qtp9.1,i.e.Flight4.0.i want to implement the recovery maneger on it.How can i do this?
How will you compare keyword and expert view?
For which type of project the iterative model is suitable?
What are the methods of the TextStream object that are used for reading from a text file?
How would you directly trigger javascript in a test?
