Spreadsheets are OFTEN terrible. They're also everywhere! As one of the default forms of data exchange, learning to work with spreadsheets directly via Python can save time and effort. We'll look at Openpyxl, a library that lets you do just that. We'll look at at least two different (beginner-friendly)example cases: transforming one spreadsheet into another spreadsheet and converting a spreadsheet into JSON. I'll also use my experience as a former accountant to highlight some of the issues around reading from and writing to a spreadsheet file and how you might deal with them. You MAY even learn to make new friends and grow the Python community! True Story!
Kojo Idrissa was an accountant who got an MBA and taught at university in two different countries. He's now a new(ish) software engineer and is still trying to figure that out and grow into the role. He's spoken at tech conferences about spreadsheets, contributing to tech communities, Dungeons & Dragons, inclusion and privilege. You can find him online at http://kojoidrissa.com/ or as @transition on Twitter. He knows WAY more about K-Pop than you.