xlsx
Installation
SKILL.md
XLSX Skill
Handle the request directly. Do NOT spawn sub-agents. Always write the output file the user requests.
Task Routing
| Task | Method | Guide |
|---|---|---|
| READ — analyze existing data | xlsx_reader.py + pandas |
references/read-analyze.md |
| CREATE — new xlsx from scratch | openpyxl (Python) | See CREATE section below |
| EDIT — modify existing xlsx | XML unpack→edit→pack | references/edit.md (+ references/format.md if styling needed) |
| FIX — repair broken formulas | XML unpack→fix <f> nodes→pack |
references/fix.md |
| VALIDATE — check formulas | formula_check.py |
references/validate.md |
READ — Analyze data (read references/read-analyze.md first)
Start with xlsx_reader.py for structure discovery, then pandas for custom analysis. Never modify the source file.
Formatting rule: When the user specifies decimal places (e.g. "2 decimal places"), apply that format to ALL numeric values. Never output 12875 when 12875.00 is required.