set_dimensions
Set column widths, row heights, and visibility for Excel rows and columns, or autofit columns to content. Maintains safety with backups, atomic saves, and refusal to modify open files.
Instructions
Set column widths and row heights, hide rows or columns, and service an autofit request. column_widths maps column letters or indices to widths in Excel character units; row_heights maps row numbers to heights in points; autofit_columns sizes columns to content as a best-effort APPROXIMATION (true autofit needs Excel via the com pack). A hazardous workbook refuses unless allow_loss is true. Auto-backup to .ks4xl-backups; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheet | No | ||
| backup | No | ||
| hide_rows | No | ||
| allow_loss | No | ||
| verify_com | No | ||
| row_heights | No | ||
| hide_columns | No | ||
| column_widths | No | ||
| autofit_columns | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||