Extend Range.RemoveDuplicates


Add ability to remove duplicates by specifying the id column same as it is done in excel by adding additional parameter - columns(or columns) as a list of names
public void RemoveDuplicates(
int startRow,
int startColumn,
int endRow,
int endColumn,
string [] KeyColumnNames


Aspose.Cells already contains this feature as mentioned here.
Regarding the additional parameter, please note that Aspose.Cells mimics the behavior of Excel. You may please try to set this additional parameter in Excel and share the steps with us to perform the same task here using Excel. We will analyze it and provide assistance to achieve the same functionality using Aspose.Cells.


this is what excel has and would be nice to have the same for aspose


We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46945 - Extend Range.RemoveDuplicates method



Please try our latest version/fix (.NET and Java): Aspose.Cells v19.9.3 (attached)
(Please choose/download the appropriate fix for your underlying platform/language)

Your issue should be fixed in it. Please try the overloaded method Cells.RemoveDuplicates(int startRow, int startColumn, int endRow, int endColumn,bool hasHeaders, int[] columnOffsets).

Let us know your feedback.
Aspose.Cells19.9.3 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.9.3 For .Net4.0.Zip (4.9 MB)
Aspose.Cells19.9.3 For .NetStandard20.Zip (4.1 MB)

Aspose_Cells_Java_v19.9.3.zip (6.6 MB)


Thx it seems to fit our needs - when do you expect it to be available from nuget?



Good to know that your issue is sorted out by the new fix/version. We are scheduled to release (on Downloads and Nuget repos.) our next official release of the product, i.e., Aspose.Cells for .NET v19.10 before the end of this week or in the next week.