set_view
Set Excel sheet view options in one call: freeze/split panes, toggle gridlines and headings, adjust zoom, set active selection, and tab color. Atomic save with auto-backup.
Instructions
Set sheet-view state in one call: freeze panes (freeze='B2' locks the rows above and columns left of it; 'clear' removes), split panes (split={x, y} positions in points, exclusive with freeze), gridlines and headings visibility, zoom (10 to 400 percent), the active selection (an A1 cell or range), and the sheet tab color (6-digit hex or 'clear'). Unset parameters keep their current values; sheet defaults to the active sheet. Auto-backup to .ks4xl-backups; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| zoom | No | ||
| sheet | No | ||
| split | No | ||
| backup | No | ||
| freeze | No | ||
| headings | No | ||
| gridlines | No | ||
| selection | No | ||
| tab_color | No | ||
| allow_loss | No | ||
| verify_com | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||