Removing duplicate values in excel using visual c#

Question

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

Hemant Kumar · Answer

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 ; } }