Remove duplicate rows in a Worksheet

Contents
[ ]

Remove duplicate rows is one of Microsoft Excel’s many useful features. It allows users to remove duplicate rows in a Worksheet, you can pick which columns should be checked for duplicate information.

Aspose.Cells for Python via .NET provides the Cells.remove_duplicates() method for this purpose. You can also set startRow, startColumn, endRow, endColumn to pick up columns.

Following are the sample files which can be downloaded for testing this feature:

removeduplicates.xlsx

Delete Blank Rows and Columns in a Worksheet Update references in other worksheets while deleting blank columns and rows in a worksheet