xlsx-verify

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.