Get Table Range action in Apple Numbers package

The Get Table Range action in the Apple Numbers package enables you to retrieve the range of cells from an active or specified table in a spreadsheet.

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 one of the following options to retrieve the range of cells from an active or specified table.
    • Active: Uses the currently active table.
    • Specific: Specify the table name from which you want to get the range.
  • Select the check box Includes header to specify whether header rows are part of the returned range.
  • In the Store cell range field, select a variable from the list to store the cell range.

When you specify the attributes mentioned above, during execution of the action, then for the specified table, the action will place the table range (a value which contains the first cell in the table, and the last cell in the table, separated by a colon (for example, A1:E5 for a 5x5 table) into the designated string variable. When Includes header is not selected, then headers will be excluded from the range. For example, in a 5x5 table with range A1:E5 with a single header row (Row 1), the range returned would be A2:E5.