xlsx_formulas
Extract every formula from a local .xlsx workbook, returning cell coordinates, formula text, and cached results. Audits, transforms, or rewrites formulas without evaluating them.
Instructions
extract every formula in a LOCAL .xlsx workbook — cell coord (A1), formula text, cached result. openpyxl-style read-only metadata. Distinct from xlsx_read which returns evaluated values; this returns the formulas themselves so an agent can audit, transform, or rewrite them.
USE WHEN: the user wants to see what formulas a workbook uses — spot-checking a model, auditing references, debugging unexpected results. pandas cannot extract formulas; this is the only way for an agent to see them.
DO NOT USE WHEN: the user wants computed values (use xlsx_read). Or for upload/attached files.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes | ||
| options | No |