static void Main()
{
Excel.Workbook workbook = _app.Workbooks.Open(@"C:\test\Dupes.xlsx");
Excel.Worksheet worksheet = workbook.Sheets[1];
Excel.Range range = worksheet.UsedRange;
range.AdvancedFilter(Excel.XlFilterAction.xlFilterInPlace, null, null, true);
workbook.Close(true);
Marshal.ReleaseComObject(_app);
}