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 |
We have 10 page.In first page we 2 popup and next page we 3 popup window......(windows name is different)how can we handle the all the popups without using recovery scenario
I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible
anybody wants to learn QTP with realtime implementations and complete framwork contact to this mail id ciraaj@gmail.com
How to create Reusable and Multiple Actions?
Suppose I have three hyperlinks with same properties. How to solve this and what are the ways to solve this. we can solve this by using index property but what are the other ways we have have to solve this problem. Login (href: btnlogin.aspx) Login (href: Sourcelogin.aspx) Login (href: homelogin.aspx)
Hello, How can i capture first letter of any string using QTP. For ex.. i want "j" in the below string "john" could any one explain me? Is there any function for that?
If i entered 2 columns and 4 rows inputs in DDT Like Mango fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q is How to get the 2nd column value for corresponding 1 column input in 3rd row ie, ( i need to get "veget" in messge box @ run time
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
what is the Exact Meaning of Environment Variables?
Why QTP is termed as a Record and Playback tool?
Flight reservation using input and output parameter script.
How to Analyze the Checpoint results by Table and DB Checkpoints?