Removing duplicate values in excel using visual c#

Ali Alfaraj

Good day dear members,

I'm trying to remove duplicate values in an excel sheet through visual c#. I found the following function:

xlWorkSheet.Columns.RemoveDuplicates(object columns, XlYesNoGuess Header) //xlWorkSheet is the excel sheet

But I'm not sure how to use! specifically for the first argument.

How can I pass excel columns to this function?

Hope you can help,

Ali

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

John Spencer7y ago
Thank you, Hemant. This quite simple approach worked very well. I had not worked with 'Dictionary' before. A very simple solution to what I was looking for. Again, Thanks!!! After all these years!!

Hemant Kumar15y ago

Hi you can get the Duplicates from the Excel like this

var myDictionary = new Dictionary<string,int>();
string col="C";
for(int row = 1; row<numberOfRows; ++row)
{
     string elemValue = myWorkSheet.Range(col + row).Text;
     if(myDictionary.ContainsKey(elemValue))
     {
          Console.WriteLine(col + myDictionary[elemValue] + " = " "+ col + row);
     }
     else
     {
          myDictionary[elemValue]=row;
     }
}