筛选条件透视表

UiPath.Excel.Activities.Business.FilterPivotTableX

描述

根据单个列中的值，在透视表中创建筛选条件。也可用于清除现有的筛选条件。该活动可以与为父级使用 Excel 文件活动选择的 Excel 文件一起使用，也可以与“项目笔记本”一起使用。

配置活动

设计器面板

• Source - Select Plus on the right side of the field, select the file, and then select a pivot table to filter, or select Indicate in Excel to open the file and select a pivot table directly from the file. To enter a pivot table manually, select Custom Input. Alternatively, you can select Open in Advanced Editor and enter a VB expression.
• Column name - The column to filter on. You can select a filter, column label, or row label. Select Plus on the right side of the field, select Range, and then select the header of the column. Alternatively, you can select Text to enter the value in the column header in the Text Builder, or select Open in Advanced Editor and enter a VB expression.
• Configure Filter - Select this button to configure the filter for the values in the column. You can enter one or more values to filter on,
• Clear any existing filter - Select this option if you want to clear existing filters instead of creating a new one. Clearing filters does not remove filter configurations from inside the activity, if any were defined.

属性面板

常见

• DisplayName - The name displayed for the activity in the Designer panel.

输入

• 请在活动正文中查看选项。

其他

• 私有 - 选中后将不再以“Verbose”级别记录变量和参数的值。

选项

• 清除任何现有过滤条件 - 请在活动主体中查看清除任何现有过滤条件。