Skip to main content

Filter

Filters given Excel file.

Input​

  • Filter Range: Range to apply filter
    • Type: System.String
    • Required
  • Column Name: The header of the column to filter
    • Type: System.String
    • Required
  • Clear Existing Filters: Clear any existing filters already applied to the target range.
    • Type: System.Boolean
    • Required

Details​

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.
  • To add a filter option, click the "Configure Filter" button.