Get number of columns action in Apple Numbers package

The Get number of columns action of the Apple Numbers package enables you to capture the number of columns containing data in the table and stores the count in a variable.

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.
  • Specify the sheet name to capture the column count. For example, Sheet1.
  • Specify the table to capture the column count. For example, Table1.
  • Choose from the following options to get the column count type:
    • Non empty columns: Selecting this option retrieves the total number of columns with data.
    • Total columns:Selecting this option retrieves the total number of columns, including those with empty cells.
  • Select the number variable from the Store column count field to store the captured column counts.