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

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 is GapAnalysis? i am not getting the coorct answer for this question still now.

3 Answers   Semantic Space,


What is the purpose of temp. GUI map file?

3 Answers   Logica CMG,


Can we use the user defined functions (which inclues script with GUI functions) in Compile module? Example: public function MyGuiFun() { set_window(?Browser main window?); button_press(?OK?); } If yes. pls give some example, how to handle...!

1 Answers  


How to convert Manual Test script into Automation Test Script?

1 Answers   Mind Tree,






WHAT IS THE MEANING OF AUT?

2 Answers  


what is the extension for WR files?

10 Answers   AppLabs,


Hi,i cleared the first round in Microstrategy and my second round(project manager) is scheduled so can any one tel me what r they asked and gv me some steps how i wil tel them?

1 Answers  


Can anybody Explain me about the liasing with the developers,and a tester can make a test plan well?plz explain me as soon as possible ,thanx in advance.

0 Answers  


How do you handle pop-up exceptions?

0 Answers  


In Analog mode of Recording in WinRunner,the maximum value of Y in (x,y) is ?

3 Answers   FCG,


What is the difference between STATIC FUNCTION & STATIC?

2 Answers   Fidelity, Satyam,


Categories