如何用C#在Excel中删除自定义列表

using Excel = Microsoft.Office.Interop.Excel;

...

Excel.Application excelApp = new Excel.Application();

Excel.Workbook workbook = excelApp.Workbooks.Open("path_to_excel_file");
Excel.Worksheet worksheet = workbook.Worksheets["sheet_name"];

Excel.Names names = worksheet.Names;

foreach (Excel.Name name in names)
{
    if (name.NameLocal.StartsWith("_xlfn."))
    {
        name.Delete();
    }
}

workbook.Close();
excelApp.Quit();

System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);

worksheet = null;
workbook = null;
excelApp = null;

GC.Collect();