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.
- 1 Answers
- 4962 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 |
what is the regular expression for dd-mm-yyyy?
What is the extension of gui map file?
i'm using WR 8.2 version to test a form developed using ORACLE10g. The problem i'm facing is, the form has number of edit objects in that only two objects are not able to recognize by WR while running the script. ( if i FIND that object in the GUI File it highlights the object but if i press SHOW button not able to recognize) can anyone tell me the reason for it??
What is a checkpoint and what are different types of checkpoints?
Wat is the defferances between Test plan and devolopment plan?
How to calculate the edit field length
How to set a value in to a data table from the script in winrunner?
what is modul? and differ btwn testing and debugging
What is Syncronisation in Winrunner?
How to to get the information from the status bar without doing any activity/click on the hyperlink?
The default type of Constants and variables supported by TSL are..
Have you used winrunner in your project?
WinRunner 
