Read row or column action in Apple Numbers package

The Read row or column action in Apple Numbers package enables you to extract the data from the row and column and store it in a list variable of string 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.
  • In the Cell position tab, select Row or Column depending on where you want to extract the data from.
  • To extract data from a specific row or column, select From active or From specific to specify the starting point.
    • From active: Reads the data starting from the active cell till the end of that specific row or column.
    • From specific: Reads from a specific cell. Enter the Table name and the Cell address of a specific cell to read.
  • To extract data from a full row or column, select Full row or Full column respectively.
  • Choose from the Read option to read either the visible text or value of the cell.

    For example, if the cell has 70% as cell content, Read cell value option will read the value as 70 ignoring the % format whereas Read visible text option will read the content as 70%.

  • In the Store row or column data field, select a list variable of string data type that you want to use to store the extracted values.