Python: Manipulating Excel with Python

openpyxl is the recommended module for reading and writing Excel files in Python.

from openpyxl import load_workbook

wb = load_workbook(filename = 'excel-spreadsheet.xlsx')

for sheet in wb.worksheets:
    print (sheet)

for name in wb.get_sheet_names():

    print (name)
    if name.startswith("1"):
        process_summary(wb[name])

def process_summary(sheet):
    print (sheet['A1'].value)