insert_or_delete_range
Insert or delete a worksheet cell range, shifting existing cells down or right for inserts and up or left for deletes.
Instructions
Insert or delete a range, shifting existing cells. For insert, shift is Down or Right; for delete, Up or Left.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"range": "<range>",
"action": "<action>"
},
"name": "insert_or_delete_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range address to insert at or delete. | |
| shift | No | Shift direction. Defaults: insert=Down, delete=Up. | |
| action | Yes | Whether to insert or delete. | |
| sheetName | No | Worksheet name. Defaults to the active worksheet. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. |