doc_properties
Retrieve workbook properties or set calculation mode to control formula recalculation in Excel files, with options for auto, manual, or autoNoTable.
Instructions
Read document properties or set calculation mode.
Args: action: "get" or "set_calc_mode". file_path: Workbook path. calc_mode: "auto", "manual", or "autoNoTable" for setting calculation mode.
Returns: dict or str: Properties dict for "get"; status message for "set_calc_mode".
Notes: - Changing calc mode changes workbook behaviour for formula recalc; mention effect in docs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| calc_mode | No | auto | |
| file_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |