MergedCellRegions Class

using Leadtools; 
using Leadtools.Document.LEADOffice.Sheet; 
 
 
public void MergeCellsAndSaveExample() 
{ 
   // Load an Excel workbook from a file 
   var workbook = LEADWorkbookFactory.Create(); 
 
   // Add a new sheet named "MergeExample" or access an existing sheet 
   var sheet = workbook.CreateSheet("MergeExample"); 
 
   // Define the cell range to merge (e.g., A1:B1) 
   var mergeRange = new CellRange(0, 0, 0, 1); // This assumes 0-based indexing for rows and columns 
 
   // Perform the merge operation on the specified cell range 
   sheet.MergedRegions.AddRegion(mergeRange); 
 
   // Optionally, set a value for the merged cells 
   var cell = sheet.CreateRow(0).CreateCell(0); // Access the first cell in the merge range 
   cell.SetCellValue("Merged Cell"); 
 
   // Save the workbook to disk 
   var filePath = Path.Combine(LEAD_VARS.ImagesDir, @"MergedCells.xlsx"); 
   workbook.Save(filePath); 
 
   Console.WriteLine($"Workbook saved with merged cells to {filePath}"); 
} 
 
static class LEAD_VARS 
{ 
   public const string ImagesDir = @"C:\LEADTOOLS23\Resources\Images"; 
}