Hi, how can we retrieve a specific value from Excel Sheet
(Not datatable. for externel file).i mean to say from .xls
file.
and also tell me from xml file and .doc file.
and how can u parameterize ur script from .xls file.(Not
data table).
- 2 Answers
- 7657 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / nidhi jain
first you need to import datatable
Datatable.import("datatablename with path")
after importing table you need to call get method
Datatable.getCellData('columnname','datatable type')
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("» County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma
What are the advantages of Object Repository?
What does mean by Scope of Automation?n How we defined it?
How to Upgrade or support firefox 2.0 version on QTP 9.0? I have installed QTP 9.0 and installed firefox 2.0. But in REcord and Run Settings, it shows firefox 1.5 in Web tab for browser selection.
banking domain description for software tester for interview
breef description of batch testing ?
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
How many types of trigger events are there in qtp?
How is test case write?
How to use actions in qtp ?
What are the common defects found in your project? (in qtp interview)
what is clean sweep?
When and why to use descriptive programming?
What is difference between design time and run time data table?
What is a programmatic description?
