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 / 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 |
What id DB Folder? when it will be created and what it consists?
How do you find out which is the start up file in winrunner?
what is mean block box and white box testing. pls give exact example in the question
How would you define a "bug?"
Hai guys can any one tell me tnhe difference between the product testing and Project testing?
What happens when the gui map file get loaded?
Is it possible to run a WinRunner script without using GUI Map file? If yes how?
what is the tsl statement for selecting the position of item in list box in winrunner?
descriptive program for web application.
how to write the pass or fail message in winrunner for eg: in QTP we can write like "Reporter.reportEvenr,micDon,"Test Test pass"
Where to use the public or private functions in your script?
Where are the expected results will be stored?