Run the XLSX recalculation proof in Node.js

This is the fastest honest test for Bilig’s XLSX formula-recalculation claim. It does not require cloning the monorepo.

The script creates a quote workbook, writes it to .xlsx, imports the file through @bilig/headless/xlsx, changes input cells, reads recalculated formula outputs, exports the edited workbook, reimports that edited file, and checks that formulas survived the round trip.

Run it in a blank folder

mkdir bilig-xlsx-proof
cd bilig-xlsx-proof
npm init -y >/dev/null
npm pkg set type=module
npm install @bilig/headless tsx
curl -fsSLO https://proompteng.github.io/bilig/xlsx-recalculation-proof.ts
npx tsx xlsx-recalculation-proof.ts

Expected output includes:

{
  "proof": "Bilig recalculated formula-backed XLSX state in Node.js without opening Excel.",
  "before": {
    "decision": "review"
  },
  "after": {
    "decision": "approved"
  },
  "checks": {
    "decisionChanged": true,
    "recalculatedMargin": true,
    "exportedReimportMatchesAfter": true,
    "formulasSurvivedXlsxRoundTrip": true,
    "allExpectedValuesMatched": true
  },
  "excelParity": "not_proven"
}

The JSON is proof data only. Star, watch, and discussion links stay in the page copy after the expected values match.

The script writes inspectable files to bilig-xlsx-proof-output/:

quote-model-source.xlsx
quote-model-edited.xlsx

What this proves

This proves the backend workflow that xlsx-template, xlsx-populate, ExcelJS, and SheetJS users often hit after generating a workbook:

the .xlsx file exists as a real boundary;
the Node process edits known input cells;
formula outputs change immediately;
the edited .xlsx can be exported;
a reimported copy reads the same calculated state;
the approval formula is still present after export.

It does not prove full Excel compatibility. If the workbook depends on pivots, macros, charts, volatile functions, or exact Excel UI behavior, keep Excel, LibreOffice, or Microsoft Graph in the loop.

Source

If this is the Node/XLSX workflow you need, keep the repository and release feed nearby: https://github.com/proompteng/bilig.