Python for Excel: A Modern Environment for Automation and Data Analysis, Edition 2

Felix Zumstein

May 2026 · "O'Reilly Media, Inc."

Ebook

418

Pages

Tools

Eligible

About this ebook

Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python.

Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein—creator of the popular open source package xlwings—also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python.

Learn how to use Python's core features
Get started with modern tools, including Jupyter notebooks and Visual Studio Code
Apply powerful pandas commands to acquire, clean, and analyze data
Use advanced analytics via pandas in Excel, using Python in Excel
Manipulate Excel files with Python, using xlwings and OpenPyXL
Automate Excel with Python, using xlwings and xlwings Lite

Discover more

About the author

Felix Zumstein is an independent software developer and the founder of Zoomer Analytics GmbH. He pioneered the integration of Python and Excel with his open-source project xlwings. His work, which predates Microsoft's own "Python in Excel" feature by a decade, has enabled countless companies across the globe to connect Excel with Python. Felix is also a LinkedIn instructor and runs the xlwings meetup in London.

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.

Flag as inappropriate