officefileapi-devexpress-dot-spreadsheet-dot-rangeextensions-dot-count-x28-devexpress-dot-spreadsheet-dot-cellrange-system-dot-boolean-system-dot-boolean-x29.md
Returns the number of cells in the current cell range that contain data.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public static int Count(
this CellRange range,
bool ignoreHiddenRows,
bool ignoreHiddenColumns
)
<ExtensionAttribute>
Public Shared Function Count(
range As CellRange,
ignoreHiddenRows As Boolean,
ignoreHiddenColumns As Boolean
) As Integer
| Name | Type | Description |
|---|---|---|
| range | CellRange |
A cell range for which the count is calculated.
| | ignoreHiddenRows | Boolean |
true to exclude hidden rows from calculation; otherwise, false.
| | ignoreHiddenColumns | Boolean |
true to exclude hidden columns from calculation; otherwise, false.
|
| Type | Description |
|---|---|
| Int32 |
The number of cells with data.
|
Use the following extension methods to summarize data in a cell range. You can call these methods in the same way as instance methods of the CellRange object.
| Method | Description |
|---|---|
| RangeExtensions.Average | Returns the average of numerical values in a cell range. |
| RangeExtensions.Count | Returns the number of cells that contain data. |
| RangeExtensions.NumericalCount | Returns the number of cells that contain numerical data. |
| RangeExtensions.Sum | Returns the sum of numerical values in a cell range. |
| RangeExtensions.Max | Returns the maximum numerical value in a cell range. |
| RangeExtensions.Min | Returns the minimum numerical value in a cell range. |
The following code example shows how to obtain summary values for selected cells in the Spreadsheet control.
CellRange selectedCells = spreadsheetControl1.Selection;
double average = selectedCells.Average(true, true);
double sum = selectedCells.Sum(true, true);
double count = selectedCells.Count(true, true);
double numCount = selectedCells.NumericalCount(true, true);
Dim selectedCells As CellRange = spreadsheetControl1.Selection
Dim average As Double = selectedCells.Average(True, True)
Dim sum As Double = selectedCells.Sum(True, True)
Dim count As Double = selectedCells.Count(True, True)
Dim numCount As Double = selectedCells.NumericalCount(True, True)
See Also