Edit Excel and Google Spreadsheets with Python: An Introduction
summary
Shows how to use openpyxl 3.1.2 to read and write .xlsx files (no Excel needed, .xlsx are ZIPped XML), and how to use EZSheets / Easy Sheets to edit Google Sheets after a one-time OAuth setup including a downloaded credentials-sheets.json and browser approval. Notes that openpyxl does not evaluate formulas (use data_only to read Excel’s cached values), can create charts, and that Google APIs enforce quotas (roughly 100 reads/writes per 100 seconds), with edits via Easy Sheets taking effect in real time.
AI-written summary · about
chapters (7)
- 0:00Introduction and setup
- 1:25Spreadsheet automation value
- 4:32Overview of library modules
- 6:45Working with spreadsheet data
- 9:04Programming with Openpyxl
- 27:54Google Sheets authentication
- 39:27EasySheets API usage
related talks
39mPython & Spreadsheets: 2017 Edition
01h 16mExploring Google APIs with Python & JavaScript
24mHow to build a spreadsheet with Python
23mAs a Teacher. I have no Time to learn Programming - Streamline Assignment Marking with Python
24mExtracting data from Excel with Python
32mWork Less and Do More: Google Sheets for JavaScript Developers
48mSmart Spreadsheets
51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights