Use Python script to extract data from excel sheet and input into website

Okay. Lets get started.

Getting values out of an excel document

This page is a great place to start as far as reading excel values goes.

Directly from the site:

import pandas as pd

table = pd.read_excel('sales.xlsx',
                  sheetname = 'Month 1',
                  header = 0,
                  index_col = 0,
                  parse_cols = "A, C, G",
                  convert_float = True)

print(table)

Inputting values into browser

Inputting values into the browser can be done quite easily through Selenium which is a python library for controlling browsers via code.

Also directly from the site:

from selenium import webdriver
from selenium.webdriver.common.keys import Keys

driver = webdriver.Firefox()
driver.get("http://www.python.org")
assert "Python" in driver.title
elem = driver.find_element_by_name("q")
elem.clear()
elem.send_keys("pycon")
elem.send_keys(Keys.RETURN)
assert "No results found." not in driver.page_source
driver.close()

How to start your project

Now that you have the building blocks, you can put them together.

Example steps:

1. Open file, open browser and other initialization stuff you need to do.
2. Read values from excel document
3. Send values to browser
4. Repeat steps 2 & 3 forever