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.