Setup & Installation
What This Skill Does
Handles Excel and CSV/TSV files through direct XML manipulation rather than library round-trips. Covers reading, creating from scratch, editing existing files without format loss, formula repair, and validation. Applies financial formatting standards including formula-based calculations and color-coded cell roles.
Unlike openpyxl round-trips that corrupt VBA macros, pivot tables, and sparklines, this skill edits the underlying XML directly so existing formatting and features survive.
When to use it
- Reading a multi-sheet .xlsx file to extract summary statistics into a report
- Building a financial model from scratch with SUM formulas and accounting-style borders
- Adding a percentage column to an existing budget spreadsheet without touching other data
- Fixing broken cross-sheet references in an inherited Excel file
- Validating that all calculated cells use formulas rather than hardcoded values