Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 testing high level architecture

0 Answers   Wipro,


what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance

0 Answers  


How to use winrunner?

3 Answers  


if a test script is parameterised with the same value ,and run what effect will it have in terms of performance for testing the application.will the script get executed faster or there is no effect at all.

1 Answers   Wipro,


Tell US the Short key to open the dialogs of windows.

1 Answers  


why you are doing software testing, why testing necessary

2 Answers  


Which Key is pressed to toggle between Analog and Context Sensitive Mode?

3 Answers  


What is the use of test director testing tool?

0 Answers  


how are objects identified by winrunner

4 Answers   Google,


The extension of the Script file is .mts ok Whis is stand for mts?

4 Answers  


what are the different modes of executing TSL Script

3 Answers  


Wat is the defferances between Test plan and devolopment plan?

3 Answers  


Categories