ExcelCannon release notes

Install: dotnet tool install -g RDLL.excelcannon · NuGet · GitHub releases

0.1.0

2026-08-08 · schema v4

  • Legacy indexed colors now resolve to real RGB — regulatory workbooks (EBA COREP, older Excel files) use the legacy palette, and color often encodes meaning like cell editability; the model now shows #RRGGBB everywhere.
  • ~23% smaller text renders on style-heavy workbooks — style legends are compressed (per-sheet aliases, style families, inline props for rare styles), so more workbook fits in an LLM context window. On the EBA COREP annotated layout: 2.89 MB → 2.24 MB, one sheet's legend from 62 entries to 9.
  • Breaking: canonical JSON SCHEMA_VERSION is now 4 (style ids change because color resolution tightens deduplication). Re-extract stored models; text↔JSON round-trip remains byte-exact.
  • Upgrade: dotnet tool update -g RDLL.excelcannon

0.0.1

2026-08-08 · first release

  • Extract a canonical, deterministic model from .xlsx/.xlsm: cells, formulas, styles, merged headers, tables, dropdowns/validations, conditional formatting, named ranges, frozen panes, VBA macro source. JSON for machines + a compact text render for LLM inference.
  • Understand how the workbook functions: detected column headers, cell roles (input / computed / label), a first-class input surface (every fillable field with its label and constraint), and dependency summaries.
  • Diff two workbooks — or a blank template against a filled one — with category percentages (values / formulas / structure / format) and an input-surface completion score. CI-friendly exit codes.
  • Lint filled templates: broken references, validation violations, formulas overwritten with literals, error values, blank inputs.
  • Battle-tested against a 89-workbook corpus including EIOPA Solvency II QRT sets (574 sheets), EBA COREP/Pillar 3 layouts, and real filled bank/insurer disclosures.