Unitalk Microsoft Excel 365 icon

Unitalk Microsoft Excel 365

Consume Microsoft Excel API

Sheet → Clear

AI-generated

Summary

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.

Links

Discussion