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 can I check the font size and color using winrunner?

3 Answers  


what are the default addin?s provided by WR

2 Answers  


How many Record Methods are there in Winrunner?

6 Answers   Accenture, Indicus Software,


What are the features r there in winrunner 7.6 over winrunner 7.01..B'cos Iam using Winrunner 7.01

2 Answers  


how can we make use of virtual object wizard to identify similar object can u explain with an example

2 Answers  






how u can connect database without using any wizard in winrunner?

1 Answers   Accenture, MBT,


Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....

0 Answers  


How do you analyze results and report the defects?

1 Answers  


Can anyone explain me abt Winrunner Automation framework in detail and what r the steps involved in it

1 Answers  


can u explain what is frame work,can u show it on the paper by drawing ,have u done the frame work in winrunner automation

1 Answers   Cap Gemini,


what happens when the script is executed in verify mode

3 Answers  


what sould come under "tell about ur self"? need tempelate

3 Answers  






Categories