Apply auto-filter Version 9 (Net)

Action group: Excel

Description

The action displays cells that meet the filtering criteria. Filters are not removed if you apply the action repeatedly, but overlap. If you want to remove filtering by criterion, you must use the "Deactivate auto-filters" action.

Action icon

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	The name of the column to which the filter criterion will be applied. 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 to which the filter criterion will be applied.	Robin.Numeric		No
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

Special conditions of use

Filters are not removed if you apply the action repeatedly, but are overlaid on each other.

If you want to remove filtering by criterion, you must use the "Deactivate auto-filters" action.

Example of use

Task

There is an Excel document with these values. It is required to set up auto-filter: row No. 3, values >5.

Solution

Use "Open", "Apply auto-filter ", "Save" actions.

Implementation

Assemble a robot scheme consisting of actions:
Set the parameters of the "Open" action:
Specify the path to the Excel file in the "File Path" field.
Specify checkbox=true in the "Open Visible" field.
Set the parameters of the "Apply auto-filter" action:
Set the parameters of the "Save" action:
Click "Start" in the top panel to start the robot.