Python for Excel–The Book
A Modern Environment for Automation and Data Analysis
https://www.xlwings.org/book
You’ll find the Jupyter notebooks, Python scripts, and other example files here: https://github.com/fzumstein/python-for-excel
Table of Contents
The book has 316 pages and is split into 4 parts and 12 chapters:
I. Introduction to Python
1 Why Python for Excel?
2 Development Environment
3 Getting Started with Python
II. Introduction to pandas
4 NumPy Foundations
5 Data Analysis with pandas
6 Time Series Analysis with pandas
III. Reading and Writing Excel Files without Excel
7 Excel File Manipulation with pandas
8 Excel File Manipulation with Reader and Writer Packages
IV. Programming the Excel Application with xlwings
9 Excel Automation
10 Python-Powered Excel Tools
11 The Python Package Tracker
12 User-Defined Functions (UDFs)
1