Create professional Excel files, parse complex financial models, and control Excel on macOS.
| 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 |
Signals of "complex" Excel: file >1MB, .xlsm extension, from investment bank/broker, contains VBA macros.
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. Source: daymade/claude-code-skills.