openpyxl

noun

say it: “OH-pun-PY-ek-SEL” /ˌoʊpənˈpaɪ ɛkˈsɛl/

A Python package for reading and writing Excel workbooks, which pandas uses behind the scenes to open and save .xlsx files.

What is openpyxl?

openpyxl is the Python library that reads and writes Excel .xlsx files. pandas uses it behind read_excel() and to_excel(), so a project that opens workbooks lists it in requirements.txt, even if no line of its code imports it.

# requirements.txt has openpyxl==3.1.5; pandas uses it here
import pandas as pd
vendors = pd.read_excel("vendors.xlsx")

In a sentence

  • “pandas asked for openpyxl the first time she read a workbook.”
  • “He added openpyxl to requirements.txt, though no line of his code imports it.”

Level: Journeyman · More Python terms at this level

Updated