how to parameterizing values from an excel sheet in Quick test
professional?
- 1 Answers
- 3065 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabarinath
set excelsheet = createobject("excel.application")
set workbook = excelsheet.workbooks.add
set sheet1 = workbook.worksheets(1)
sheet1.cells(1,1) = "admin"
sheet1.cells(1,2) = "admin"
workbook.saveas("C:\excel1.xls")
Browser("").page("").webedit("username").set sheet1.cell
(1,1).value
Browser("").page("").webedit("password").set sheet1.cell
(1,2).value
workbook.close
excelsheet.quit
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
When should I use smart identification?
When we r doing data driven test with chkpts, i want to insert formulae in data sheet but i didn't get. How we wil do that plz. explain in detail.
How we can use the database checkpoint on a java web based application in which the database connectivity is done using JDBC->Pure Java type (in this type there is no need to create a DSN). At present in QTP we can fetch database values using checkpoint only through DSN. Is there any programming for this if we don't have DSN (ODBC)
HOW AUTOMATE TEST SCRIPT ? what time it will do? after gneration of basic script or Any , Plz explain detailed?
What is the difference between QTP and WinRunner? Why do you choose only QTP for automation among remaing tools like Rational robot and silk test? Write the VBscript for any functionality in your project ? What is the cost of QTP ? If you entered into yahoo mail with your valid user name then you will get FOR EXAMPLE , " welcome to krishna " on the top of inbo page , how can you test it in QTP? What type of testing you can do, when we gave you 5 screens and how can you test that application? What type of framework you are using in your company and explain it?
Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?
write a script for allinterview-submit Question first we've to select Choose Category,second select Sub- Category(Which is comes in to runtime)third select Question Type.for that give some descriptive and vb script
What is environment variable in qtp and why to use it?
What is optional step in qtp? How you can add optional step in qtp?
How does qtp recognize objects in aut?
How to start recording using quicktest professional (qtp)?
Can anyone tell me how i used QTP 9.2 use for GIS based S/w with an example?
What is the extension of qtp local repository?
How to get popup error message.
Can any one send me the QTP Basic Coding Samples?
