types-openpyxl

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

Provides type hints for openpyxl, enabling static type checkers like mypy, pyright, and ty to validate code that uses openpyxl.

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

pip install types-openpyxl

uv add types-openpyxl

poetry add types-openpyxl

Installing types-openpyxl

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.

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')

Requires Python 3.10 or later

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

Evidence: types_openpyxl-3.1.5.20260807-py3-none-any.whl

Tags

More Software Development packages