Skip to main content

A high-performance, statically typed drop-in replacement for openpyxl.

fastpyxl reads and writes Excel 2010+ xlsx/xlsm/xltx/xltm files with the same API as openpyxl — just change your import:

# before
from openpyxl import Workbook, load_workbook

# after
from fastpyxl import Workbook, load_workbook

No other code changes required.

Performance

Benchmarked on a real-world 5.2 MB IMF/World Bank workbook (887,370 cells, 97k formulas). Median of 5 runs, Python 3.12, openpyxl 3.1.5:

Benchmark comparison: fastpyxl vs openpyxl

Operation

openpyxl

fastpyxl

Change

Load workbook

7.29s

5.58s

-23.5%

Save workbook

5.70s

5.74s

+0.6%

Read-only iteration

4.84s

4.07s

-15.9%

Key optimizations since 1.0.0: inlined cell parsing, O(1) sheet lookup, formula translation fast path, VBA archive filtering, empty-cell skip, and cached sheet names. See the changelog for details.

Installation

pip install fastpyxl

Quick start

from fastpyxl import Workbook

wb = Workbook()
ws = wb.active

ws["A1"] = 42
ws.append([1, 2, 3])

import datetime
ws["A2"] = datetime.datetime.now()

wb.save("sample.xlsx")

Key features

  • 1-to-1 API compatibility with openpyxl

  • Static typing throughout

  • Optimized cell parsing, coordinate lookups, and style deduplication

  • Read-only and write-only modes for large files

  • Charts, images, comments, data validation, pivot tables

  • Conditional formatting and rich text

  • Pandas DataFrame integration

Security

By default fastpyxl does not guard against quadratic blowup or billion laughs XML attacks. To guard against these attacks install defusedxml.

Documentation

Full documentation: https://promptlytechnologies.com/fastpyxl/

Acknowledgements

fastpyxl is a fork of openpyxl. All credit to Eric Gazoni, Charlie Clark, and the openpyxl contributors whose work this project builds upon.

License

MIT. See LICENSE for details.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

fastpyxl-1.0.11.tar.gz (209.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

fastpyxl-1.0.11-py3-none-any.whl (281.0 kB view details)

Uploaded Python 3

File details

Details for the file fastpyxl-1.0.11.tar.gz.

File metadata

  • Download URL: fastpyxl-1.0.11.tar.gz
  • Upload date:
  • Size: 209.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for fastpyxl-1.0.11.tar.gz
Algorithm Hash digest
SHA256 b722a86c2030dfbdb83fef202b577d2c870380a9699b58a2bf81e33c62522145
MD5 d3e07acdf87488c929b0e68145ed2806
BLAKE2b-256 66974ded3f7653b1b8982f968bd09fbbc7d5aaa76e0b903a5ea9f02fd55005eb

See more details on using hashes here.

Provenance

The following attestation bundles were made for fastpyxl-1.0.11.tar.gz:

Publisher: release.yml on Promptly-Technologies-LLC/fastpyxl

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file fastpyxl-1.0.11-py3-none-any.whl.

File metadata

  • Download URL: fastpyxl-1.0.11-py3-none-any.whl
  • Upload date:
  • Size: 281.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for fastpyxl-1.0.11-py3-none-any.whl
Algorithm Hash digest
SHA256 0fceae896a3d85a77093eca2d794cccbfb0f8c4be2671e23c512b27a22966d14
MD5 949e76245b475163336bfa7c24ed2726
BLAKE2b-256 14b1d13921e39515b1705836dec2a843894dc2cc2d25664c82c80c83d2949654

See more details on using hashes here.

Provenance

The following attestation bundles were made for fastpyxl-1.0.11-py3-none-any.whl:

Publisher: release.yml on Promptly-Technologies-LLC/fastpyxl

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

1.1.0

2 files

1.0.12

2 files

This release

1.0.11 This release

2 files

1.0.10

2 files

1.0.9

2 files

1.0.8

2 files

1.0.7

2 files

1.0.6

2 files

1.0.5

2 files

1.0.4

2 files

1.0.3

2 files

1.0.2

2 files

1.0.1

2 files

1.0.0

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page