UiPath Activities Guide

Filter Table

UiPath.Excel.Activities.ExcelFilterTable

Filters a table from a spreadsheet based on existing values from a column. Can only be used in the Excel Application Scope activity.

Properties

Note:

Strings must be placed between quotation marks.

Input

  • TableName - The name of the table that you want to filter. Only String variables and strings are supported.

  • ColumnName - The name of the column that you want to filter. Only String variables and strings are supported.

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

  • SheetName - The name of the sheet in which the column you want to filter is. By default, this is filled in with "Sheet1." Only String variables and strings are supported.

Common

  • DisplayName - The display name of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of using the Filter Table activity

You can see how the Filter Table activity is used in an example that incorporates multiple activities.
To exemplify how to use this activity, we have built an automation project which also includes a Filter Table activity.

You can check and download the example from here


Filter Table


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.