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
- 4477 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 |
ON PROPERTIES IT IS DECIDED WHICH TOOLS TO BE USED AMONG QTP, WINRUNNER, RATIONAL ROBOT, TEST DIRECTOR?
What are the reasons that winrunner fails to identify gui object?
How does winrunner evaluates test results?
pls write test case for google and yahoo mail page. pls any body known the answer immediatly post the answer
What Framework is suitable to validate the Login screen.
what are the stages of software development life cycle?
5 Answers Agility e-Services, Trigent,
what is the extension of the gui expected results file?
can any body tell me in detail about ERP domine?
Have you ever written test cases or did you just execute those written by others?
Besides Record and Replay what else can we do with WinRunner?
Have you performed debugging of the scripts?
What is framework? If u dont have framework how you manage your automation?
WinRunner 
