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.
- 1 Answers
- 4096 Views
- MBT, I also Faced
- E-Mail Answers
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 |
1.Can we use multiple excel sheets in winrunner? 2.What is the templet of writing test cases? 3.Which bug tracking tool u r using in u'r company? 4.Can any one give me real time test case format? My mail id id shobha.mar28@gmail.com
3 Answers Cognizant, Infosys, Kaktus Info Solutions,
What is debug mode in Winrunner?
What are the different modes of recording in winrunner?
what is the difference between data driven test(ddt) and parametrization
7 Answers Agile Software, CTS,
how do you analyze the properties associated with object
How do you do digital signature test in winrunner?
For What are the browsers that WinRunner can Compatible? (I want Versions Like IE5.0 etc;)
How to do text matching?
For my web Application I am recording website by WR. but the fuctions are displaying normal recorded fun. such as set_window...etc. eventhough i selected web add-in at start up WR. how to use web functions? such as web_link_click.... pls. guide
What is the extension of gui map file?
How will u find Automation Test cases and how to find regression test cases?
what are types of black box and white box testing?
WinRunner 
