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

RE: How to compare data in excel sheet with text in website

~~Screenshot of the excel sheet I am using

RE: How to compare data in excel sheet with text in website

Is it possible to do?
If Yes, please suggest how should I proceed.

som Train Asked on November 10, 2014 in Selenium WebDriver.
3 Answers

Hi,

Why dont use driver.sendkeys and send the data in the excel to that field . Give it a try it works for me.

Train Answered on November 10, 2014.

Hi mallik

I tried that idea but the thing is the Gender fields is non- writeable so forcefully I have to select a value from the drop-down and proceed.

on November 10, 2014.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.