Excel
Splitting One Excel Sheet Into a Workbook per Group
Split one Excel sheet into a workbook per region or customer with pandas groupby, safe file names, formatting, a manifest and checks that the parts add up.
7 min read
Tag
automation
40 posts
Excel
Merging Hundreds of Workbooks Into One Table With Python
Combine hundreds of Excel files into one table with Python: glob, read each sheet, check headers, add the source name, quarantine bad files and verify counts.
7 min read
Excel
Automating Weekly Excel Reports With Python and cron
Build a weekly Excel report with Python: query the database, write the workbook, email it and schedule it with cron, with paths, logs, locks and failures.
7 min read
Excel
Office Scripts for Excel on the Web and Power Automate
Office Scripts automate Excel on the web with TypeScript. Record an action, edit the code, run it from Power Automate on a schedule, and know its limits.
7 min read
Excel
How Running a Python Script From Excel With xlwings Works
Run Python from an Excel button with xlwings: install, quickstart, RunPython and RunPython, read and write ranges, user defined functions and the limits.
7 min read
Excel
VBA Versus Python for Excel Automation in Real Projects
Compare VBA and Python for automating Excel by where the code runs, what it can touch, how it is tested and who maintains it, with a rule for choosing.
8 min read
CSV
Scheduling CSV Reports From SQL With cron Reliably
A cron job that writes a daily CSV report from SQL: wrapper script, atomic output, a lock against overlap and the environment traps that bite at 2 a.m.
7 min read
CSV
Logging Rejected Rows From a CSV Import for Review
Capture every row an import refuses, with its line, column and reason, in a form a person can fix and replay. A DuckDB example with real reject tables.
6 min read
CSV
Handling a CSV Provider Who Changes Columns Without Warning
A provider adds, renames or reorders columns and your load breaks or, worse, succeeds. A header check that names the change, aliases and a policy per case.
7 min read
CSV
Seeding a Database From CSV Files With dbt Seeds Safely
Load small reference CSVs with dbt seeds from version control, set column types so zip codes keep their zeros, and learn when seeds are the wrong tool.
6 min read
CSV
Loading CSV Files in Airflow With a Plain Python Task
Load a daily CSV in Airflow with one plain Python task instead of a chain of operators: idempotent by date, safely retried and testable outside Airflow.
7 min read
CSV
Watching a Folder for New CSV Files and Importing Them
Poll a folder for new CSV files and import each only once it has stopped changing. Why file events fire too early, a stable-file watcher and inotify on Linux.
7 min read