Skip to main content

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


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.1.0.tar.gz (2.8 kB view hashes)

Uploaded Source

Built Distribution

xlsx_dict_reader-0.1.0-py3-none-any.whl (3.4 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page