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



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

Answer / 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

More QTP Interview Questions

How to call .vbs functions in QTP? plz Explain indetail

4 Answers   Wipro,


how do close the task manager through QTP?

2 Answers  


Have you used TD?

2 Answers  


How many types of recording facility are available in quicktest professional (qtp)?

0 Answers  


Have you used xml check point in your project?

0 Answers  






Explain about Test Fusion Report of QTP?

0 Answers  


we have 5 default properties we want add more Default property in Object Repository how to add the property

2 Answers   Nous,


what is Action conversion tool? what the Action conversion tool will do?

1 Answers   Satyam,


How to carry out bit map check points in QTP

0 Answers   kenexa,


One build is delivered. in that build button name is submit. but in the next buit that name of the button changed as login.are u continue with previous recorded script or u make any changes?

6 Answers   Covansys,


How to check the value for variables during run time. Pls anybody can give the answer.. Thanks in advance...

4 Answers   Navis,


How to catch the TOol Tip Dyanamically changing values using the qtp script by Descriptive Programming Scenario: ======== 1. when i press the submit button 2. The Tool tip first shows the value "Validating...." 3. Next the value is changed in tooltip "Logging....." ------ And the class is webElement SO , how can i catch both values During Run time using Dp

1 Answers  


Categories