What problem does it solve?
This Skill provides an end-to-end, XML-centric workflow to create, read, edit, analyze, and validate Excel workbooks without OpenPyXL, enabling precise, production-grade manipulation of OOXML files.
Core Features & Use Cases
- Brand-new workbook creation from a minimal template using direct XML edits and a pack step.
- Surgical editing of existing workbooks with minimal, scoped changes via unpack/edit/pack.
- Dynamic and static formula validation using dedicated scripts, plus packaging and revalidation as a finished deliverable.
- Cross-sheet references, multi-sheet workflows, and consistent style/formatting using a predefined 13-slot style system.
- Automated data-reading and analysis paths via the included scripts, supporting Excel/CSV data ingestion and transformation workflows.
Quick Start
Unpack a workbook, perform the required XML edits (data, formulas, or structure), then re-pack and validate the workbook.