C#合并Excel单元格

合并竖着的单元格

Range rangeLecture = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[2,  1]);
                    rangeLecture.Application.DisplayAlerts = false;
                    rangeLecture.Merge(Missing.Value);
                    rangeLecture.Application.DisplayAlerts = true;

合并横着的单元格

Range rangeProgram = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 2]);//获取需要合并的单元格的范围
                            rangeProgram.Application.DisplayAlerts = false;
                            rangeProgram.Merge(Missing.Value);
                            rangeProgram.Application.DisplayAlerts = true;

              

名称可参照以下代码

                Excel.Application excel = new Excel.Application(); //引用Excel对象  
                Excel.Workbook book = excel.Application.Workbooks.Add();//新建Excel工作簿 
                Excel.Worksheet objsheet = null;
                objsheet = (Excel.Worksheet)book.ActiveSheet;
                excel.Visible = true; //使Excel可视
          
                    //合并首行标题单元格
                    Excel.Range r;
                    r = objsheet.get_Range(objsheet.Cells[1, 1], objsheet.Cells[1, 5]);     //取得合并的区域  
                    r.MergeCells = true;