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 42 Commits 42 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