formula_audit
Inspect Excel formulas to retrieve cached values, identify errors, map precedents and dependents, or list all formulas in a worksheet.
Instructions
Inspect formulas: get cached value, list errors, find precedents/dependents, or list all formulas.
Args: action: "value", "errors", "precedents", "dependents", or "list". file_path, sheet_name: Workbook and sheet. cell_ref: Required for "value", "precedents", and "dependents". cell_range: Optional range filter for "errors".
Returns: dict or list: Action-dependent payload (e.g. value, list of FormulaErrorInfo, list of cell refs).
Notes: - Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| cell_ref | No | ||
| file_path | Yes | ||
| cell_range | No | ||
| sheet_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |