OpenPyXL - Using Python to Automate Spreadsheets
Part 1
Oct 22, 20224 min read138
Command Palette
Search for a command to run...
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.
OpenPyXL - Working with CSV Files
Part 2
Oct 22, 20224 min read7.2K
Python - OpenPyXL - Styling a Spreadsheet
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 Countries of the World (kaggle.com). For this post I'm assuming you have a working knowledge of Python and...
Jan 31, 202413 min read2.3K