Interested to Buy Any Domain ? << Click Here >> for more details...
How to get data from excel sheet to the script? write the
script.
- 6 Answers
- 24789 Views
- Ever, Liquid Hub, I also Faced
- E-Mail Answers
Answer Posted / jyothi
Set a= Createobject("Excel.Application
Set b = a.workbooks.open"D:\Keyword\Test Data\data.xls"
Set c = b.Worksheets("sheet name")
Then retrieve the data like
set x= c.cells(1,1).value
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
when to start the automation?
What is qtpro?
Hi there, I've installed a trial version of QTP to see if it works with my product but I cant automate selecting windows from a tree view? Can anyone give me any pointers? Many Thanks
how to use the regular expression for the below code-- swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:56" There is a tree view window of the folder's ie Medication- >Pharmacy(sub folder)with 56 as count of records...The records can be different or if no records present in the specific folder..then it show "Paharmacy:-no records".Whe i record at the first time .....and try to rerun the same script with different records count say "pharmacy:800"..qtp is not regnizing it...therefore i want to user regular expression..but donot now how to use it and where to use...i have tried.... swf("application name").swftreeview ("Treename").select"Medication;Pharmacy:\*"..but it s of no use..plz help..me
Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link
How do you delete unwanted results in qtp?
I have developed and executed a script successfully, and saved the same to QC. When I tried to execute the script from QC, the script is not executing. What are the possible reasons?”
whenever U using QTP,Test Director, Why we using separate Bug tracking tool?
What test you perform mostly? Regression or retesting in your testing process?
Problem with XML checkpoint in QTP ?
Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19
what testplan contents and what test strategy contents,what is the diff b/w them
What is regular expression?
Can we record using all the modes in a single script? Explanation with example is appreciated
When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.
