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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

why text area checkpoints cannot used for web applications

2334


Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

1873


Why we use QTP ,We can use other tools like WR OrSilktest What r the options in Qtp that WR and Swilktest Does not have.

2266


An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))

2090


What are the advantages of Object Repository?

1041


In QTP TEST DIRECTOR COMBINATION WHAT IS THE PURPOSE OF TEST DIRECTOR? In Somebody says to store test cases and design test cases.?ok fine , but In test director 5.0 , QTp not launching. what u do?

1895


What is RTM (require ment tracebulity marix) fromate?

1990


I want to capture data(using keyword) from msdos application using QTP?... Below is little work i could do on it... /* Set app=CreateObject("Wscript.shell") SystemUtil.run ("C:\Users\Agent\Desktop\pumpsim\PUMPSIM.EXE") Window(“PUMPSIM.EXE”).Activate wait(3) app.sendkeys "N" */ Thanks in advance...!!!

1832


What is difference in global and action sheet in qtp?

1066


Hi, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?

2005


Explain the qtp test phases.

997


what are the mandatory properties for a tex boxc (scenario?)

1966


Hi, Can we open a test in qtp10 which is saved in qtp 9.2?

1843


An action has both shared and local or associated to it and both have the same object in them. In the test which one will be considered?

1066


In qtp, explain what is qrs file?

1025