exex 
Extract data from Excel documents
Installation
pip install exexUsage
Load Excel file
from openpyxl import load_workbook
from exex import parse
book = load_workbook("sample.xlsx") # load excel file
sheet = book.active # get active sheetSingle cell by name
parse.values(sheet["A1"])
"name"Single cell by row/column number
parse.values(sheet.cell(row=1, column=1))
"name"Range of cells
parse.values(sheet["A1":"B2"])
[
["name", "abbreviation"],
["alpha", "a"],
]All cells
parse.values(sheet.values)
[
["name", "abbreviation", "age"],
["alpha", "a", 1],
["beta", "b", 2],
["gamma", "g", 3],
]Row by number
parse.values(sheet[1])
["alpha", "a", 1]Range of rows
parse.values(sheet[1:2])
[
["name", "abbreviation", "age"],
["alpha", "a", 1],
]Column by name
parse.values(sheet["A"])
["name", "alpha", "beta", "gamma"]Rangge of columns
parse.values(sheet["A:B"])
[
["name", "alpha", "beta", "gamma"],
["abbreviation", "a", "b", "g"],
]Ways to access sheets
# Sheets
book.sheets[0] # (sheet) sheet by index
book.sheets["prices"] # (sheet) sheet by name
book.active # (sheet) active sheet
book.sheetnames # (array) sheet namesDevelopment
Setup
poetry installTests (local Python version)
poetry run pytestTests (all Python versions defined in tox.ini)
poetry run toxCode formatting (black)
poetry run black .