CellRange.ExistingCells Property

Gets the existing cells in the current cell range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

IEnumerable<Cell> ExistingCells { get; }

VB.NET

ReadOnly Property ExistingCells As IEnumerable(Of Cell)

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.