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
why text area checkpoints cannot used for web applications
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?)
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.
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)))
What are the advantages of Object Repository?
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?
What is RTM (require ment tracebulity marix) fromate?
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...!!!
What is difference in global and action sheet in qtp?
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?
Explain the qtp test phases.
what are the mandatory properties for a tex boxc (scenario?)
Hi, Can we open a test in qtp10 which is saved in qtp 9.2?
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?
In qtp, explain what is qrs file?