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.
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 difference between toggle checkpoint and checkpoint?
Which are default codes winrunner generates when we start the application?
How to break infinite loop?
When do you feel you need to modify the logical name?
you hae a inbox and got a mail how can you know it is there or not write script.
What is the purpose of set_window command?
How do you find out which is the start up file in winrunner?
how can you explain your Real Estate Project in front of interviewer..? please step by step......
What is the use of gui map?
What is the purpose of gui spy?
What is the purpose of different record methods?
How to integrate automated scripts from testdirector to winrunner scripts?
Explain the purpose of different record methods?
Where do you found that you can't use winrunner for automation?
What all are the different databases winrunner can support?