skills.rest
proompteng
proomptengOFFICIAL
Explore all skills by this author →
WebsiteGitHub

sheetjs-formula-recalc

Recalculate SheetJS workbook formulas in Node.js after input edits.

35|19|Updated Mar 13, 2026
Search Tags:#typescript#xlsx#node#workbook#readback#sheetjs#formula-recalculation
One-click install
npx skills add https://github.com/proompteng/bilig --skill sheetjs-formula-recalc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sheetjs-formula-recalc
Source: https://github.com/proompteng/bilig/tree/main/packages/sheetjs-formula-recalc
Command: npx skills add https://github.com/proompteng/bilig --skill sheetjs-formula-recalc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SheetJS workbook workflows often require fresh formula readback after inputs are written, without launching Excel, LibreOffice, or a browser. This skill provides a Node.js boundary to recalculate formulas and patch outputs so downstream code can verify updated results.

Core Features & Use Cases

  • Recalculate SheetJS/xlsx formulas after edits to inputs using a SheetJS-compatible workflow.
  • Expose a Node.js API (recalculateSheetjsWorkbook) and a CLI (sheetjs-recalc) for quick demonstrations and production usage.
  • Validate and read specific cells after recalculation (reads) and apply edits to inputs (edits) to produce deterministic outputs.

Quick Start

Run the demo to see fresh formula readbacks after editing inputs.

Frequently Asked Questions about sheetjs-formula-recalc

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I recalculate xlsx formulas in Node.js after editing inputs without opening Excel?▼

You can recalculate SheetJS workbook formulas in Node.js after editing inputs by applying a compatible workflow that patches outputs directly. This avoids launching Excel or LibreOffice while providing up-to-date formula readback for downstream verification.

Why does SheetJS not update formula results when I write new inputs to a workbook?▼

SheetJS does not natively compute formulas on write, leaving formula results stale after input edits. A dedicated recalculation boundary is required to re-evaluate formulas and patch workbook outputs for accurate readback.

Can I use SheetJS to read specific cells after recalculating formulas programmatically?▼

Yes, you can validate and read specific cells after recalculation to produce deterministic outputs. This workflow ensures the cell values you read reflect the newly calculated formula results based on edited inputs.

Does the SheetJS formula recalculation workflow require a browser or LibreOffice to run?▼

No, the SheetJS formula recalculation workflow does not require a browser, Excel, or LibreOffice. It operates entirely within a Node.js environment, providing a programmatic API and CLI to refresh formula results.

What is the best way to refresh stale formula results in a SheetJS workbook for automated testing?▼

The best way to refresh stale formula results is using a Node.js formula recalculation tool chain that exposes both an API and CLI. This approach applies edits, recalculates formulas, and validates reads for deterministic automated outputs.

Related Skills

Explore More Software Engineering Skills→
DatTran26DatTran26

ck:xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with Excel formulas.

Community
Advanced
decocmsdecocms
396

xlsx

Extract cell data from Excel workbooks into tab-separated text.

Official
Basic
NickCrewNickCrew
29

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

Community
Advanced
jr2804jr2804

xlsx

Create, edit, and analyze Excel-compatible spreadsheets with formulas.

Community
Advanced