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
Where can I find and view run-time data table?
How you debug your script?
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
What is checking bitmaps?
Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??
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
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?
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?
For which type of project the iterative model is suitable?
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); }
How to capture all the data of a webtable, weblist and combolist using QTP?
Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?
Does QTP record on Objects created on XWindows Environment?
Explain how qtp identifies object?
Hi All, I need code for how to execute qtp scripts from excell sheet