CellValue.Type Property

Gets the type of data contained in a cell.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v22.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public CellValueType Type { get; }

VB.NET

Public ReadOnly Property Type As CellValueType

Property Value

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.
Unknown	The type of data contained in the cell is unknown.

Remarks

To check whether the cell value is of the specified type, use the corresponding property:

• CellValue.IsText
• CellValue.IsNumeric
• CellValue.IsDateTime
• CellValue.IsBoolean
• CellValue.IsError
• CellValue.IsEmpty

For more information on cell values, refer to the Cell Data Types document.

Related GitHub Examples

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.

C#

how-to-export-cell-range-to-a-datatable/CS/ExportToDataTableExample/Form1.cs#L39

{
    CellValueType cellType = range[0, col].Value.Type;
    for (int r = 1; r < range.RowCount; r++)

VB.NET

how-to-export-cell-range-to-a-datatable/VB/ExportToDataTableExample/Form1.vb#L37

For col As Integer = 0 To range.ColumnCount - 1
    Dim cellType As CellValueType = range(0, col).Value.Type
    For r As Integer = 1 To range.RowCount - 1