worksheet_structure
Insert, delete, group, or resize rows and columns in Excel worksheets to restructure their layout and improve data organization.
Instructions
Perform row/column insert/delete, grouping, and size adjustments.
Args: action: One of insert/delete/group/ungroup/set_row_height/set_col_width. file_path: Workbook path. sheet_name: Worksheet name. row, col, count, start_row, end_row, start_col, end_col: Position arguments. outline_level, hidden, rows, cols_list, height, width: Operation-specific params.
Returns: str: Result message.
Notes: - Many actions are destructive (delete_rows/delete_cols) — document irreversible effects.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| col | No | ||
| row | No | ||
| rows | No | ||
| count | No | ||
| width | No | ||
| action | Yes | ||
| height | No | ||
| hidden | No | ||
| end_col | No | ||
| end_row | No | ||
| cols_list | No | ||
| file_path | Yes | ||
| start_col | No | ||
| start_row | No | ||
| sheet_name | Yes | ||
| outline_level | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |