---
id: types-openpyxl
version: "3.1.5.20260807"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# types-openpyxl — Typing stubs for openpyxl

License: permissive · Maintenance: active · Downloads: 6.2M/mo

## 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 above — 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

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

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 6.2M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

type stubs openpyxl, mypy openpyxl typing, static type checking excel, openpyxl type annotations, pyright excel library, typeshed openpyxl stubs, type hints spreadsheet, type-stubs, static-analysis

[View on SkillFed](https://skillfed.io/packages/types-openpyxl) · [View on PyPI](https://pypi.org/project/types-openpyxl/)