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.
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 |
what are the different modes of executing TSL Script
Have you performed debugging of the scripts?
hi i am unable to do select the flight in the flight table like list_select_item ("Flight",v_Select_Flight); v_Select_Flight=19072 LON 08:00 AM LAX 10:00 AM AF $161.90 why it is happining pls clarify me doubt
in which file Data of a Table is stored for further analysis
How do you recognise Active X components in winrunner?
list out the some of the exceptions list usually occur while recording and playing the script.
How do you maintain the document information of the test scripts?
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.
What is contained in the GUI map?
how to test online application
How to calculate the edit field length
How can you do debugging in winrunner?