openpyxl-dictreader 0.1.1

A simple package to read openpyxl worksheets like a csv DictReader

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 dictreader

reader = dictreader.DictReader("names.xlsx", worksheet="Sheet1")
    for row in reader:
    print(row["First Name"], row["Last Name"])

Output:

Boris Johnson
Donald Trum
Mark Rutte

Acknowledgements

• openpyxl

• csv