set_workbook_properties
Set workbook metadata and calculation options, including title, author, keywords, calc mode, and iterative calculation settings, with read-only reporting and safe backup.
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 |