Free Support Forum -

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)

[Java] (6.6 MB)

1 Like

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.

The issues you have found earlier (filed as CELLSNET-46945) have been fixed in Aspose.Cells for .NET v19.10 (Dlls). This message was posted using Bugs notification tool by Amjad_Sahi