openpyxl is a Python library for reading and writing xlsx and xlsm files used by Excel 2010 and later. It was first released in 2010 by Eric Gazoni and is distributed under the MIT license. It can manipulate workbooks, worksheets, cell values, formulas, formatting, and charts without Excel being installed.
It is widely used as a standard tool for generating and processing Excel files in data analysis and report automation, and pandas relies on it internally for Excel input and output. Because it neither evaluates formulas nor renders files, verifying calculated results requires Excel or a separate engine.