set_workbook_properties
Set workbook document properties and calculation settings, including calc mode and iterative calculation. Read current values when no parameters are given, with automatic backup and atomic save.
Instructions
Set core document properties (title, author, subject, keywords, category, comments) and calc settings: calc_mode ('auto', 'autoNoTable', 'manual'), full_calc_on_load, and iterative calculation (iterative_calc with max_iterations and max_change bounds for circular references). Only given parameters change; with none it reports current values read-only. Manual mode means no recalc on Excel open, so caches go stale; the result says so. Auto-backup; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| title | No | ||
| author | No | ||
| backup | No | ||
| subject | No | ||
| category | No | ||
| comments | No | ||
| keywords | No | ||
| calc_mode | No | ||
| allow_loss | No | ||
| max_change | No | ||
| verify_com | No | ||
| iterative_calc | No | ||
| max_iterations | No | ||
| full_calc_on_load | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||