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

Explain measuring transaction.

590


HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is krishnuvk@yahoo.com

1541


How did you resolve conflicts present in Object Repository?

1618


Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji

927


What is checkpoints for quicktest professional (qtp)?

583






What is an expert view and keyword view?

574


How many add-ins comes by default with quicktest professional (qtp)?

564


How do you check ticket cost and ticket number in flight application?

591


To retrive the test data which tool vl use and whats basis u vl write test data? its urgent

1448


What are the different types of checkpoints?

591


i need to add 1000 users in a domain i written the script for that and it is running successfuly but the problem is that my system is not the user of that domain in which i have to add users so for adding users in that domain i have to install qtp on that another system, can anybody suggest me the way to add those users from my system ultimately i want to know how to access remote computer through script

1425


What are the two types of repositories available, explain them?

596


What are the features of quick test pro(qtp)?

539


how to do the batch testing in test director using manual testing procedure?

1778


What is the significance of “action 0” in qtp?

578