Represents a merged region of cells, or cells which share a value and format and appear as one cell when viewed in Microsoft Excel. Syntax Remarks Merged cell regions cannot overlap (a cell can only belong to one merged cell region). In addition, ArrayFormula and WorksheetDataTable instances cannot be applied to m...
A collection of WorksheetMergedCellsRegion instances in a Worksheet. Syntax
Public Properties Public Methods
Public Methods
Public Properties
Creates new merged cell region and adds it to the collection. Syntax Parameters firstRow The index of the first row of the merged cell region.firstColumn The index of the first column of the merged cell region.lastRow The index of the last row of the merged cell region.lastColumn The index of the last row column o...
Clears all merged cell regions from the collection. Syntax Remarks When a merged cell region is removed, the top-left cell in the region will retain the regions value. All other cells in the region will have a null value. In addition, all cells in the merged region will have the regions cell format when it is remo...
Gets the number of merged cell regions in the collection. Syntax Property Value The number of merged cell regions in the collection.
Checks if any part of specified region is already a part of a merged cell region. Syntax Parameters firstRow The index of the first row of the merged cell region.firstColumn The index of the first column of the merged cell region.lastRow The index of the last row of the merged cell region.lastColumn The index of t...
Gets the merged cell region at the specified index. Syntax Parameters index The zero-based index of the merged cell region to get. Property Value The merged cell region at the specified index. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero or index is greater than or eq...