officefileapi-devexpress-dot-spreadsheet-dot-cellvalue-f7676c0e.md
Gets the type of data contained in a cell.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public CellValueType Type { get; }
Public ReadOnly Property Type As CellValueType
| Type | Description |
|---|---|
| CellValueType |
A CellValueType enumerator member that specifies the cell value type.
|
Available values:
| Name | Description |
|---|---|
| None |
The cell contains an empty value.
| | Error |
The cell contains data of the error type.
| | Boolean |
The cell contains data of the boolean type.
| | Text |
The cell contains data of the text type.
| | Numeric |
The cell contains data of the numeric type.
| | DateTime |
The cell contains a number that is displayed as date and time.
| | CellImage |
The cell contains an in-cell image.
| | Unknown |
The type of data contained in the cell is unknown.
|
To check whether the cell value is of the specified type, use the corresponding property:
For more information on cell values, refer to the Cell Data Types document.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Type property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
how-to-export-cell-range-to-a-datatable/CS/ExportToDataTableExample/Form1.cs#L41
for (int col = 0; col < range.ColumnCount; col++) {
CellValueType cellType = range[firstDataRowIndex, col].Value.Type;
for (int r = firstDataRowIndex + 1; r < rowCount; r++) {
how-to-export-cell-range-to-a-datatable/VB/ExportToDataTableExample/Form1.vb#L40
For col As Integer = 0 To range.ColumnCount - 1
Dim cellType As CellValueType = range(firstDataRowIndex, col).Value.Type
For r As Integer = firstDataRowIndex + 1 To rowCount - 1
See Also