What problem does it solve?
This Skill automates the creation, styling, and validation of Excel workbooks (XLSX/XLSM) using Python (openpyxl & pandas), enabling deterministic outputs, built-in formula deployment, currency formatting, and charts.
Core Features & Use Cases
- Workbook creation & styling: generate Excel files with formulas, custom formats, and charts from structured data.
- Deterministic validation flow: integrate with KimiXlsx tools to recheck formulas, detect reference errors, inspect sheet structures, and validate the final OpenXML file.
- Pivot-enabled reporting: create and style PivotTables and charts via the dedicated pivot command, ensuring accurate data summarization.
- External data citation: when data is fetched externally, include per-row citations or a dedicated Sources sheet to comply with sourcing requirements.
Quick Start
Start by creating a minimal workbook with a Cover page and a Data sheet, then run the validation workflow:
- Create a basic workbook using Python with openpyxl/pandas.
- Run recheck and reference-check on the generated file.
- If a PivotTable is required, use the pivot command and then run validate.