how to parameterizing values from an excel sheet in Quick test
professional?

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


Please Help Members By Posting Answers For Below Questions

What are the differences between quicktest professional and winrunner?

538


Differentiate the type of test cases which can be automated and which cannot be automated?

567


Which scripting language used by quicktest professional?

530


If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?

1440


In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail

1501






.have you ever written compiled module? if yes , tell me about some of the function that you wrote.

1682


How to use debug tools?

2198


what is key word driven frame work ? why it is called like that ? what is the diference between keyword driven and data driven frame work ?

1554


How QTP support all types of applications (platforms)?

4081


How do you send email with attachment from outlook using qtp ?

563


How to use conditional loops in qtp ?

589


How to modify object property in qtp ?

565


How to release all resources file from the QTP?

1055


How would you directly trigger javascript in a test?

1473


Explain the concept of object repository and how quicktest professional recognises objects?

560