Action group: Excel
Action icon
Version
- 1 (net)
- 2 (net)
- 3 (net)
- 4 (net)
- 5 (net)
- 6 (net)
- 7 (net)
- 8 (net)
Action returns all values of a given column or range of a given page
Settings
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
| Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
| Column | Name of the column to which the action will be applied | String | Yes | |
| Range start row number | The number of the row in which the start cell of the range is located. If the field is not filled in, the first row of the used area is taken | Numeric | No | |
| Range end row number | The number of the row in which the end cell of the range is located. If the field is not filled in, the end row of the used area is taken | Numeric | No | |
| Skip hidden cells | Return only visible cells | Boolean | true | No |
| Skip empty cells | Return only non-empty cells | Boolean | true | No |
| Results | ||||
| Result | Variable to which the values from the column will be written | Collection | ||
Обзор
Инструменты контента