Merge or Unmerge Range of Cells

Contents
[ ]

Example

The following sample code first creates a range - A1:D4 - then merges the cells in the range into a single cell using the Range.Merge() method. Similarly, you can split cells by creating a range and calling the Range.UnMerge() method.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create a workbook
Workbook workbook = new Workbook();
// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Create a range
Range range = worksheet.Cells.CreateRange("A1:D4");
// Merge range into a single cell
range.Merge();
// Save the workbook
workbook.Save(dataDir+ "output.out.xlsx");