Library for reading tabular data from excel in a very forgiving manner.
Project description
EXCELerator
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.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e230904ec0b6f0a156d2b0751e52c81ec764ef0988f6809bec8e0843b0fdf08c |
|
MD5 | 9202932cfbfdc41ffc31642acabb9867 |
|
BLAKE2b-256 | 4101873567ea8806e8811f8b911c87dc8ace8629efecacc3876df2da90788a4d |