Python for Excel, 2nd Edition (O'Reilly, 2026)

Note

This is the material for the 2nd edition (June 2026)! For the 1st edition (2021), check out the 1st-edition branch.

This is the companion repository for the 2nd edition of Python for Excel.

All notebooks except ch09.ipynb (requires a local installation of Excel) can be run in the cloud:

Name		Name	Last commit message	Last commit date
Latest commit History 41 Commits
csv		csv
custom_functions		custom_functions
images		images
lite		lite
packagetracker		packagetracker
sales_data		sales_data
xl		xl
.gitignore		.gitignore
.python-version		.python-version
Dockerfile		Dockerfile
LICENSE		LICENSE
README.md		README.md
appendixC.ipynb		appendixC.ipynb
ch02.ipynb		ch02.ipynb
ch03.ipynb		ch03.ipynb
ch04.ipynb		ch04.ipynb
ch05.ipynb		ch05.ipynb
ch07.ipynb		ch07.ipynb
ch08.ipynb		ch08.ipynb
ch10.ipynb		ch10.ipynb
ch11.ipynb		ch11.ipynb
ch14.ipynb		ch14.ipynb
ch15.ipynb		ch15.ipynb
debugging.py		debugging.py
pep8_sample.py		pep8_sample.py
pyproject.toml		pyproject.toml
requirements.txt		requirements.txt
sales_report_openpyxl.py		sales_report_openpyxl.py
sales_report_pandas.py		sales_report_pandas.py
sales_report_xlsxwriter.py		sales_report_xlsxwriter.py
sales_report_xlwings.py		sales_report_xlwings.py
temperature.py		temperature.py
uv.lock		uv.lock

Provide feedback