Microsoft Excel 365 icon

Microsoft Excel 365

Consume Microsoft Excel API

Sheet → Clear

AI-generated

Summary

Clear cell contents, formatting, or both from a Microsoft Excel worksheet, either across the whole sheet or within an optional A1-style range.

Inputs

  • Workbook (required) — Select a workbook from the list or enter its ID.
  • Sheet (required) — Select a worksheet from the list or enter its ID.
  • Apply To — Choose All (clear cell data and formatting), Formats (clear formatting), or Contents (clear cell data). Defaults to All.
  • Select a Range — Enable this to limit the operation to a range.
  • Range — A1-style range to clear, such as A1:B2. Leave blank to target the entire worksheet.

Output shape

A list of items

The supplied source pack shows the operation implementation but not its response handling in detail; the output data shape is not clear from the available source.

Links

Discussion