DATA PYTHON
“This book explains
how you can integrate
Python into Excel and
free yourself from the
inevitable disaster
of huge workbooks,
thousands of formulas,
and ugly VBA hacks.
Python for Excel is
probably the single
most useful book on
Excel that I have read
and an absolute must-
read for any advanced
Excel user.”
—Andreas F. Clenow
CIO, Acies Asset Management, and
author of international best-sellers
Following the Trend, Stocks on the Move,
and Trading Evolved
Python for Excel
ISBN: 978-1-492-08100-5
US $59.99 CAN $79.99
Twitter: @oreillymedia
facebook.com/oreilly
While Excel remains ubiquitous in the business world,
recent Microsoft feedback forums are full of requests to
include Python as an Excel scripting language. In fact, it’s
the top feature requested. What makes this combination so
compelling? In this hands-on guide, Felix Zumstein—creator
of xlwings, a popular open source package for automating
Excel with Python—shows experienced Excel users how to
integrate these two worlds efficiently.
Excel has added quite a few new capabilities over the past
couple of years, but its automation language, VBA, stopped
evolving a long time ago. Many Excel power users have
already adopted Python for daily automation tasks. This
guide gets you started.
• Use Python without extensive programming knowledge
• Get started with modern tools, including Jupyter notebooks
and Visual Studio Code
• Use pandas to acquire, clean, and analyze data and replace
typical Excel calculations
• Automate tedious tasks like consolidation of Excel
workbooks and production of Excel reports
• Use xlwings to build interactive Excel tools that use Python
as a calculation engine
• Connect Excel to databases and CSV les and fetch data
from the internet using Python code
• Use Python as a single tool to replace VBA, Power Query,
and Power Pivot
Felix Zumstein is creator and
maintainer of xlwings, a popular
open source package that allows the
automation of Excel with Python on
Windows and macOS. As CEO of xltrail,
a version control system for Excel les,
he’s gained deep insight into the typical
use cases and issues with Excel across
various industries.
Python for ExcelPython for Excel
