Skip to main content

XlValueObject Properties

An object that can be used to create a criterion for data validation and as a threshold value specified in the conditional formatting rule.
Name Description
BooleanValue Converts the object’s value to Boolean and returns the result.
DateTimeValue Converts the object’s value to DateTime type and returns the result.
Empty static Returns an empty object.
ErrorValue Converts the object’s value to cell error type and returns the result.
Expression Converts the object’s value to XlExpression and returns the result.
Formula Converts the object’s value to a worksheet formula and returns the result.
IsBoolean Gets whether the object originates from the value of the boolean type.
IsEmpty Gets whether the object has an empty value.
IsError Gets whether the object contains a Cell Error value.
IsExpression Gets whether the object contains an expression value.
IsFormula Gets whether the object contains a cell formula value.
IsNumeric Gets whether the current object contains a number.
IsRange Gets whether the object originates from a worksheet Range.
IsText Gets whether the object originates from a text string.
NumericValue Converts the object’s value to numeric and returns the result.
RangeValue Converts the object’s value to a worksheet range and returns the result.
TextValue Converts the object’s value to a string and returns the result.
See Also