Remove Duplicates Workbook (preview)

Remove Duplicates Workbook activity that removes duplicate rows from a range, comparing all columns or only specific columns.

UiPath.Excel.Activities.RemoveDuplicates

説明

Removes duplicate rows from a range, comparing all columns or only specific columns. This is the cross-platform equivalent of the Remove Duplicates Windows activity.

注:

This activity does not support .xls files.

プロジェクトの対応 OS

Windows | クロスプラットフォーム

プロパティ

共通

• 表示名 - デザイナー パネルに表示されるアクティビティの名前です。

入力

• ファイル - リソースのブックのフル パスです。ローカル パスに切り替えるには、プラス記号のアイコンを選択し、[ローカル ファイルを使用] を選択します。現在のフィールドが [ファイル (ローカル パス)] に変更され、ブックのフル パスを指定できます。
• シート名 - ブックのシートの名前です。
• Range - The range to remove duplicate rows from. If you don't specify a range, the whole used range of the sheet is used.
• Compare - Select which columns to compare when looking for duplicate rows. This field is required. The default value is Compare all columns. You can choose from the following options:
  • Compare all columns - Compares every column of the range. Columns To Compare is ignored.
  • Compare individual columns - Compares only the columns listed in Columns To Compare.
• Columns To Compare - The columns to compare. You can use a list, an array, or any sequence of values. When Has Headers is selected, enter header names, which must match a header exactly. A value is never read as a column letter in that case. When Has Headers is not selected, enter column letters inside the range. This field is required when Compare is Compare individual columns, and the list must contain at least one column.

オプション

• Has Headers - Select this option to treat the first row of the range as a header row and exclude it from the duplicate search. By default, this option is selected.
• パスワード - ブックのパスワードです (必要な場合)。

出力

• Removed Rows Count - The number of duplicate rows that the activity removed, stored as an Int32 variable.

ブックを使用する

• Workbook - The existing workbook to use instead of a file path.

備考

• The activity keeps the first occurrence of each unique row and removes the later duplicates. The rows below shift up.
• If the range covers the whole used range, the hidden or visible state of each row moves with the shift. If the range is narrower than the sheet, the row visibility is left unchanged, as in Excel, because it is a property of the entire row.
• A header name that doesn't match a header, or a column letter outside the range, causes an error.
• A whole-column or whole-row range, such as A:A, is limited to the used range of the sheet.
• Range must refer to the sheet in SheetName. A range that includes a sheet name, such as Sheet2!A1:A10, is not supported and causes an error.