Interested to Buy Any Domain ? << Click Here >> for more details...
suppose 3 excel sheets are there * we are trying to check
for login credentials for a page. userid from excel1 ,
password is from excel2 whether the page is opened or not
that checkpoint is result is should be stored in excel
3.... this qus i have faced in IBM technical round...
please tell script for above query
- 1 Answers
- 7254 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kishore
Getting User id from Excel 1
Set objxls = createobject("Excel.Application")
objxls.workbooks.open "C:\Documents and
Settings\ranantatmula\Desktop\data.xlsx"//path of the excel
sheet where user id is stored
v1 = objxls.cells(1,1) // where user id is stored in Excel
browser("xxx").page("yyy").webedit("username").set(v1)
Get PWD from excel 2
Set objxls1 = createobject("Excel.Application")
objxls.workbooks.open "C:\Documents and
Settings\ranantatmula\Desktop\data1.xlsx" //path of excel
where pwd is stored
v2 = objxls.cells(1,1) // where PWD id is stored in Excel
browser("xxx").page("yyy").webedit("username").set(v2)
To export the result in Excel 3
Set objxls3 = createobject("Excel.Application")
set objworkbook = objxls3.workbooks.Add
write a condition if page is opened
browser("xx").page("xx").webedit("userid").click
browser("xx").page("xx").webedit("pwd").click
browser("xx").page("xx").webbutton("submit").clcik
If page opens
objxls3.sheet(1).cells(1,1) = "PASS"
else
objxls3.sheet(1).cells(1,1) = "FAIL"
Endif
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How to create scenario selector
Explain how Selenium is different from UFT?
What are the key elements available in test result window?
in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?
How to create runtime property for an object?
What is test object model in quicktest professional?
Explain the concept of how quicktest professional identifies object?
How do you capture tooltip using QTP?
Discuss quicktest professional (qtp) environment?
How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet
Which scripting language used by quicktest professional (qtp)?
How do we analyze the checkpoint results?
Explain about datafile/verification of date file when file is not available in local system?
Explain Descriptive Programming Types with Examples?
How do I get the QTP scripts result in xml format by using vb script function?
