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
- 4518 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 |
how many checkpoints are provided by WR
How to integrate automated scripts from testdirector to winrunner scripts?
what is risk?
Can anyone tell me the real usage of compiled modules and user defined functions stating real time example
How do you create a new expected results in winrunner?
what is the TSL statement to find current systsem date?
what is the difference between toggle checkpoint and checkpoint?
what is the main diff of Qtp9.2 and 9.5 plz tell me
how many options are provided in WR login screen
The title of the window consists of date and time.What is the regular expression to recognize the window as unique?
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.
in which file Data of a Table is stored for further analysis
WinRunner 
