Automating Excel with Python Video Overview

In this tutorial, I will show you an overview of using OpenPyXL and Python to read and write Excel documents. You will also learn how to:

• Style cells
• Change fonts
• Create named styles
• Use pandas with Excel
• Combine pandas and OpenPyXL
• Basics of using XslxWriter

The code in this tutorial is based on code from my book, Automating Excel with Python:

• Gumroad (eBook)
• Leanpub (eBook)
• Amazon (paperback)