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: