История страницы
...
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 of parameters
| 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 | ||
...
Обзор
Инструменты контента