Library for reading tabular data from excel in a very forgiving manner.
Project description
Use Case
Excel is often used to generator forms. Those forms are sometimes modified, even if slightly. Sometimes the header row gets displaced a few rows down or a few columns to the right. Sometimes a header is changed slightly - perhaps a whitespace was added to the end or a newline was inserted to make the header look nicer to the user.
Either way, by the time it got back to you, it changed just enough to throw a wrench into the pandas, openpyxl, or xlrd script you wrote.
This library seeks to aide you in reading the content of such forms by providing you with high-level classes and functions for reading data out of excel sheets.
Future
Currently, this is a barebones library. But more feature will come quickly.
Tutorial
pip install EXCELerator
from excelerator import TableReader
path = r'path\to\excel\sheet.xlsx'
sheetname = 'worksheet name'
tr = TableReader()
my_table_as_dict = tr.read_from(path, sheetname)
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
Built Distribution
Hashes for EXCELerator-0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 108ef5ef47c12e942bd768a9c85a5063898064e7f8fe30e7cf41cceca8d9b503 |
|
MD5 | ec827bcc2a7e0d97a35e9192e9b383ab |
|
BLAKE2b-256 | aad96a6257e3ddcae8e60ab0203a582f1c9ba990eb7eb227feb31aa1f12ba1f3 |