xlsx
Read, create, edit, recalculate and check Excel workbooks (.xlsx, .xlsm, .xls, .csv) with openpyxl, pandas and XlsxWriter, including formulas, formatting, charts and financial models (projections, valuation, budgets). Use whenever a spreadsheet is an input or the deliverable. Covers live formulas instead of pasted results, financial-model conventions (colour coding, number formats, formula rules), recalculation through dsoffice with a scan of every cell for
Pinned to revision aea23648def3, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/xlsx/SKILL.md
- skills/xlsx/LICENSE.txt
- skills/xlsx/reference/financial-models.md
- skills/xlsx/reference/formula-errors.md
- skills/xlsx/scripts/check_office.py
- skills/xlsx/scripts/model_audit.py
- skills/xlsx/scripts/recalc_check.py
Every link opens the file at its source, pinned to the revision this page describes.