WSheet Filter Add []

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

• On worksheet Djeeni name: the Djeeni name of a worksheet in use.
• Column letter (e.g. A): to which the filter is applied
• Criteria 1: The first criteria given following the MS Excel filtering syntax
• Filter operator (optional): If two criteria is given then the operator between them – And / Or
• Criteria 2 (optional) : 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