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
- 4072 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
Explain the purpose of loading winrunner add-ins?
What is the purpose of regexp_label property?
what is qtp licence
How do you find out which is the start up file in winrunner?
Explain the winrunner testing process?
What is the purpose of a gui spy?
What are the virtual objects and how do you learn them?
How to find the local host name using winrunner ?
What is the purpose of set_window command?
How to read the third party controls in the application
Could you anyone share me the path to download the automation tools which are having trial license version?
How do you execute your tests from windows run command?
How do u check FONTS in Login Window?
What is toogle breakpoints? How does it differ from break points?
How do you handle pop-up exceptions?
