Home/Spreadsheet Automation

Spreadsheet Automation

2 articles

Python for Business Analysts: Office Automation and Data Science Basics · Spreadsheet Automation

10 Repetitive Spreadsheet Jobs You Can Automate With pandas

Stop cleaning the same messy exports every week If you’re looking into pandas automation, this is usually where the pain starts. Someone exports a spreadsheet from a CRM,…

Python for Business Analysts: Office Automation and Data Science Basics · Spreadsheet Automation

Beginner's Tutorial: Reading and Updating Excel Workbooks With openpyxl

Start With the Right Workbook Setup So openpyxl Doesn’t Fight You If you searched for an openpyxl tutorial, you probably want one thing: read an Excel file with Python, c…