xlsx
Installation
Summary
Create, edit, and analyze Excel spreadsheets with formulas, formatting, and error-free calculations.
- Supports reading, creating, and modifying .xlsx, .xlsm, .csv, and .tsv files using pandas for data analysis and openpyxl for formulas and formatting
- Automatically recalculates all formulas and scans for Excel errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?) using LibreOffice integration
- Enforces industry-standard color coding and number formatting for financial models (blue for inputs, black for formulas, green for internal links, red for external links)
- Includes comprehensive documentation requirements for hardcoded values and assumption-based formula construction to maintain dynamic, updateable spreadsheets
SKILL.md
Contains Shell Commands
This skill contains shell command directives (!`command`) that may execute system commands. Review carefully before installing.
XLSX creation, editing, and analysis
| Task | Approach |
|---|---|
| Create or edit with formulas/formatting | openpyxl — see gotchas below |
| Bulk data in or out | pandas (read_excel, to_excel) |
| Quick look at a sheet | markitdown file.xlsx — ## SheetName per sheet; reads .xlsm too. No cell coordinates, so don't plan edits from it |
| Read a model (formulas and values) | two load_workbook passes — see gotchas |
openpyxl,pandas, andmarkitdownare preinstalled — do not runpip installfirst; write the script and import directly. Only if an import fails (or themarkitdowncommand is missing):pip installthe missing package.
Script paths below are relative to this skill's directory.