pyxlsx

What it is and what it does

pyxlsx wraps openpyxl to provide a more intuitive, dictionary-oriented interface for working with Excel files. Instead of navigating cells by coordinate, you can append rows as dictionaries, access cell values by header name, and iterate over content rows as structured objects. It handles header row detection, automatic column discovery, and mixed access patterns (by column number or by header name).

The package is designed for straightforward read-write workflows: creating new spreadsheets, appending data rows, reading back structured content, and modifying cells. It abstracts away much of openpyxl's lower-level cell manipulation, making it suitable for data entry, simple ETL tasks, and spreadsheet-based data management where you want to treat rows like records.

Use it for:

• Append product inventory data to a spreadsheet by passing dictionaries with id, name, and price fields.
• Read an existing spreadsheet and iterate over rows as structured objects to extract or transform data.
• Build a simple data export tool that writes tabular data to Excel with automatic header generation.
• Modify cell values in a spreadsheet by row and column name without managing cell coordinates manually.
• Access adjacent cells (top, left, right, bottom) to implement spreadsheet-level logic or validation.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides dictionary-like read and write access to Excel worksheets through openpyxl, letting you treat spreadsheet rows as structured data objects.

Yes, if you need a lightweight dictionary-style interface to Excel files and are comfortable with a dormant package. The low install friction and permissive license make it a reasonable choice for simple spreadsheet tasks. However, be aware that maintenance is inactive—if you encounter bugs or need compatibility updates, you may need to fork or switch to openpyxl directly.

Install

pyxlsx on PyPI

pip install pyxlsx

uv add pyxlsx

poetry add pyxlsx

Installing pyxlsx

Before you install

Low friction install with only two runtime dependencies (openpyxl and pycel). However, the package is dormant—last release was 2020-07-21 and no commits since 2024-07-15, so maintenance is inactive.

License in practice

MIT license is permissive, allowing commercial and private use with minimal restrictions.

Quickstart

pip install pyxlsx

from pyxlsx import new_xlsx, open_xlsx

with new_xlsx('output.xlsx') as wb:
    ws = wb.create_sheet('sheet1')
    ws.append_by_header({'id': '001', 'name': 'example'})

Requires Python >= 3.5; openpyxl must be installed as a runtime dependency.

Verify before relying

• Whether pycel dependency is actively maintained and what its purpose is in this package.
• Whether the dormant status affects compatibility with recent openpyxl versions.
• Real-world performance characteristics when handling large spreadsheets.

Package facts

Evidence: pyxlsx-1.1.3-py3-none-any.whl

Tags

More Utilities packages