CellRange.ExistingCells Property
Gets the existing cells in the current cell range.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
Type | Description |
---|---|
IEnumerable<Cell> | An object implementing the IEnumerable interface that supports iteration over the cell collection. |
Remarks
The ExistingCells collection includes the following cells:
- Cells that contain a CellRange.Value or CellRange.Formula;
- Cells that have any Formatting properties which are not null;
- Top-left cells of merged cells;
- Cells that contained a value or had cell formatting options applied at any time. For example, if the cell A1 contained a value that was later deleted, the cell A1 is included in the ExistingCells collection.
To get a collection of existing cells in a worksheet, use the Worksheet.GetExistingCells method.
See Also