Set sheet layout
set_sheet_layoutSet column widths, row heights, frozen panes, auto filters, and tab colors in Excel sheets. Use autofit columns to size columns to content and freeze panes for easier navigation.
Instructions
Set column widths, row heights, frozen panes, the auto filter and the tab color.
autofit_columns estimates widths from the text length of the column's values.
freeze_panes is the first unfrozen cell: 'A2' freezes the top row, 'B2' the top row
and first column, and 'A1' unfreezes. auto_filter is a range such as 'A1:F100'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. | |
| sheet | Yes | Worksheet name, e.g. 'Sheet1'. | |
| layout | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |