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
- 4801 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
Why don’t we normally load the gui maps through start up scripts?
How do you make the configuration and mappings permanent?
Name the different modes of recording?
can i get apex technologies interview questions in testing
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
What is the purpose of regexp_label property and regexp_msw_class property?
Can anybody Explain me about the liasing with the developers,and a tester can make a test plan well?plz explain me as soon as possible ,thanx in advance.
What is the purpose of set_window command?
What is toogle breakpoints? How does it differ from break points?
what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance
Explain the purpose of different record methods?
you hae a inbox and got a mail how can you know it is there or not write script.
How do you clear a gui map files?
What Framework is suitable to validate the Login screen.
Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....
