Extended Data Type Type Property

Returns the value type for a specific cell. 

Syntax

&ExcelDocument.Cells(…).Type

Type Returned:
Character

Values

D: For date or datetime types
C: For character type
N: For numeric type
U: If the type is unknown 

Description

If there are cells with different types in the ExcelCells object, the Type property will return a “U”.
This is a read-only property, it cannot be assigned.

Scope

Extended Data Types: ExcelCells
Languages: .NET, Java, Ruby, Visual Basic, Visual FoxPro

See Also

Cells Method
ExcelCells Data Type
ExcelDocument Data Type