xlsx-formula-recalc

Recalculate stale cached XLSX formulas in Node.js workflows.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Recalculate stale cached XLSX formulas inside a Node.js workflow without relying on Excel, LibreOffice, or UI automation, ensuring outputs reflect updated inputs.

Core Features & Use Cases

  • Deterministic formula readback: refresh formula results after programmatic edits to inputs.
  • External-workbook support: hydrate and recalc formulas that reference other workbooks.
  • Diagnostic-ready: provide reads, changes, and engine diagnostics suitable for CI and agent-tooling.

Quick Start

Edit the workbook inputs and run the evaluator to refresh formula results.

Frequently Asked Questions about xlsx-formula-recalc

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

FAQPage Schema
How do I recalculate stale cached XLSX formulas in Node.js without Excel?

To recalculate stale cached XLSX formulas in Node.js without Excel, you can use a streaming-native engine to programmatically edit workbook inputs and run an evaluator to refresh formula results. This ensures outputs reflect updated inputs within your workflow.

Why do my XLSX formulas show stale cached values after programmatic edits?

XLSX formulas show stale cached values because the workbook stores the last calculated result. Without an application like Excel to trigger a recalculation, programmatic edits to inputs require a dedicated Node.js evaluator to identify and refresh the outdated formula results.

Can I recalculate XLSX formulas that reference external workbooks in Node.js?

Yes, you can recalculate XLSX formulas referencing external workbooks in Node.js. The evaluator hydrates and recalculates formulas that depend on other workbooks, ensuring cross-workbook dependencies are resolved and updated correctly without needing Excel.

What is the best way to automate XLSX formula recalculation for CI pipelines?

The best way to automate XLSX formula recalculation for CI pipelines is using a deterministic, file-backed Node.js workflow. It provides reads, changes, and engine diagnostics suitable for agent-tooling, ensuring reliable formula readback after programmatic edits.

Do I need LibreOffice or UI automation to refresh XLSX formula results in a Node.js workflow?

No, you do not need LibreOffice or UI automation to refresh XLSX formula results. You can configure reads and edits with robust error handling directly in Node.js using a streaming-native engine option to recalculate formulas independently.