Sheetjs Formula Recalc

Add fresh formula readback to SheetJS and xlsx workflows after writing XLSX inputs in Node.js.

proompteng Updated
A WorkPaper input edit recalculating a formula, then surviving JSON restore

File contents

SheetJS Formula Recalculation

Use sheetjs-formula-recalc when an agent or Node.js service has changed XLSX inputs through SheetJS / xlsx and must read recalculated formula outputs without opening Excel, LibreOffice, or a browser.

First Check

npx --package sheetjs-formula-recalc sheetjs-recalc --demo --json

The demo should print verified: true and a Summary!B2 value of 72000.

Real Workbook

npx --package sheetjs-formula-recalc sheetjs-recalc workbook.xlsx \
  --set Inputs!B2=48 \
  --read Summary!B7 \
  --out workbook.recalculated.xlsx \
  --json

TypeScript

import { recalculateSheetjsWorkbook } from 'sheetjs-formula-recalc'

const result = recalculateSheetjsWorkbook(inputXlsxBytes, {
  edits: [{ target: 'Inputs!B2', value: 48 }],
  reads: ['Summary!B7'],
})

Use xlsx-formula-recalc when the caller does not care about SheetJS naming, and use exceljs-formula-recalc when the caller owns an ExcelJS Workbook object and wants read results patched back into that object.

proompteng/bilig commit f98fc42eb3

Frequently asked questions

npx get-skill add proompteng/sheetjs-formula-recalc