WSheet Filter Add []

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

• On worksheet: the Djeeni name of a worksheet in use.
• Column letter: to which the filter is applied
• Criteria 1: The first criteria given following the MS Excel filtering syntax
• (Optional) operator: If two criteria is given then the operator between them – And / Or
• (Optional) criteria 2: The second criteria given following the MS Excel syntax

By using this step multiple times you can combine filters.

Example: From the worksheet ‘Costs’ we want to use only records that belong to a cost center. Cost centers are identified in column D of the worksheet.

WSheet Filter Add

  Djeeni name :=Costs
  Worksheet:=Costs
  Column:=D
  Criteria1:=CC-12AT