types-openpyxl
Typing stubs for openpyxl
Decision gist · record as of 2026-08-14
Yes, if you use openpyxl and want static type checking. Install it as a dev dependency alongside openpyxl 3.1.5 to get accurate type hints. The package is actively maintained, has no runtime overhead, and is part of the official typeshed project. No security vulnerabilities are known.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later
- Low install friction; a pure stub package with no runtime dependencies.
- Actively maintained as part of typeshed, with a release 7 days old and tested against mypy 2.3.0, pyright 1.1.411, and ty 0.0.59.
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license; you can use this package freely in commercial and private projects with minimal restrictions.
last release 2026-08-07 (7 days) · last repo commit 2026-08-14 · 37 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 6,227,004 downloads/mo, #1,953 on PyPI
Alternatives
Verify before relying
pip install types-openpyxl
import openpyxl
wb = openpyxl.load_workbook('file.xlsx')- Whether these stubs cover all public APIs in openpyxl 3.1.5 or only a subset
- Compatibility with openpyxl versions other than 3.1.5
What it is and what it does
types-openpyxl is a type stub package that provides type annotations for the openpyxl library. It allows Python type checkers to understand and validate code that uses openpyxl for reading and writing Excel files. The stubs are maintained as part of the typeshed project and are kept in sync with openpyxl releases.
When installed alongside openpyxl, this package enables your IDE and type checker to catch type errors before runtime—for example, catching incorrect method calls or type mismatches when working with worksheets and cells. The package requires Python 3.10 or later and has no runtime dependencies, making it a lightweight addition to your development environment.
Use it for
- Enable mypy or pyright to type-check code that uses openpyxl for spreadsheet automation
- Catch type errors in Excel file generation scripts before running them
- Improve IDE autocomplete and inline documentation when writing openpyxl code
- Validate data transformation pipelines that read and write Excel files
- Enforce type safety in team projects that process Excel data
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you use openpyxl and want static type checking.
Install it as a dev dependency alongside openpyxl 3.1.5 to get accurate type hints. The package is actively maintained, has no runtime overhead, and is part of the official typeshed project. No security vulnerabilities are known.
Install
types-openpyxl on PyPI
Before you install
Low install friction; a pure stub package with no runtime dependencies. Actively maintained as part of typeshed, with a release 7 days old and tested against mypy 2.3.0, pyright 1.1.411, and ty 0.0.59.
Requires Python 3.10 or later
License in practice
Apache-2.0 permissive license; you can use this package freely in commercial and private projects with minimal restrictions.
Quickstart
pip install types-openpyxl
import openpyxl
wb = openpyxl.load_workbook('file.xlsx')Verify before relying
- Whether these stubs cover all public APIs in openpyxl 3.1.5 or only a subset
- Compatibility with openpyxl versions other than 3.1.5
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | None |
| Maintenance | Actively maintained 7 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 6,227,004 / month, #1,953 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Programming Language :: Python :: 3Typing :: Stubs Only |
Evidence: types_openpyxl-3.1.5.20260807-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “openpyxl type annotations”
- types-openpyxlProvides type hints for openpyxl, enabling static type checkers like…
- openpyxl-stubsProvides type stubs for openpyxl to enable static type checking with…
- openpyxlopenpyxl reads and writes Excel 2010 xlsx/xlsm/xltx/xltm files…
Give your agent the search over MCP, or paste the wish link into any chat.
More Software Development packages
Provides backported and experimental type hints for Python 3.9+, allowing use of newer typing features on older Python versions and enabling early experimentation with type system PEPs before they enter the standard library.
NumPy provides an N-dimensional array object and a comprehensive suite of mathematical, linear algebra, Fourier transform, and random number functions for scientific computing in Python.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides a way to document function parameters, class attributes, return types, and variables inline using Python's `Annotated` type hint syntax instead of traditional docstrings.
Typer builds command-line applications from Python functions using type hints, automatically generating help text, argument parsing, and shell completion.
Install it if you are building CLIs in Python.
Distlib provides low-level packaging utilities for building, distributing, and managing Python software—including metadata handling, version specifiers, wheel support, script installation, and dependency resolution.
See also openpyxl-stubs · types-reportlab · types-yt-dlp · types-braintree · types-docutils · types-django-filter · types-Pygments · types-geopandas · types-xlrd · types-lxml