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: