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

Where can I find and view run-time data table?

969


How you debug your script?

1065


in qtp if we record a object and we record the object using virtual wizard then by which way the object is recognized that means recorded

1938


What is checking bitmaps?

1012


Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??

2089


1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible

2182


iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?

2086


how do we know whether all objects are stored in the object repository or not? how can we know if a particular object is not stored in the repository?

1743


For which type of project the iterative model is suitable?

1771


I AM TRYING PORT CODE FROM WINRUNNER TO QTP AND DON'T KNOW TO HOW TO CHECK THE ERRORS. IN WINRUNNER FUNCTION RETURNS EIGHER 0 OR -1 AGAINST WHICH RESULT CAN BE MADE PASS OR FAIL BUT IN QTP I DON'T SEE FUNCTIONS RETURNING ANY VALUE. APPRECIATE IF ANYONE COULD HELP ME CONVERTING FOLLWOING WINRUNNER CODE TO QTP. set_window("Customer Service"); rc = web_obj_get_text("Summary","#2","#4",ssn,""," ",1); if (rc != E_OK) { report_msg("[GetSubscriberSummary] Could Not get subscriber SSN; rc = "&rc); myRC = rc; } else { ssn = StripBlank(ssn); if (DEBUG) report_msg ("[GetSubscriberSummary] SSN: "&ssn); }

2270


How to capture all the data of a webtable, weblist and combolist using QTP?

3336


Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?

1927


Does QTP record on Objects created on XWindows Environment?

2199


Explain how qtp identifies object?

1075


Hi All, I need code for how to execute qtp scripts from excell sheet

1905