使用C#在Excel中合并单元格

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

namespace MergeExcelCells
{
    class Program
    {
        static void Main(string[] args)
        {
            // 创建一个新的Excel工作簿
            Application app = new Application();
            Workbook workbook = app.Workbooks.Add();
            Worksheet worksheet = workbook.Worksheets[1];

            // 合并单元格
            Range range = worksheet.Range["A1", "B2"];
            range.Merge();

            // 将合并后的单元格设置为居中
            range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
            range.VerticalAlignment = XlVAlign.xlVAlignCenter;

            // 将合并后的单元格设置为值
            range.Value2 = "合并后的单元格";

            // 保存工作簿
            string filePath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "MergedCells.xlsx");
            workbook.SaveAs(filePath);

            // 关闭工作簿
            workbook.Close();

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