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 output value? How many types of output values are there in qtp?

0 Answers  


Have you used xml check point in your project?

0 Answers  


examples of user definied functions? how to write user defined functions in qtp9.2?

3 Answers   IBM,


Hi all, can anyone tell me the challenges u faced while using qtp?

2 Answers  


how to write code for to select all the checkboxs in the gmail i wrote code for my question but it didn't works any body suggest what wrong my code my code is Set chkboxDesc=Description.Create() chkboxDesc("type").value="chekbox" Set chboxcollection=Browser("name:=Gmail .*").Page("title:=Gmail .*").ChildObjects(chkboxDesc) For i=0 To chboxcollection.count-1 chboxcollection(i).set "ON" Next i was getting general run time error pls help me i am in learing stage

2 Answers  


Tell me about qtp?

0 Answers  


Explain different types of checkpoints?

0 Answers  


What are the Features & Benefits of Quick Test Pro ?

1 Answers   Crea,


Can we continue functionality testing without framework?

4 Answers  


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  


How to use library files in QTP? how we can call these files in to script?

4 Answers   Virtusa, Wipro,


list me out the shortcutkeys for some functionlities in the qtp for example to record ,to run ... etc

2 Answers   CTS,


Categories