Get cell data action in Apple Numbers package

The Get cell data action of the Apple Numbers package enables you to retrieve data from a cell, such as its color, value, column name , formula, position, or row number, based on the selected data type.

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.
  • Select whether to retrieve the cell data from the Active or a Specific cell position.
    • Active: Retrieves the cell data of the currently active cell.
    • Specific: Retrieves the cell data of the cell specified by the table name and cell address. Complete the following fields:
      • Table name: Specify the table name for the provided sheet. For example, Table1.
      • Cell address: Specify a cell address to retrieve the value For example, A10 or B6
  • Select any one of the following options to capture data:
    • Color: Select the Background color option to get the background color of the cell or the Text color option to get the color of the text.
    • Column name: Retrieves the column name that contains the specified cell.
    • Formula: Retrieves the formula from the active cell or specified cell.
    • Row number: Retrieves the row number that contains the specified cell.
    • Value type: Select either the Visible text or Cell value to read the displayed content or the raw value. For example, if the cell has 70% as cell content, Cell value option will read the value as 70 ignoring the % format whereas Visible text option will read the content as 70%.
  • Select a variable to store the captured data in the Store cell data field.