Get Range Formulas
get_range_formulasRetrieve formulas from an Excel range in a live workbook, returning A1-style formulas or literal values for cells without formulas. Ideal for extracting formula logic from open workbooks.
Instructions
Read formulas from a cell or range.
Formulas are returned A1-style (e.g. "=SUM(A1:A10)"). Cells without a formula return their literal value instead.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1" or "A1:C10".
Returns: JSON with the formulas/values as a 2D array.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| workbook | No | ||
| range_address | No | A1 |