User`s guide

Data Conversion Rules
B-11
VT_DATE double
1. VARIANT dates are stored as doubles starting at
midnight Dec. 31, 1899. MATLAB dates are
stored as doubles starting at 0/0/00 00:00:00.
Therefore, a
VARIANT date of 0.0 maps to a
MATLAB numeric date of 693960.0.
VARIANT
dates are converted to MATLAB double types and
incremented by 693960.0.
2.
VARIANT dates can be optionally converted to
strings. See “Data Conversion Flags” on
page B-14 for more information on type coercion.
VT_INT int32
VT_UINT unit32
VT_DECIMAL double
VT_BOOL logical
VT_DISPATCH
(varies) IDispatch* pointers are treated within the
context of what they point to. Objects must be
supported types with known data extraction and
conversion rules or expose a generic “Value”
property that points to a single
VARIANT type.
Data extracted from an object is converted based
upon the rules for the particular
VARIANT
obtained. Currently, support exists for Excel
Range objects as well as Excel Builder types
MWStruct, MWComplex, MWSparse, and MWArg. See
“Utility Library Classes” on page D-3 for
information on Excel Builder types.
Table B-3: COM VARIANT to MATLAB Conversion Rules (Continued)
VARIANT Type MATLAB Data
Type (scalar or
array data)
Comments