Filling Webform using selenium from excel via python

Question

I want to fill webforms using selenium web driver in python language. thats not a tough task indeed but I am unable to find out how can fill the webform when the data must be taken from excel file.

I have tried selenium to fill webform that is possible and easy

rom selenium import webdriver

driver = webdriver.Chrome("C:\\chrome_driver\\chromedriver_win32\\chromedriver.exe")
driver.get("https://admin.typeform.com/signup")
driver.find_element_by_id("signup_owner_alias").send_keys("Bruce Wayne")
driver.find_element_by_id("signup_owner_email").send_keys("[email protected]")
driver.find_element_by_id("signup_terms").click()
driver.find_element_by_id("signup_owner_language").click()

Sosthenes Kwame Boame · Accepted Answer · 2018-12-23 08:50:01Z

1

You can use the pandas library to fetch the data from your excel sheet. If you don't have it installed, you install it with pip: pip install pandas.

Below is an example of how data is fetched from an excel sheet using pandas.

import pandas as pd

df = pd.read_excel('centuries.xls')

sheet_years = df['Year']

for year in sheet_years:
    print(year)

Basically, we fetched the excel sheet (centuries.xls) using the read_excel() method. Then we saved one of the columns ('Years' column in this example), in a variable (sheet_years). You can do same with other columns.

Rows in the saved column are automatically saved as list items, so we can iterate over these items using our for loop. You can replace it with your own code, instead of just printing the items in the list.

If your excel file contains more than one sheet, you can use the sheet_name parameter of the read_excel() method.

After doing the job with pandas, you can then send the output to your selenium code to fill the forms.

More information here:

answered Dec 23, 2018 at 8:50

Sosthenes Kwame Boame

3731 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ajay Mandal Over a year ago

thats helps.. but when you use pandas , the data from excel is converted into dataframe and again manage the data from dataframe is additional task.

Collectives™ on Stack Overflow

Filling Webform using selenium from excel via python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related