Get row number Version 12 (Net)
Action group: Excel
Description
The action returns the number of rows. Rows within the context range used are counted. If you enter a column outside this range, the action will return an empty result.
Action icon
Parameters
Input parameters
Context - Action context for working with Excel documents.
Column name - Name of the column for which the number of rows is to be obtained. If the field is not filled in, the value from the "Column index" field is taken.
Column index - Index of the column for which you want to get the number of rows.
Skip hidden - A boolean variable. If True, only visible cells are returned, otherwise all cells are returned.
Skip empty - A boolean variable. If True, only filled cells are returned.
Output parameters
The result is the number of the number of rows.
Settings
| Property | Description | Type | Filling example | Mandatory field |
|---|---|---|---|---|
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Column name | Name of the column for which you want to get the number of rows. If the field is not filled, then the value from the «Column index» field is taken. | Robin.String | No | |
| Column index | Index of the column for which you want to get the number of rows. | Robin.Numeric | No | |
| Skip hidden | Read only visible rows | Robin.Boolean | true | No |
| Skip empty | Read only filled rows | Robin.Boolean | true | No |
| Results | ||||
| Result | The variable in which the number of lines will be written | Robin.Numeric | ||
Special conditions of use
Rows within the used context range are counted.
If you enter a column outside this range, the action will produce an empty result.
Example of use
Task
There is an Excel document. You need to get the number of rows within the used context range of column A.
Solution
You need to use the following actions - "Open", "Get Row number".
Implementation
- Assemble a robot scheme consisting of actions:
- Set the parameters for the "Open" action.
- Set the parameters for the "Get row number" action.
- Click on the "Start" button in the top panel.
Result
A result is obtained with data from the specified column.
Обзор
Инструменты контента