Deactivate auto-filters Version 8 (Net)

Action group: Excel 

Description

Removes active filters within the current sheet

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes

Special conditions of use

None.

Example of use

Task

There is an Excel document in which auto-filters are configured.

It is required to remove them. 

Solution

Use "Open", "Deactivate auto-filters", "Save" actions.

Implementation

  1. Assemble a robot scheme consisting of actions:

  2. Set the parameters of the "Open" action:
  3. Set the parameters of the "Deactivate auto-filters" 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-filters have been removed.