using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Excel = Microsoft.Office.Interop.Excel;
namespace ConsoleApp9
{
    internal class Program
    {
        static void Main(string[] args)
        {
            // 创建 Excel 应用程序实例
            Excel.Application excelApp = new Excel.Application();
            excelApp.Visible = true;

            try
            {
                // 打开包含宏的 Excel 文件
                Excel.Workbook workbook = excelApp.Workbooks.Open(@"C:\Users\Administrator\Documents\test.xlsm");

                try
                {
                    // 运行指定的宏
                    excelApp.Run("'test.xlsm'!test1","test");
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error running macro: " + ex.Message);
                }
                finally
                {
                    Console.ReadKey();
                    // 保存工作簿并关闭
                    workbook.Save();
                    workbook.Close();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error opening workbook: " + ex.Message);
            }
            finally
            {
                // 退出 Excel 应用程序
                excelApp.Quit();
                // 释放 COM 对象
                System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
            }
            Console.ReadKey();
        }
    }
}