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
NoneRelease 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.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2def48ae30601bc7a757a026a299e3582bddc4bbf8fd5226da7f412fdf076797 |
|
MD5 | a46cf502fb869b421e166740b9279500 |
|
BLAKE2b-256 | b8f11f994544d4a662b7933cb8bb9de9f757a8563663acb4ace9754a69bd882d |