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 = '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.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a485abcea98167144a7fd7a9d66b2666522734788b0d2af39371d4a7250a277 |
|
MD5 | fa6069f937628573399ad3d7d801ac92 |
|
BLAKE2b-256 | 4db5178e76c6b2f43309887bd32294d3d28ae37014e06776332a848ad0760e04 |