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.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2eba17468dff44d7594d7a1a964bd928e712539262b217d1d8e9a25d09d7b969 |
|
MD5 | cdfcd452b204e66ee5bd68782d27e03a |
|
BLAKE2b-256 | b286c52417c6fecffb3393f989d1e701760fef4562b867540f2505bd487504d6 |