.Net Excel Interop删除工作表

using System;
using System.IO;
using Microsoft.Office.Interop.Excel;

namespace DeleteExcelWorksheet
{
    class Program
    {
        static void Main(string[] args)
        {
            // 打开 Excel 文件
            Application app = new Application();
            Workbook workbook = app.Workbooks.Open(Path.Combine(Directory.GetCurrentDirectory(), "example.xlsx"));

            // 获取工作表
            Worksheet worksheet = workbook.Worksheets["Sheet1"];

            // 删除工作表
            worksheet.Delete();

            // 保存文件并关闭
            workbook.Save();
            workbook.Close();

            // 退出 Excel 应用程序
            app.Quit();
        }
    }
}