delete_range
Delete a specified range of cells in an Excel worksheet and shift remaining cells up or left to fill the gap.
Instructions
Delete a range of cells and shift remaining cells.
Args:
sheet_name: Name of worksheet
start_cell: Starting cell
end_cell: Ending cell
session_id: Session ID from open_workbook (preferred)
filepath: Path to Excel file (legacy, deprecated)
shift_direction: Direction to shift cells ("up" or "left")
Note: Use session_id for better performance. filepath parameter is deprecated.
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": {
"sheet_name": "<sheet_name>",
"start_cell": "<start_cell>",
"end_cell": "<end_cell>"
},
"name": "delete_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_name | Yes | ||
| start_cell | Yes | ||
| end_cell | Yes | ||
| session_id | No | ||
| filepath | No | ||
| shift_direction | No | up |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |