openpyxl

The industry-standard Python library for reading and writing Excel 2010 xlsx, xlsm, xltx, and xltm files.

Openpyxl gives you direct programmatic control over Excel workbooks (specifically the Office Open XML format) without requiring a local Excel installation. It excels at automating high-volume reporting: you can generate 2D/3D charts, apply complex conditional formatting, and manage datasets spanning 1,048,576 rows per sheet. Use it to modify cell styles (like Font or Border), inject formulas, or parse existing spreadsheets for data analysis. It is the reliable choice for developers who need to bridge the gap between raw Python data and polished, stakeholder-ready .xlsx files.

https://openpyxl.readthedocs.io/