We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Finding unique values in columns

Aspose Cells - c#

Hi,

How can I get a list<>, new worksheet or something similar that contains only unique values for all columns?

e.g source file
A B C
Rabbit Snake Lion
Rabbit Tortoise Tiger
Hamster Dog Cat
Rabbit Snake Chicken

Result (list, array, worksheet…anything!):
Rabbit Snake Lion
Hamster Tortoise Tiger
NULL Dog Cat
NULL NULL Chicken

Hi,


Well, MS Excel 2007/2010 has “Remove Duplicate” feature/option under “Data” menu that you may use. Aspose.Cells does support this feature too.

Please try the Cells.RemoveDuplicates method for your needs.

e.g
//…
worksheet.Cells.RemoveDuplicates(0, 0, 10, 0); //Remove the duplicate values in the A1:A11 cell area/range.

Thank you.