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

How do you call windows APIs, explain with an example?

0 Answers  


what is the testing high level architecture

0 Answers   Wipro,


how can u do web testing?exactly what is the process for web testing?

1 Answers   IBM, Keane India Ltd,


What is parameterizing?

0 Answers  


can anybody please send me important scripts in qtp

1 Answers  






Other than Regression testing where can also it can be used.

2 Answers  


while recording web application the functions are generating as set_window, menu_select_item. my qts is how the web functions will be used either typing manually or will be created by WR while recording? eventhough i selected web add-in. pls. guide me

1 Answers   Wipro,


What are the two modes of recording?

0 Answers  


My husband had stampped h1b visa and was valid for another 1year. problm is that he lost his pasport in travelling and we got new one in tatkal scheme. and so we applied for restamping and my dependent (h4)visa. As per immigration team petition will be the same only stamping has to b done.. what questions will they ask and what are the chances to get it aproved?? pl reply

1 Answers  


winrunner supports .NET technology or not?

4 Answers  


what are the supporting development environments supported by winrunner

1 Answers  


How to use winrunner?

3 Answers  






Categories