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 kind of tests would you automate?

1067


What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...

2017


Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..

1927


how to test an webbased application?

2110


Do you know what is a data-driven framework?

1074


Can you achieve 100% automation?

1024


Any kind of test which you think should not be automated?

1047


Tell me the fundamental difference between xpath and css selector?

1188


Please explain how to perform load-testing?

1126


I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com

4572


What is the difference between automation tools and management tools?

1086


test cases test wheather window? test cases to test calculaor? test cases to test a reverse string program? test cases to test program{ int.parse(sting str) $return (int)}? test cases to test program{display string length}?

2352


How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.

1734


Explain load testing on websites?

1107


What is ‘good code’? What is ‘good design’?

1027