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

Hi, Can any one explain what is mean by Driver Script? is it AOM?

4 Answers   CTS,


Hi, Can we open a test in qtp10 which is saved in qtp 9.2?

0 Answers  


What is ‘object spy’ and what is the function of object spy in qtp?

0 Answers  


How many types of status are there?

0 Answers  


Why to use descriptive programming?

0 Answers  






How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.

5 Answers  


How to use Environment parameterization? Explain with an example.

0 Answers  


Explain measuring transaction.

0 Answers  


What is the difference between QTP 8.2 and QTP 9.2

1 Answers  


How to create runtime property for an object?

7 Answers  


what is recovery scenario in QTP? what is the need of the recovery scenario in QTP? what are the advantages of the recovery scenarios in QTP?

3 Answers   CTS,


you written some code in qtp for opening google.com browser and entered some text inthe search text box and clicked search button. this is ur script.. before running this script i have already opened two google.com browsers. now am running the script what will happen? script will run or what?? Thanks... Nani

4 Answers   Oracle,


Categories