xlsx_eval
Evaluate Excel formulas and cell references in a .xlsx file to retrieve live computed values, bypassing stale caches.
Instructions
evaluate Excel formulas against a LOCAL .xlsx file via HyperFormula. xlwings-style.
Two modes: pass formulas (array of "=SUM(A1:A10)" expressions to compute against the workbook) or cells (array of "Sheet1!A1" cell refs to fresh-evaluate). Replaces pandas' "trust the cached value" behavior with a real eval — if the cache is stale or missing, this still produces the right answer.
USE WHEN: the user wants the live computed value of a formula, not the cached one. Or when a workbook has formulas that depend on external data the cache might be stale on. Engine omits INDIRECT/HYPERLINK/WEBSERVICE/RTD/DDE by design — no I/O risk.
DO NOT USE WHEN: the workbook has no formulas (use xlsx_read). Or for upload/attached files.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cells | No | ||
| file_b64 | Yes | ||
| formulas | No | ||
| options | No |