delete_range
Remove a specific range of cells in an Excel sheet and shift remaining cells to fill the gap, supporting up or down direction. Integrates with xlwings Excel MCP Server for secure file manipulation in corporate environments.
Instructions
Delete a range of cells and shift remaining cells.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_cell | Yes | ||
| filepath | Yes | ||
| sheet_name | Yes | ||
| shift_direction | No | up | |
| start_cell | Yes |
Input Schema (JSON Schema)
{
"properties": {
"end_cell": {
"title": "End Cell",
"type": "string"
},
"filepath": {
"title": "Filepath",
"type": "string"
},
"sheet_name": {
"title": "Sheet Name",
"type": "string"
},
"shift_direction": {
"default": "up",
"title": "Shift Direction",
"type": "string"
},
"start_cell": {
"title": "Start Cell",
"type": "string"
}
},
"required": [
"filepath",
"sheet_name",
"start_cell",
"end_cell"
],
"title": "delete_rangeArguments",
"type": "object"
}