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.
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 |