How to Merge and Unmerge Cells

using IronXL;

// The main purpose of this code is to showcase how to use the IronXL library to merge cells in an Excel worksheet.

// Load the workbook from an Excel file
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the default worksheet of the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Define a range as the cells from B2 to B5
var range = workSheet["B2:B5"];

// Merge cells from B7 to E7 in the worksheet
workSheet.Merge("B7:E7");

// Merge the previously defined range (B2 to B5) using its address as a string
workSheet.Merge(range.RangeAddress);

// Save the workbook with merged cells as a new file
workBook.SaveAs("mergedCell.xlsx");

Imports IronXL



' The main purpose of this code is to showcase how to use the IronXL library to merge cells in an Excel worksheet.



' Load the workbook from an Excel file

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")



' Get the default worksheet of the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Define a range as the cells from B2 to B5

Private range = workSheet("B2:B5")



' Merge cells from B7 to E7 in the worksheet

workSheet.Merge("B7:E7")



' Merge the previously defined range (B2 to B5) using its address as a string

workSheet.Merge(range.RangeAddress)



' Save the workbook with merged cells as a new file

workBook.SaveAs("mergedCell.xlsx")

using IronXL;
using System.Collections.Generic;
using System;

// Create a new workbook and get the default worksheet.
WorkBook workBook = WorkBook.Create();
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Apply merging to specific cell ranges on the worksheet.
// Merges the cells in the range B4 to C4.
workSheet["B4:C4"].Merge();

// Merges the cells in the range A1 to A4.
workSheet["A1:A4"].Merge();

// Merges the cells in the range A6 to D9.
workSheet["A6:D9"].Merge();

// Retrieve all the merged regions from the worksheet.
List<IronXL.Range> retrieveMergedRegions = workSheet.GetMergedRegions();

// Loop over each merged region and print the range address to the console.
foreach (IronXL.Range mergedRegion in retrieveMergedRegions)
{
    Console.WriteLine(mergedRegion.RangeAddressAsString);
}

Imports IronXL

Imports System.Collections.Generic

Imports System



' Create a new workbook and get the default worksheet.

Private workBook As WorkBook = WorkBook.Create()

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Apply merging to specific cell ranges on the worksheet.

' Merges the cells in the range B4 to C4.

workSheet("B4:C4").Merge()



' Merges the cells in the range A1 to A4.

workSheet("A1:A4").Merge()



' Merges the cells in the range A6 to D9.

workSheet("A6:D9").Merge()



' Retrieve all the merged regions from the worksheet.

Dim retrieveMergedRegions As List(Of IronXL.Range) = workSheet.GetMergedRegions()



' Loop over each merged region and print the range address to the console.

For Each mergedRegion As IronXL.Range In retrieveMergedRegions

	Console.WriteLine(mergedRegion.RangeAddressAsString)

Next mergedRegion

using IronXL;

// Load the Excel workbook from the specified file named "mergedCell.xlsx".
WorkBook workBook = WorkBook.Load("mergedCell.xlsx");

// Access the default worksheet in the workbook.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Unmerge the cells in the specified range "B7:E7" in the worksheet.
// This operation will separate cells that were previously merged in that range.
workSheet.Unmerge("B7:E7");

// Save the workbook with the changes to a new file named "unmergedCell.xlsx".
// The changes include unmerging of the specified cells.
workBook.SaveAs("unmergedCell.xlsx");

Imports IronXL



' Load the Excel workbook from the specified file named "mergedCell.xlsx".

Private workBook As WorkBook = WorkBook.Load("mergedCell.xlsx")



' Access the default worksheet in the workbook.

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Unmerge the cells in the specified range "B7:E7" in the worksheet.

' This operation will separate cells that were previously merged in that range.

workSheet.Unmerge("B7:E7")



' Save the workbook with the changes to a new file named "unmergedCell.xlsx".

' The changes include unmerging of the specified cells.

workBook.SaveAs("unmergedCell.xlsx")