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?
- 3 Answers
- 4932 Views
- I also Faced
- E-Mail Answers
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
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
Tell me what is a keyword-driven framework?
How the object properties will be recognised by the tool If the functions/ statements are written manually?
What all different approaches can be used for designing an automation solution?
Where will you maintain information like url, login, password?
What is test automation?
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What is vendor tool and give examples?
What kinds of annotations are used in testng?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?
What are the 5 common software development problems solutions?
Tell me how can we find the value of different attributes like name, class, value of an element?
What you know about table-driven testing?
