Interested to Buy Any Domain ? << Click Here >> for more details...
If the data is stored in Excel sheet(2nd and 3rd), how to
access it for Data Driven test;
Ex: table = "c:\demo.xls"
How to access 2nd or 3rd sheet data id demo.xls flie.
- 1 Answers
- 4864 Views
- MBT, I also Faced
- E-Mail Answers
Answer Posted / uday kumar. a
Dim excelObj,counter
counter=1
Set excelObj=createobject("Excel.application") 'Excel Object
Set wbObj=excelObj.workbooks.open("c:\demo.xls") 'work bood
object
Set wbs=excelObj.activeworkbook.worksheets("sheet2") 'work
sheet object
while not isempty(excelObj.cells(counter,1))
x=excelObj.cells(counter,1).value
msgbox(x)
counter=counter+1
wend
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get the resolution settings?
What is the use of gui map and what happens when gui map file get loaded?
How you integrated your automated scripts from TestDirector?
What is the difference between gui map and gui map files?
When it is appropriate to change physical description?
How do you maintain the document information of the test scripts?
What is the purpose of regexp_msw_class property?
What are data driven tests?
what is risk?
What is the use of virtual object wizard and how it is used?
What is tsl? What 4gl is it similar too?
What information is contained in the checklist file?
What is the purpose of gui spy?
How to check the background colour of the screen in WR?
i would like to know the steps to write tsl exception and object exception with a simple example
