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...

  1. Categories >> Software >> Testing >> Automation Testing >> WinRunner
  2. Suggest New Category

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.


Question Posted / murali k


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 winrunner framework?

1 Answers   Agile Software, GE,

Which of the following, we cannot include in a compiled module? a)check points b)analog statements c)reporting statemnts

3 Answers   Belly,

How to close the winrunner window from the script itself?what is the code?

2 Answers   EDC,

what is custom check point? what is the diff.between custom check point and runtime Record check ?

2 Answers   Infeneon Technologies,

When Both Developer and Test Engineer conducting testing different?

1 Answers  

How do you maintain the document information of the test scripts?

0 Answers  

If we send the bug report but the developer didnt understood the bug report then will the tester do?

1 Answers  

What is the function in WR for replacing the existed data to blank?

1 Answers  

what is the use of generate script that is avaliable 3 places(file settings, tools, object identification)

0 Answers  

what is the extension of default,custom check points ?

2 Answers   FCG,

Explain the purpose of different record methods?

0 Answers  

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

1 Answers   Accenture, MBT,

For more WinRunner Interview Questions Click Here
Categories