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.




If the data is stored in Excel sheet(2nd and 3rd), how to access it for Data Driven test; Ex: tab..

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

Post New Answer

More WinRunner Interview Questions

What is the extension of gui map file?

0 Answers  


tell me about compiled module & function generator

5 Answers   CTS,


Hai guys can any one tell me tnhe difference between the product testing and Project testing?

2 Answers  


What is parameterizing?

0 Answers  


What are different types of checkpoints?

0 Answers  






what is the use of add-ins in winrunner?

3 Answers   MBT,


can any one provide some testing material?

2 Answers  


how u can crate a database checkpoint in ur script?

2 Answers   MBT,


Explain the use of test director software?

0 Answers  


What Is Test policy and what is Test Strategy ? differenciate between them? Explain with examples?

5 Answers   Accenture,


what is contained in the GUI check list?

1 Answers   FCG,


WHAT IS THE MEANING OF AUT?

2 Answers  


Categories