Syncfusion.XlsIO.Base
Example 


UnMerge Method

Separates merged cells into individual cells.
Syntax
'Declaration
 
Sub UnMerge() 
'Usage
 
Dim instance As IRange
 
instance.UnMerge()
void UnMerge()
Remarks
To know more about merging refer Merging and Un-Merging Cells.
Example
The following code illustrates how to UnMerge the merged cells.
using Syncfusion.XlsIO;
            
class Program
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);                                
            IWorksheet worksheet = workbook.Worksheets[0];
            
            //Set text
            worksheet["A1"].Text = "Merged cell";
            
            //Merge cells
            worksheet["A1:B1"].Merge();
            
            //Unmerge cells
            worksheet["A1:B1"].UnMerge();
            
            //Save and dispose
            workbook.SaveAs("CellFormats.xlsx");
            workbook.Close(); 
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also