An interface similar to csv.DictReader for openpyxl WorkSheet objects
Project description
XLSX DictReader
This is a simple Python module that takes an openpyxl Worksheet
object and returns a list of dictionaries. Each dictionary represents a row in the Excel file. The keys of the dictionary are the column names and the values are the cell values.
I've recently found myself, several times, wanting a thing like csv.DictReader
for specific ranges of cells in Excel files. This does the job for me so far.
Sample Usage:
from openpyxl import load_workbook
from xlsx_dictreader import DictReader
wb = load_workbook('sample.xlsx', data_only=True)
ws = wb.active
reader = DictReader(ws, skip_blank=True)
for row in reader:
print(row)
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
xlsx_dict_reader-0.3.0.tar.gz
(2.9 kB
view hashes)
Built Distribution
Close
Hashes for xlsx_dict_reader-0.3.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0731aeeb056d816d0efdd0816d94282c36b37570ed52df8c8847c80f86e76653 |
|
MD5 | cfcdea324e2b234f8abe48d08dbab853 |
|
BLAKE2b-256 | 7583f774c6c0775094b8da0bec6c64b4d54183c2a2acc5f5f086431adb26408c |