Skip to main content

A high-performance, statically typed drop-in replacement for openpyxl >= 3.0.0 on Python >= 3.11.

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

# before
from openpyxl import Workbook, load_workbook

# after
from fastpyxl import Workbook, load_workbook

No other code changes are required for supported openpyxl 3.x usage. APIs removed before openpyxl 3.0 (and behaviour only present in openpyxl 2.x) are intentionally unsupported. See the compatibility guide for details.

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

  • Drop-in API compatibility with openpyxl >= 3.0.0 (Python >= 3.11)

  • 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.1.0.tar.gz (219.4 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.1.0-py3-none-any.whl (293.6 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for fastpyxl-1.1.0.tar.gz
Algorithm Hash digest
SHA256 34ee0ced98eb8aefb7a444d91b75c88cde4d93c11767caa6725053cd808aa169
MD5 f97ff291f0a3365738cc74d9f10e693c
BLAKE2b-256 affdf0bab804f25c7b9d7908fb6bc9752638e0c721a3cc3f0c9096d1a137f614

See more details on using hashes here.

Provenance

The following attestation bundles were made for fastpyxl-1.1.0.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.1.0-py3-none-any.whl.

File metadata

  • Download URL: fastpyxl-1.1.0-py3-none-any.whl
  • Upload date:
  • Size: 293.6 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.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 e0034950e827b52ef91abe56c83e781d44daa3a4aadb41d19bb0f5d627f7be17
MD5 616a0bcdf37e71eb40294117cecef376
BLAKE2b-256 d7ae1bb37a4e7b8297e8c238d682d3911b83dd2b774dc7e6950d7b17f0f51453

See more details on using hashes here.

Provenance

The following attestation bundles were made for fastpyxl-1.1.0-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

This release

1.1.0 This release

2 files

1.0.12

2 files

1.0.11

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