clear_range
Clear cell values in a spreadsheet range while preserving row and column structure. Use this tool to remove data from specific cells without deleting rows or columns.
Instructions
Clear all cell values in a range without removing rows or columns.
Sets every cell in the range to null. Row/column structure is preserved.
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": {
"file": "<file>",
"range_str": "<range_str>"
},
"name": "clear_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| range_str | Yes | Range to clear in A1 notation, e.g. 'A1:D10'. Only values are removed. | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |