How to Remove the duplicate rows in excel using uipath

To remove the duplicated rows in excel we can use the Remove Duplicates Range Activity in UIpath.

Install the excel package from Manage Packages to use excel activities.

Use excel application scope to drop excel related activities

To Use Excel Activities We Must Use Excel Application Scope, Otherwise, It Throws An Error.

Give the excel file path with input data in the excel scope.

provide the file path location in enclosed double quotes

removing the duplicates

Now we want to remove duplicate rows from the data available in the excel file. For this, we use an activity called REMOVE DUPLICATES RANGE Activity.

Drag and drop the remove duplicates range activity from the Activities panel.and Give the sheet in name and range.Now save and run the sequence.

Input and output data you can see in the below image.