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
- 4866 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 |
How does winrunner Recognize Objects in an application?
What are the three modes of running the scripts?
Have you ever created a test plan?
What is a checkpoint and what are different types of checkpoints?
plz give me code or steps for pop up exception. or can u tell me how to pause test run for defining handler function?
plese tell me about vss?
we have three windows with title(logical description),India.com,Government of India.com,India Inc.com.All three windows have similar properties and object.A test script has to be run on all these windows.what changes will u make in GUI or script so that the script runs succesfully on all these three windows with the least alteration required? Please explain clearly with steps.
Hi iam a begginer or rather new stsrter to QTP and strugling to start as i have to start writing the automated scripts for the existing manual testing could some one send me some tips ans tricks for a jump start. Any help is greatly appreciated
How do you analyze results and report the defects?
How to fetch a value which is in a particular cell in a html table?
which TSl statement is used in winrunner to stop the Run
If I dont have GUI spy on my machine how I do I manage to map my custom object properties
WinRunner 
