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.0.12.tar.gz (212.5 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.12-py3-none-any.whl (284.7 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: fastpyxl-1.0.12.tar.gz
  • Upload date:
  • Size: 212.5 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.12.tar.gz
Algorithm Hash digest
SHA256 f306c557a6735fa8225acadde342d0e9ce34c40c14768abca27e655bc1a8906f
MD5 22372399f77f07cf3e25ef74fa166242
BLAKE2b-256 2da5f5098dafcdbd11419d88aa518861602bf7b8da642f3762ad3a53b1dfad2e

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: fastpyxl-1.0.12-py3-none-any.whl
  • Upload date:
  • Size: 284.7 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.12-py3-none-any.whl
Algorithm Hash digest
SHA256 4bcd66506c9f97bae18a7287d0857a70de0928d316b524d8fb7aee6fdd6e2170
MD5 65bd79f9eb8dc3891fef9a82e5eb985f
BLAKE2b-256 8e7e43143e8761f0d60227df67e99ff56ba9af2574607f1c2be4a7b04c4e3c1f

See more details on using hashes here.

Provenance

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

This release

1.0.12 This release

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