Using Get number of rows action

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

To get the number of rows that are not empty or contain data, do the following:

1. Double-click or drag the Get number of rows action from the Excel node in the Actions palette.
2. Select the Index option to specify the number of the worksheet or the Name option to specify the name of the worksheet from which you want to get the number or rows.
3. Select the Non-empty rows option to get the number of rows that are not empty or the Total rows with data option to get the number of rows that contain data.
4. Introduzca el nombre de la sesión utilizada para abrir el libro de trabajo con el botón Abriraction.
5. Select the number variable you want to use to store the output from the Assign to variable list.
6. Haga clic en Guardar.