Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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



suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid..

Answer / 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

More QTP Interview Questions

what is object and child object.. explain ..if possible give some example for better understanding ..

0 Answers   HCL,


What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????

0 Answers   Infotech,


In qtp, how you can remove the spaces from string?

0 Answers  


how to lunch the application in the qtp tool ?

3 Answers  


Hai anyone please "Explain about Framework in QTP?"

0 Answers  


More details about keyword driven technique in QTP

1 Answers   TCS,


Up to how much VB scripting knowledge and what type of VB script knowledge is required for a QTP test engineer for real time to work ?

3 Answers  


How we can test a Frame in a web page?

1 Answers   eMids,


Explain different types of action in qtp?

0 Answers  


When we use 'ERR' object to handle the exceptions in the script, do we need to include any statement in the beginning of the script..??

2 Answers   DST Global Solutions,


Hi to All, My name is Aditya, i have 4 year exp in software testing (Manual Testing), but i try to shift my career now in automation testing. right now i have no exp or u can say i am not hand exp in live application. So please guide me, what i do ???? Can i join again automation course only practical which is live application. if u know any person who's expert in qtp and he/she ready to take my class i have our own and company laptop. If required i will pay amount please don't mind. Please help me, and i am also planing to join core java from coming 1st Aust (in seed) for only purpose the understanding script of Automation (QTP)... Please help me... I am waitting u r replay... Thank you Thanks again

5 Answers  


How to retrieve the property of an object?

1 Answers  


Categories