worksheet_view
Adjust Excel worksheet view settings by freezing panes, applying or removing auto-filters, and toggling gridlines visibility.
Instructions
Toggle view-related settings such as freeze panes, auto-filter and gridlines.
Args: action: "freeze", "auto_filter", or "set_gridlines". file_path: Workbook path. sheet_name: Worksheet name. cell_ref: For freeze, the pane freeze cell (omit to unfreeze). cell_range: For auto_filter set/remove. remove: For auto_filter, remove filter when True. show: For set_gridlines, show/hide gridlines.
Returns: str: Result message.
Notes: - Usually non-destructive aside from toggling UI settings stored in workbook.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| show | No | ||
| action | Yes | ||
| remove | No | ||
| cell_ref | No | ||
| file_path | Yes | ||
| cell_range | No | ||
| sheet_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |