Agent skill · daymade
excel-automation
Create, parse, and control Excel files on macOS. Professional formatting with openpyxl, complex xlsm parsing with stdlib zipfile+xml for investment bank financial models, and Excel window control via AppleScript. Use when creating formatted Excel reports, parsing financial models that openpyxl cannot handle, or automating Excel on macOS.
What it needs
About 5k tokens when loaded.
What this skill does
Excel Automation Create professional Excel files, parse complex financial models, and control Excel on macOS. Quick Start Overview Three capabilities: Capability Tool When to Use ----------- ------ ------------- Create formatted Excel openpyxl Reports, mockups, dashboards Parse complex xlsm/xlsx zipfile + xml.etree Financial models, VBA workbooks, >1MB files Control Excel window AppleScript (osascript) Zoom, scroll, select cells programmatically Tool Selection Decision Tree Signals of "complex" Excel: file >1MB, .xlsm extension, from investment bank/broker, contains VBA macros. IMPORTANT: Always run file <path> first — extensions lie. A .xls file may actually be a ZIP-based xlsx. Creating Excel Files (openpyxl) Professional Color Convention (Investment Banking Standard) Color RGB Code Meaning ------- ---------- --------- Blue 0000FF User input / assumption Black 000000 Calculated value Green 008000 Cross-sheet reference White on dark blue FFFFFF on 4472C4 Section headers Dark blue text 1F4E79 Title Core Formatting Patterns Number Format Codes Format Code Example -------- ------ --------- Currency '$#,##0' $1,234 Currency with decimals '$#,##0.00' $1,234.56 Percentage '0.0%' 12.3% Percentage (2 decimal) '0.00%' 12.34% Number with commas '#,##0' 1,234 Multiplier '0.0x' 1.5x Conditional Formatting (Sensitivity Tables) Red-to-green gradient for sensitivity analysis: Execution Full template script: See scripts/createformattedexcel.py Parsing Complex Excel (zipfile + xml) When openpyxl fails on complex xlsm files (corrupted DefinedNames, complex VBA), use stdlib directly. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills daymade/excel-automation--88f077