xlwings Newsletter #27

Python for Excel - The Book

March 31, 2021

Python for Excel

After working on xlwings for more than 7 years, I figured it was a good time to write a book! It starts at zero (or almost—you should know your way around Excel and have a very basic understanding of programming, but no Python-specific knowledge is required).

The book is published by O'Reilly, has 316 pages and is split into 4 parts and 12 chapters:I. Introduction to Python1 Why Python for Excel?2 Development Environment3 Getting Started with Python

II. Introduction to pandas4 NumPy Foundations5 Data Analysis with pandas6 Time Series Analysis with pandas

III. Reading and Writing Excel Files without Excel7 Excel File Manipulation with pandas8 Excel File Manipulation with Reader and Writer Packages

IV. Programming the Excel Application with xlwings9 Excel Automation10 Python-Powered Excel Tools11 The Python Package Tracker12 User-Defined Functions (UDFs)For reviews and more infos, including where to buy, see the book's homepage:

Happy Reading!

~ Felix