Clear Range
clear_rangeClears cell contents from a specified range in an open Excel workbook, optionally resetting fonts, fills, and number formats to remove both values and formatting.
Instructions
Clear cell contents from a range, optionally including formatting.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:C10". clear_formatting: Also reset fonts, fills, and number formats (Range.Clear instead of Range.ClearContents).
Returns: JSON confirmation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| workbook | No | ||
| range_address | No | A1 | |
| clear_formatting | No |