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

Take a situation when you are working with QTP, suddenly system has crashed.so you again start the system. My questyion is how can QTP directly opened when the system desktop appears.

1 Answers  


Please explain about unicode compatibility in QTP. how we can able to use it. Please help me

1 Answers  


how i will connect oracle or microsoft acess database through manually written Script

2 Answers   Aurigo,


What is quick test pro? What is a quick test professional?

0 Answers  


How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet

0 Answers  


What is descriptive programming?

15 Answers   Wipro,


how qtp identifies objects of application.

5 Answers   Intel,


Mention the test steps of qtp.

0 Answers  


Which object model is not supported by QTP? a)COM b)DECOM c)DOM d)DCOM. Pls explain about theese object models?

1 Answers  


I want to do QTP Certification what is the pattern of Question paper.

0 Answers  


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

0 Answers  


How to track the execution time?

2 Answers  


Categories