Edit Excel and Google Spreadsheets with Python: An Introduction

Edit Excel and Google Spreadsheets with Python: An Introduction by Al Sweigart @ Invent with Python
No matter your technical level or job title, if you work in an office you probably can’t escape Excel and Google Sheets. Break free by learning how Python can automate reading and writing spreadsheets with the author of Automate the Boring Stuff with Python.
You aren’t limited to editing spreadsheets through your keyboard and mouse in Excel or Google Sheets. You can write Python scripts to automate the creation, updating, and verification of spreadsheets with the free, open source OpenPyXL and EZSheets modules. This talk covers the installation and basic features of both modules, along with common use cases and misconceptions. Most importantly, we’ll walk through cleaning up data in a spreadsheet that cannot easily be done from within the spreadsheet applications but requires the power of Python scripting.
The 5th annual Python Web Conf (#PWC2023) inspired attendees to use technology for good. The conference attracted 315 attendees from over 30 countries across 15 time zones. The highly engaging format featured 70 speakers, 5 tracks (including 64 talks and 5 tutorials) and took place virtually on March 13-17, 2023 on LoudSwarm by Six Feet Up.
More information about the conference can be found at: 2023.pythonweb...