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 is the automation process in winrunner?
what is the use of Step into option provided in WR?
hi, this is balu. I looking for testing job. I want qtp software . any body have . pls send mail to me dont forget. send a mail to me kool.balu@gmai.com
What is Data Driven TEsting?
is 'Vendor' is a Reserved in WinRunner or not?
What is the extension of GUI check points check list file?
What is the difference between writing a function and writing a script?
what is mean winrunner and load runner
Hai guys can any one tell me tnhe difference between the product testing and Project testing?
What is the use of gui map and what happens when gui map file get loaded?
what is the advantage of INOUT parameter over OUT parameter?
Where are test cycle folders created if TSL Script is not saved