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 are the different types of testing framework techniques?

982


What are the different types of an automation tool that you are aware of?

1047


Tell us the line of code webdriver driver = new firefoxdriver();.?

926


How the object properties will be recognised by the tool If the functions/ statements are written manually?

2210


What are the important modules of an automation testing framework?

1075


Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)

5433


On Test Complete I recorded some keyword test. while I'm running the batch test, if one test case failed, then how test complete skip the failed test case and again continue to run the test case? please provide some way to resolve this issue.

1980


What factors determine the effectiveness of automation testing?

950


What is a framework and what are the frameworks available in rc?

1062


hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one

2122


What type of scenarios can't be automated?

1110


How to Rcognize the Objects in the Web Page Dialog Using QTP

2509


What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.

1995


What is the purpose of the wrun.ini file?

1036


Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines

1994