adisgee

 Profile Answers by adisgee 

• Aug 2nd, 2007

 

Hi,

1. Store the UserName and Password fields in an excel file.
ColumnA heading: UserName
ColumnB heading: Password

2. Connect to the excel sheet in Read Only mode

3. Get the row count

4. Write a simple for loop to loop over the row count

5. Get the ith data row and dump it on the application in the respective fields.

6. Hit the login / enter button on screen

7. Verify / Set a check point to verify some typical on screen value of the login page that enables the code to understand the user has logged in. (e.g: A welcome <username> text or similar)

8. Report the same withint the results.

9. Loop thru remaining rows and ur done.

P.N: Search the help file on functions to open, read and write to the excel sheet.

Thanks,
Aditya.