UiPath.Excel.Activities.ExcelRemoveDuplicatesRange

Deletes all the rows that are duplicates in a specified range.

Properties

Common

• DisplayName - The display name of the activity.

Input

• Range - The range from which you want to remove duplicate rows. This field supports only strings and String variables.
• SheetName - The name of the sheet in the workbook where the change must be made. This field supports only strings and String variables.

Misc

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

Example of Using the Remove Duplicates Range Activity

To exemplify how to use this activity, we have built an automation project which removes duplicate rows in an Excel range.
 
 
Download example