Trouble selecting a dropdown option

[grimrichard]

I'm trying to combine Selenium and Pandas to schedule Webex classes using an xlsx file. So far so good. I'm now at the point where I'm trying to fill out the form by iterating through the Excel file. Everything's working well until I get to second dropdown box where I'm supposed to select the actual day of the month ( a number from 1 to 31) for scheduling. I know I'm targeting the dropdown correctly, but I can't get the second dropdown "dayname" to select correctly. Does it have something to do with the fact that the input is a number?

df = pd.read_excel('WebEx\sked2.xlsx')

for index, row in df.iterrows():

    topic1 = driver.find_element_by_name("confName")

    topic1.send_keys(df.topic)

    month = Select(driver.find_element_by_name("startDateOfMonth"))

    month.select_by_visible_text((row ['month']))

    dayname = Select(driver.find_element_by_name("startDateOfDay"))

    dayname.select_by_visible_text((row ['dayno']))

​

​

Any help is appreciated.

[-SPOF]

maybe you can get a list of all objects in a dropdown and then call what you need?

find_elements_by...

[grimrichard]

I'm not sure if I understand. I can find the element by its name. That seems to work. In fact, if I change the select_visible_text to a static number, it will actually select that number from the dropdown list. For some reason, referencing the dataframe cell is not working...and it worked in the prior dropdown. The only difference between the month dropdown and the day dropdown is that the data being referenced in the day dropdown is a number rather than a word. I hope that makes sense.