Email the Author
You can use this page to email Michael Driscoll about Automating Excel with Python.
About the Book
Python is a versatile programming language. You can use Python to read, write and edit Microsoft Excel documents. There are several different Python packages you can use, but this book will focus on OpenPyXL.
The OpenPyXL package allows you to work with Excel files on Windows, Mac and Linux, even if Excel isn't installed.
In this book, you will learn about the following:
- Opening and Saving Workbooks
- Reading Cells and Sheets
- Creating a Spreadsheet (adding / deleting rows and sheets, merging cells, folding, freeze panes)
- Cell Styling (font, alignment, side, border, images)
- Conditional Formatting
- Charts
- Comments
- Print Settings
- and more!
Python is a great language that you can use to enhance your daily work, whether you are an experienced developer or a beginner!
About the Author
Michael has been programming with Python since 2006. He is the author of the popular Python blog, The Mouse Vs. the Python. Michael has been a technical reviewer for Packt Publishing and No Starch Press. He is also a contributor on Real Python.
He also co-authored The Essential Core Python Cheat Sheet for DZone.
Michael released his first book, Python 101, June 3rd, 2014. He wrote the follow up, Python 201: Intermediate Python and published it in the summer of 2016. He is also the author of wxPython Cookbook from Apress as well as Python Interviews from Packt Publishing.
Michael is currently working on some new books as well.