A group of actions: Excel
The action returns the number of rows. Lines are counted within the used context range. If you enter a column outside this range, the action will return an empty result.
Action icon
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 | ||
Обзор
Инструменты контента