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
- 4552 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 |
Can we run WinRunner scripts on the backend?
what is the key combination to terminate script execution
What is T_Exit and T_return?
What is database check points? how many types are there?Explain?
The GUI MAp Editor or Rapid Fire test are not learning the GUI of any window or any object..The pointer conevrts to hand and everthing hangs till i don't press Ctrl+Alt+Del. Help me!!!
how can you explain your Real Estate Project in front of interviewer..? please step by step......
How do you do digital signature test in winrunner?
1,You have scripts in Qtp8.2 and some scripts 9.0 ..how to handle ?
How many exceptions are there in winrunner and what are they?
In the Object properties MSW id,MSWclass will appear..what exactly MSW means..?
what is the gui map & gui map file in winrunner?
How to set a value in to a data table from the script in winrunner?
WinRunner 
