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
- 4877 Views
- MBT, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the modes of script recording in winrunner ?
How do you filter the objects in the gui map?
Name the different types of checkpoints?
write a compilemodule function for loginscreen.
i would like to know the steps to write tsl exception and object exception with a simple example
What is the difference between gui map and gui map files?
Explain the winrunner testing process?
What is the purpose of different record methods?
How can withwin runner to make single scripts which supports multiple languages?
Name the three modes of running the scripts?
What are the different modes of recording in winrunner?
What do you verify with the gui checkpoint for single property and what command it generates, explain syntax?
How do you clear a gui map files?
i this is priya speaking, any 1 tell me project detail for NETBANKING and HELTHCARE pls send to this E-MAIL ADDRESS; (priyadharshni2@yahoo.com)pls qik, thank u once agajn.
How to to get the information from the status bar without doing any activity/click on the hyperlink?
