Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is the life cycle of QTP? Pls Give me Exact answer?

6 Answers   Google,


how can I read text in browser and export the same into text file?

5 Answers   HP,


we have 10 automation scripts. how to call them from one main script.

2 Answers  


What is the qtp testing process?

0 Answers  


If u r using library files (Instead of Check Points) , How do u do bitmap check ?

0 Answers  


Will down time for server and content maintenance/upgrades be allowed? how much?

0 Answers  


what is Unicode Compatibility ? HOw does this makes a diffrence from Winrunner.?

2 Answers  


Hi all, In Every interview interview asking one question what type of challenges you have been faced in your project?

1 Answers  


Can we check environment variable value without existing of environment variable

2 Answers   NIIT,


Can anybody give the script of below things. 1. Add sheet 2. Adding columns 3. Set the values in that columns(In the rows) 4. Close the sheet 5. How can we create 3 sheets in one Excel sheet??

2 Answers   TCS,


How to convert QTP's ObjectRepository.mdb file to xml file

1 Answers  


when qtp recognizes a web link like (hyper link)wich properties it is going to take to identify the objects unquely? what is Ini file in QTP?

1 Answers   Symantic Space,


Categories