Excel 合并单元格 C#

最新推荐文章于 2024-08-08 17:58:07 发布

weixin_30613727

最新推荐文章于 2024-08-08 17:58:07 发布

阅读量108

点赞数

原文链接：http://www.cnblogs.com/fuge/p/3666591.html

版权

合并竖着的单元格

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;

转载于:https://www.cnblogs.com/fuge/p/3666591.html