How will remove the duplicating entries in excel through c# coding?

Question

Suppose I insert and update the data in excel through c# coding but how will I stop the duplicating entries store in database (excel sheet). plz help. Thanx in advance.

hitesh oberoi · Answer

But how will I check what is the code for that? Plz tell.

Mahesh Chand · Answer

This will be done in your code before you save them. You need to first get data and loop through each item and see if there are any duplicates and delete them from the object such as a DataTable. Then you write to Excel.