RE: How to compare data in excel sheet with text in website
In my test case I have to fill up a form for a student admission.
There is a drop-down to select MALE and FEMALE.
For data to be inserted in the form, I am picking my data from excel sheet and writing them in website.
But when its come to select the Gender I am not able to select Male and Female according to the data in the excel sheet.
I have written and Male and Female (in different cells)in front of the student names .
What I want to do is pick the Male or Female word from excel sheet, compare it with the gender provided in the drop-down and then move forward accordingly.
~~Screenshot of the Gender drop-down in my application
~~Screenshot of the excel sheet I am using
Is it possible to do?
If Yes, please suggest how should I proceed.