Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

CellRange.ExistingCells Property

Gets the existing cells in the current cell range.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

IEnumerable<Cell> ExistingCells { get; }

#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