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

We have 10 page.In first page we 2 popup and next page we 3 popup window......(windows name is different)how can we handle the all the popups without using recovery scenario

3 Answers   IBM,


I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible

0 Answers  


anybody wants to learn QTP with realtime implementations and complete framwork contact to this mail id ciraaj@gmail.com

1 Answers  


How to create Reusable and Multiple Actions?

0 Answers  


Suppose I have three hyperlinks with same properties. How to solve this and what are the ways to solve this. we can solve this by using index property but what are the other ways we have have to solve this problem. Login (href: btnlogin.aspx) Login (href: Sourcelogin.aspx) Login (href: homelogin.aspx)

0 Answers  






Hello, How can i capture first letter of any string using QTP. For ex.. i want "j" in the below string "john" could any one explain me? Is there any function for that?

4 Answers   Livetek,


If i entered 2 columns and 4 rows inputs in DDT Like Mango fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q is How to get the 2nd column value for corresponding 1 column input in 3rd row ie, ( i need to get "veget" in messge box @ run time

5 Answers   CTS,


I want to create Excel object on another machine which is in network i written the code "Set se=createobject ("Excel.Application","\\ankur")"here \\ankur is the name of that machine but i m getting the error of permission denied create object can anybody help me

2 Answers  


what is the Exact Meaning of Environment Variables?

10 Answers   AppLabs,


Why QTP is termed as a Record and Playback tool?

1 Answers  


Flight reservation using input and output parameter script.

1 Answers  


How to Analyze the Checpoint results by Table and DB Checkpoints?

1 Answers  


Categories