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 use the QTP choose the data from oracle? e.g. i input the identity card NO. this will be add new record in the database ,and now i want get this record's prime key.

0 Answers  


How to enter table check points?

2 Answers  


wht is the difference between action and functio?

3 Answers  


Please explain me i am using QTP 9.5 ,i am creating re usable scripts,i have to pass data from one local sheet to another local sheet.for example i am creating emploee information, (data is in action 2 local sheet),In this data table emplyeee number will get,i have to pass employee number to another reusable script search data (action2 local data sheet)

2 Answers  


PLZ EXPLAIN HOW TO LAUNCHING QTP IN TEST DIRECTOR? Is it possible or not? If No Why we r using qtp Td Combination? plz explain briefly? What is the purpose of TD With QTP?

1 Answers   Wipro,






How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.

0 Answers  


in my database haveing 3X3 (manas having 3 rows 3 colums) i want to test only (2nd row 3colum) bit how to test either script or any automation plz explain? (Chandana)

8 Answers   IBM,


How can I find out the cursor position through QTP suppose I am keep tabbing(Pressing the tab key continuously) and stoped at a position Now I want to find out where the cursor position is

0 Answers   HP, Livetek,


Can any body please tell me the steps of keyword driven framework of QTP.

0 Answers   TCS,


Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19

0 Answers   Value Labs,


can any body pls mail me latest FAQ's in QTP to my mailid btrintra@gmail.com....Thanks in advance

0 Answers  


Explain different types of checkpoints?

0 Answers  


Categories