Using Get number of rows action
- 版本:
- 已更新: 2023/05/24
Using Get number of rows action
Use the Get number of rows action to get the number of rows that contain data.
Procedure
- Double-click or drag the Get number of rows action from the Excel advanced package in the Actions palette.
-
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.
- Index: to specify the
number of the worksheet from which you want to get the number of rows.
-
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:
- 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.
- Non-empty rows:
returns the value 5.
-
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.
-
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.
- Click Save.