What problem does it solve?
Excel workbooks commonly drift after updates, with incorrect layouts, stale cached values, or hidden formula bugs. This Skill provides a structured verification flow that renders layouts, recomputes formulas, and analyzes formulas for semantic issues to ensure the workbook is correct before sharing or deployment.
Core Features & Use Cases
- Render visual verification to confirm layout, formatting, and presentation of workbook ranges.
- Recalculate formulas to validate results and detect discrepancies between expected and computed values.
- Lint formulas to catch semantic bugs and risky patterns that could lead to incorrect results.
- Use Case: verify a quarterly model after updates by rendering critical sheets, running a verification calc, and linting before delivery to stakeholders.
Quick Start
Run witan xlsx render <file> -r "Sheet1!A1:Z50" to visually verify layout, then run witan xlsx calc <file> --verify and witan xlsx lint <file> to complete a non-mutating verification gate.