Description

Filters a table from a spreadsheet based on existing values from a column.



Attributes

Input

  • ColumnName - The name of the column that would be filtered.

  • Filter - Enables you to filter a spreadsheet column by values from a specified String array variable. Only String array variables are supported.

  • TableName - The name of the table that would be filtered.

  • Worksheet - The name of the sheet to be selected.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

For this example, this is what the sample Spreadsheet contains:



  1. Add an Excel Sequence activity inside a Sequence.
  2. In the File Path field, search for and select your Spreadsheet document by, first, clicking the browse button.
  3. Add a Filter Table activity, and in the Worksheet field, type "Sheet1" (or the name of the sheet you would use).
  4. In the Table Name field, write "Info", and in the Column Name field, write "Age".
  5. In the Filter field under Properties, write {"23"}. This would only display the rows with the value of 23 in the Column Age


            The use case should look as the following screenshot.



            After execution, the Spreadsheet should now look like this: