Agent skill · daymade
excel-automation
Creates formatted Excel reports with openpyxl, parses complex xlsm financial models with stdlib zipfile+xml when openpyxl fails, and controls Excel windows on macOS via AppleScript. Reconstructs images or scans of paper forms as editable XLSX files with printable layouts.
What it needs
About 6k tokens when loaded.
What this skill does
Excel Automation Create professional Excel files, parse complex financial models, and control Excel on macOS. For an image or scan of a paper form that needs editable cells and a printable layout, load Printable forms before creating the workbook. Follow the host's designated spreadsheet authoring tool; use the openpyxl examples below only when that tool is permitted. Quick Start Before a command brings Excel forward or changes its visible window, check user activity and other agents' occupancy. Use only foreground operations covered by the current task's authorization. If the surface is in use, occupancy is unknown, or unexpected input occurs, stop input and continue independent background work. Overview 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) Apply these colors to financial reports using that convention. For a paper form, preserve its intended print appearance; do not add input colors by default. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills daymade/excel-automation--88f077