Actions17
Sheet → Clear
AI-generatedSummary
Clear contents, formatting, or both in a specified worksheet or range within a Microsoft Excel workbook.
Inputs
- Workbook (required) — Select the Excel workbook to modify, either from a list or by specifying its ID.
- Sheet (required) — Select the worksheet (sheet) in the workbook to clear, either from a list or by specifying its ID.
- Apply To (required) — Choose what to clear: all (contents and formatting), only formats, or only contents of the cells.
- Select a Range — Toggle to specify a range within the sheet to clear instead of the entire worksheet.
- Range — The A1-style notation of the range to clear (e.g., A1:B2). If left blank while 'Select a Range' is enabled, the entire worksheet will be cleared.
Output shape
a single record indicating success status
Returns a JSON object with { success: true } upon successful clearing action. No other output data is returned.