Excel
Protecting a Generated Workbook From Accidental Edits
Lock the cells, sheets and structure of a workbook your script generates so readers cannot break formulas, with openpyxl and XlsxWriter, and know the limits.
7 min read
Topic
Scripting
Shell one-liners and small scripts that turn your repeated database chores into a single command.
Excel
Watching a Folder for New Excel Files and Importing Them
Watch a folder for new Excel files and import each once: polling or watchdog, waiting for the copy to finish, moving files, idempotent loads and failures.
7 min read
Excel
Batch Converting XLS Files to XLSX With LibreOffice
Convert a folder of old XLS files to XLSX with LibreOffice headless, Python or Excel automation, and check what formatting and formulas survive.
6 min read
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
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
JSON
Parsing JSON in Go With Struct Tags and the Standard Library
Decode JSON into Go structs with struct tags: null versus missing with pointers, case-insensitive keys, int64 ids, wrong-type errors and the omitempty trap.
6 min read
JSONGuide
JSON in Go Java Rust C Sharp PHP Ruby Compared Side by Side
One order document read in Go, Java, Rust, C#, PHP, Ruby, Python, Node and Bash: unknown keys, case, nulls, big ints, depth, duplicates and strictness.
18 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
Get new articles by email
We send one email when a new article is published. No spam.