Contact Us
24/7
Python BlogDjango BlogBig DataSearch for Kubernetes AWS BlogCloud Services

News

<< All NewsLive Demo: Automating Spreadsheets with Python, OpenPyXL and Pandas

Live Demo: Automating Spreadsheets with Python, OpenPyXL and Pandas

October 18, 2021

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.

Watch the presentation:

Tell us about the goals you’re trying to accomplish.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.