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

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Column nameThe 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 indexIndex of the column to which the filter criterion will be applied.Robin.Numeric
No
RowIndex of the row on which filters are installed to cut off the table heading.Robin.Numeric
No
Criteria 1Filtering 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 2Filtering 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 appliedOptional 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

  1. Assemble a robot scheme consisting of actions:
  2. 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. 
  3. Set the parameters of the "Apply auto-filter" action: 


  4. Set the parameters of the "Save" action:
  5. Click "Start" in the top panel to start the robot.

Result

The program robot completed successfully.

Auto-filter selection is set up.