Extract data from Excel documents.
Project description
exex
Extract data from Excel documents
Installation
pip install exex
Usage
from openpyxl import load_workbook
from exex import parse
book = load_workbook("sample.xlsx") # load excel file
sheet = book.active # get active sheet
# single 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 values
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"]
# column range
parse.values(sheet["A:B"])
[
["name", "alpha"],
["abbreviation", "a"],
]
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 names
Development
Tests (local Python version)
poetry run pytest
Tests (all Python versions defined in tox.ini
)
poetry run tox
Code formatting (black)
poetry run black .
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
exex-0.1.7.tar.gz
(3.3 kB
view hashes)
Built Distribution
exex-0.1.7-py3-none-any.whl
(3.1 kB
view hashes)