What problem does it solve?
Automates end-to-end Excel workbook processing, including reading, creating, editing, and validating spreadsheets through a deterministic XML-based workflow.
Core Features & Use Cases
- Handles: READ (analyze and extract), CREATE (from scratch using XML templates), EDIT (surgical XML edits with integrity), and VALIDATE (static and potential dynamic checks) for .xlsx/.xlsm/.csv/.tsv files.
- Supports: creating new workbooks from the provided minimal_xlsx template, performing deterministic edits via xlsx_unpack/xlsx_pack, and validating formulas with formula_check.py (and optional LibreOffice recalculation).
- Use Case: Automate a multi-sheet financial model by generating the workbook skeleton, populating input cells, wiring cross-sheet formulas, and verifying all formulas and references before packaging.
Quick Start
Provide an input workbook and specify the operation to begin processing.