automating-excel
Automates Microsoft Excel on macOS via JXA with AppleScript dictionary discovery. Use when asked to "automate Excel spreadsheets", "JXA Excel scripting", "Excel macOS automation", or "bulk Excel data operations". Focuses on workbooks, worksheets, ranges, 2D arrays, performance toggles, and VBA escape hatches.
Pinned to revision 5f37bd4ecb17, so it is the text this page describes rather than whatever the author pushed since.
Pre-approved tools experimental
Experimental field. Support varies between clients, so this list is what the author declared, not what your client will enforce.
- Bash
- Read
- Write
Files
- skills/automating-excel/SKILL.md
- skills/automating-excel/references/excel-advanced.md
- skills/automating-excel/references/excel-basics.md
- skills/automating-excel/references/excel-charts.md
- skills/automating-excel/references/excel-dictionary.md
- skills/automating-excel/references/excel-pivots.md
- skills/automating-excel/references/excel-pyxa.md
- skills/automating-excel/references/excel-recipes.md
- skills/automating-excel/scripts/create_excel_spreadsheet.py
- skills/automating-excel/scripts/export_excel_to_csv.py
- skills/automating-excel/scripts/import_csv_to_excel.py
- skills/automating-excel/scripts/set_up_excel_automation.py
- skills/automating-excel/scripts/set_up_excel_automation.sh
Every link opens the file at its source, pinned to the revision this page describes.