Clear range
clear_rangeClear values, formatting, or both from a specified Excel range without shifting other cells.
Instructions
Clear the values and/or formatting of a range without shifting other cells.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. | |
| clear | No | Clear values, formatting, or both. | contents |
| range | Yes | A cell or rectangular range in A1 notation, e.g. 'A1:D20'. | |
| sheet | Yes | Worksheet name, e.g. 'Sheet1'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |