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
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 |
How can you Open a Notepad and How can you write the test Resuts in Notepad by Using QTP?
what is database check point, how will you parameterize the database from seperate data table?
X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?
How do you invoke an application using the step generator in qtp?
how do you do database testing in qtp
how do u copy object repository?
what is the qtp objects?
How many ways we can parameterize data in QTP?
How to make arguments optional in a function?
Are u place all QTP Framework folders in VSS?
Extract a word from a sentenece?
how can we handle errors other than using recovery scenerios in qtp