Remove duplicate rows in a Worksheet

Contents
[ ]

Removing 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 provides the Cells.RemoveDuplicates() method for this purpose. You can also set startRow, startColumn, endRow, and endColumn to select 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