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
- 4785 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
How do you handle tsl exceptions?
What in contained in the GUI map?
What is the disadvantage of loading the GUI maps through start up scripts?
Name the two modes of recording?
What happens when the gui map file get loaded?
How enviornment veriable can be included into my script. I want to include some information into my Excel file using Test run in WR. like User name of system? waht is function to be used? Please clarify.....
What is the use of gui map?
When would you use 'set_window' and when would you use 'win_activate'?
What are the synchronization points?
Write test scripts on a scenario where you have to transfer data from one table to another.
What are the different modes of recording in winrunner?
What information is contained in the checklist file?
when start testing
What are different types of checkpoints?
What is the purpose of different record methods?
