Using Get number of rows action

Use the Get number of rows action to get the number of rows that contain data.

Procedure

  1. Double-click or drag the Get number of rows action from the Excel advanced package in the Actions palette.
  2. Use the Select worksheet by field to select one of the following options:
    • Index: to specify the number of the worksheet from which you want to get the number of rows.

      Ensure that the number is not 0 as the worksheet numbers start from 1.

    • Name: to specify the name of the worksheet from which you want to get the number or rows.
  3. Select one of the following options:
    • Non-empty rows: returns the total number of non-empty rows only.
    • Total rows with data: returns the total number of rows including empty cells.

      Consider the following illustration of an Excel file for monthly sales target achieved:

      Get rows illustration
      • Non-empty rows: returns the value 5.

        The rows 1, 2, 3, 5 and 7 are not empty.

      • Total rows with data: returns the value 7.

        This includes empty and rows with data in the table.

  4. Use the Session name field to select one of the following tabs:
    • Session name: Enter the name of the session used to open the workbook with the Open action.
    • Variable: Enter the Excel advanced session variable that you have created.
  5. Click the Assign to variable drop-down menu to select a variable that you want to assign the output value to.
    Click the Create variable icon if you have not created a variable.
  6. Click Save.