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...

hi i m runing a login script using multiple data by importing
from excel sheet, now i want to get a status pass or fail each
time the script run for multiple data??
so anyone can help me out?

Answer Posted / meher dawlekar

Hi...
Answer for your question :
Ex : Flight Reservation Login with multiple data from the
excel sheet
Here i am taking the Excel sheet(meher.xls) having two
columns name 1.agentname
2.password,with multiple set of values in its respective rows
****************Script*****************************

option explicit
dim aname,pwd,sheetcount

datatable.addsheet"input"
datatable.importsheet"path of the source sheet with
sheetname with its extension.xls","meher","input"

sheetcount=datatable.getsheet("input").getRowcount

aname=datatable.value("agentname","input")
pwd=datatable.value("password","input")

For i= 1 to sheetcount step 1
Dialog("Login").winEdit("Agent Name:").set aname
Dialog("Login").winEdit("Password:").set pwd
Dialog("Login").winButton("OK").click

If Window("Flight Reservation").Exists Then

msgbox "Your Login status is Passed"

else
msgbox"Your Login status is Failed"

Endif



***********Hope you are cleared with my answer**********

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the scripting standard while performing automation testing?

1122


If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.

2007


In Selenium how a test suit is run and report is generated.

2055


hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help

2078


Tell us which package can be imported while working with webdriver?

1051


Tell me what is an absolute xpath?

990


How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

2437


What is a ‘test plan’? What is a ‘test case’?

1054


How software testing is handled?

967


Tell us what methods of robot class do you know?

978


What is testng and why is it better than junit?

1055


script to check availibility of mail in yahoo mail box in qtp

2963


Tell us how can you create html test report from your test script?

1013


How will you automate basic “login” functionality test cases for an application?

959


Do you know what is a data-driven framework?

1036