A group of actions: Excel
The action displays cells that match the filtering criteria. Filters are not removed if the action is reapplied, but are superimposed on each other. If there is a need to remove filtering by a criterion, use the «remove auto filter» action.
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 | The name of the column to which the filter criterion will be applied | Robin.String | Yes | |
| Row | Index of the row on which filters are installed to cut off the table heading. | Robin.Numeric | No | |
| Criteria 1 | Filtering criterion for the first condition. Filled in the format «={value}», «<{value}», «>{value}», «>={value}», «<={value}» or «<>{value}». If the field value is not filled in, then filtering will be set by the value «(empty)». | Robin.String | No | |
| Criteria 2 | Filtering criterion for the second condition. Filled in the format «={value}», «<{value}», «>{value}», «>={value}», «<={value}» or «<>{value}». Required if the value of parameter «How the criteria are applied» is not «Ignore 2nd criterion». | Robin.String | No | |
| How the criteria are applied | Optional parameter - specifies the method of applying filtering criteria, takes 3 values: «Ignore 2nd criterion», «OR», «AND». | Robin.String | No | |
Обзор
Инструменты контента