Clear cells action in Apple Numbers package

The Clear cells action in the Apple Numbers package enables you to remove all data and formatting from the active or specified cell or range in the active sheet.

Settings

  • Use one of the following options to provide session name:
    • Session name: Enter the name of the session used to open the spreadsheet with the Open action.
    • Variable: Enter the session variable that you added in the Open action.
  • Choose whether to work on the Active cell (currently selected) or a Specific cell position:
    • Active: Clears the data from the currently selected active cell.
    • Specific: Provide the following details:
      • Table name: Enter the table name within the sheet (for example, SalesData).
      • Cell address: Specify the cell address or range to clear its content and formatting (for example, A5 or A5:B10).

When you specify the attributes mentioned above, the active cell or the cell range identified by the table name and cell address will have its contents cleared (deleted) during the bot execution. The cell address must contain a cell address or a range of cells that exist in the specified table or table with the active cell, otherwise, an exception will be thrown.