WSheet Filter Add

The Worksheet Filter Add process step allows you to filter the specified column of the specified worksheet. It works like the Excel data filter. You can filter by up to two criteria by adding them to the criteria fields and choosing the logical operator (And / Or). If you want to filter by only one value/expression, you should leave the optional “Filter operator” parameter empty.

In order to filter by more than two values on the same column (with And logic) just add an additional WSheet Filter Add step to the process and enter the required parameters.

You can add auto filters to a worksheet with the following parameters:

  • On worksheet the Djeeni name of a worksheet in use.
  • Header row: the number of header rows to be excluded from filtering
  • Column letter: to which the filter is applied
  • Criteria 1: The first criteria following the MS Excel filtering syntax
  • Operator (optional): If two criteria are given then the operator between them – And / Or
  • Criteria 2 (optional): The second criteria following the MS Excel filtering syntax