ClearOptions

23 Sep 20251 minute to read

Specifies the options to clear contents, formats, and hyperlinks in the spreadsheet.

Properties

range string

Specifies the range of cells to be cleared in the spreadsheet.

type ClearType

Specifies the type of clearing action to be performed.
The type property can take one of the following values:

• Clear Contents - Clears only the data or content within the cells.
• Clear Formats - Clears only the formatting (e.g., font styles, colors, borders) applied to the cells.
• Clear Hyperlinks - Removes only the hyperlinks in the cells while retaining their content and formatting.
• Clear All - Clears all content, formatting, and hyperlinks from the specified range.