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
- 4486 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
What is the disadvantage of loading the GUI maps through start up scripts?
Write test scripts on a scenario where you have to transfer data from one table to another.
What is parameterizing?
Where do you found that you can't use winrunner for automation?
plz give me code or steps for pop up exception. or can u tell me how to pause test run for defining handler function?
How do you unload the GUI map?
soft key for virtual object wizard ?
Explain the purpose of loading winrunner add-ins?
What is the purpose of different record methods?
Name the different types of checkpoints?
i would like to know the steps to write tsl exception and object exception with a simple example
How do you suppress a regular expression?
When would you use 'set_window' and when would you use 'win_activate'?
What are the Win Runner tools for functional testing?
Explain the purpose of gui map configuration?
