Series

OpenPyXL - Automating Spreadsheets

This series is about using Python and the OpenPyXL package to automate handling Excel spreadsheets. Including styling, adding charts and adding formulas.

Articles in this series

OpenPyXL - Using Python to Automate Spreadsheets

Oct 22, 20224 min read

Part 1 · Python is a general-purpose language that is capable of working on many different project types. People create web sites, games, data science,...

OpenPyXL - Using Python to Automate Spreadsheets

OpenPyXL - Working with CSV Files

Oct 22, 20224 min read

Part 2 · Welcome to the second part in this series. This isn't covering features of OpenPyXL directly. But since a lot of the data brought into Excel is...

Python - OpenPyXL - Styling a Spreadsheet

Jan 31, 202413 min read

The best way to learn anything is to actually try it. Let's see how OpenPyXL works and style a spreadsheet. The Dataset I've chosen is a CSV of...

Python - OpenPyXL - Styling a Spreadsheet