clear_range
Clear cell values and/or formatting in an Excel .xlsx range without deleting rows or columns.
Instructions
Clear cell values and/or styles within a specified range without deleting rows or columns.
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range (e.g. "A1:D10") to clear. clear_values: Whether to clear cell values (True by default). clear_styles: Whether to clear cell styles/formats (False by default).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| sheet | Yes | ||
| backup | No | ||
| cell_range | Yes | ||
| clear_styles | No | ||
| clear_values | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||