A simple package to read openpyxl worksheets like a csv DictReader
Project description
Description
A module that maps the information in each row in an openpyxl worksheet to a dict whose keys are given by the optional fieldnames parameter, similar to Python’s native csv.DictReader.
Installing
pip install openpyxl-dictreader
Examples
Input:
import openpyxl_dictreader
reader = openpyxl_dictreader.DictReader("names.xlsx", worksheet="Sheet1")
for row in reader:
print(row["First Name"], row["Last Name"])
Output:
Boris Johnson Donald Trump Mark Rutte
Acknowledgements
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
Close
Hashes for openpyxl-dictreader-0.1.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5fa8a78cc5f1576ec63289aea3ff716b8deb286d4a38247711636989cd5b8bb8 |
|
MD5 | b1312a78a5acbf08cfc1449026e1a23c |
|
BLAKE2b-256 | e8c0c322a0446b115d1e1edc1a1996f5a2d489a7a0e3a3c61f0a39acc9eb1e82 |
Close
Hashes for openpyxl_dictreader-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e24a8eb8bc96d73de9d7325c706d1888757c24cc65d054fcf869aca2c8775565 |
|
MD5 | 9d5acceb7b97939dc0c226f573c61e83 |
|
BLAKE2b-256 | f648a1bac23c3382d1582ad3be78f57bf934747b18f7609b600bf48c6e7b5292 |