The October 2021 edition of IndyPy — Indiana’s largest Python meetup founded in 2007 by Six Feet Up CTO and Amazon Web Services (AWS) Community Hero, Calvin Hendryx-Parker — featured a live demo about “Automating Spreadsheets with Python, OpenPyXL and Pandas.”
Speaker David Sol, an AWS Community Builder and AWS Certified DevOps Engineer Professional, hosted an engaging presentation and discussion about how to eliminate the need to manually import data into Excel or another spreadsheet — potentially saving users days of time while getting better results.
Watch how David uses Python, together with the OpenPyXL and Pandas libraries, to easily automate spreadsheets in the video below.
Read our live Twitter thread, and check out David’s repository on GitLab for a deeper dive.