delete_range
Remove a specified range of cells in an Excel sheet and adjust neighboring cells by shifting them up or down to maintain data integrity and structure.
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"
}