I am facing difficulty in removing duplicate. I am having 30 columns in the excel sheet and if there is a duplicate in a specific column even if other columns are not matching rows should be deleted.
I have used Dt2.DefaultView.ToTable(True,“Column1”) which works to remove duplicates for Column1 as per my requirement but writes back only Column1, other 29 columns are not written back into the sheet
I have used Dt2.DefaultView.ToTable(True,“Column1”,“Column2”,“Column3” …“Column30”) which is removing duplicates for Column1 if the data across all columns are matching and writes back all 30 columns. This is not matching my requirement.