Get number of rows action in Apple Numbers package

The Get number of rows action of the Apple Numbers package enables you to capture the number of rows containing data in the sheet 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 row count. For example, Sheet1.
  • Specify the table to capture the row count. For example, Table1.
  • Choose from the following options to get the row count type:
    • Non empty rows: Select this option to get the number of rows with data in the specified table.
    • Total rows:Select this option to get the data from the last row in the specified table.
    For example, you are working on an employee table that has the following data:
    Table 1. Employee data
    Employee ID Name Employment type
    001 Peter Contractor
    002 John Permanent

    Using the Non empty rows option will retrieve all the data from Row 2 (001, Peter, and Contractor) and Row 4 (002, John, and Permanent). Similarly, if you use Total rows option, it will retrieve data from Row 4 (002, John, and Permanent), as Row 4 is the last row with data in the table.

  • Select the number variable from the Store row count field to store the captured row counts.