Set Workbook Properties
set_workbook_propertiesSet core Excel document properties and calculation settings, including title, author, keywords, calc mode, and iterative calculation options, preserving unspecified values and saving atomically.
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 |