C# Merge Cells SpreadsheetGear API Sample

Excel-Compatible Samples for .NET

Description

Merges multiple cells.

Sample C# Source Code

IWorkbook workbook = Factory.GetWorkbook();
IWorksheet worksheet = workbook.ActiveWorksheet;
IRange cells = worksheet.Cells;
cells["B4:E7"].Merge();
cells["B4"].Value = "Merge()";
cells["B4"].Font.Size = 36;
cells["B4"].HorizontalAlignment = HAlign.Center;
cells["B4"].VerticalAlignment = VAlign.Center;
cells.Borders.Weight = BorderWeight.Thin;
cells.Borders.Color = SpreadsheetGear.Colors.DarkSlateBlue;