CellValue Members
A data value contained in a cell.Fields
| Name | Description |
|---|---|
| ErrorDivisionByZero static | Returns the CellValue object specifying the #DIV/0! error value of a cell. |
| ErrorInvalidValueInFunction static | Returns the CellValue object specifying the #VALUE! error value of a cell. |
| ErrorName static | Returns the CellValue object specifying the #NAME? error value of a cell. |
| ErrorNullIntersection static | Returns the CellValue object specifying the #NULL! error value of a cell. |
| ErrorNumber static | Returns the CellValue object specifying the #NUM! error value of a cell. |
| ErrorReference static | Returns the CellValue object specifying the #REF! error value of a cell. |
| ErrorValueNotAvailable static | Returns the CellValue object specifying the #N/A error value of a cell. |
Properties
| Name | Description |
|---|---|
| BooleanValue | Returns a Boolean value contained in a cell. |
| DateTimeValue | Returns the date and time value that corresponds to the number contained in a cell. |
| DefaultConverter static | Provides access to the default converter which is used to convert objects of basic data types to cell values, and vise versa. |
| Empty static | Returns an empty cell value. |
| ErrorValue | Returns an object that provides information on an error contained in a cell. |
| IsBoolean | Gets whether the cell contains a Boolean value. |
| IsDateTime | Gets whether the cell’s numeric value is displayed as date and time. |
| IsEmpty | Gets whether the cell is empty. |
| IsError | Gets whether the cell contains an error. |
| IsNumeric | Gets whether the cell contains a number. |
| IsText | Gets whether the cell contains text. |
| NumericValue | Returns a number contained in a cell. |
| TextValue | Returns a string contained in a cell. |
| Type | Gets the type of data contained in a cell. |
Methods
| Name | Description |
|---|---|
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether two objects are equal. |
| FromDateTime(DateTime, Boolean) static | Converts the DateTime object to a cell value using the specified date system. |
| FromObject(Object, ICellValueConverter) static | Converts the specified object to a cell value using the custom converter. |
| FromObject(Object) static | Converts the specified object to a cell value using the default converter. |
| GetHashCode() | Gets the hash code (a number) that corresponds to the value of the current CellValue object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ToObject() | Converts the cell value to an object using the default converter. |
| ToObject(ICellValueConverter) | Converts the cell value to an object using the specified converter. |
| ToString() | Returns a string representation of the cell value. |
| ToString(IFormatProvider) | Returns a string representation of the cell value. |
| TryCreateFromObject(Object, ICellValueConverter) static | Tries to convert the specified object to a cell value using the custom converter. |
| TryCreateFromObject(Object) static | Tries to convert the specified object to a cell value using the default converter. |
Operators
| Name | Description |
|---|---|
| Equality(CellValue, CellValue) static | Compares two CellValue objects for equality. |
| Implicit(ErrorType to CellValue) static | Implicitly converts a value of error type to a cell value. |
| Implicit(Boolean to CellValue) static | Implicitly converts a Boolean value to a cell value. |
| Implicit(Char to CellValue) static | Implicitly converts a Char value to a cell value. |
| Implicit(DateTime to CellValue) static | Implicitly converts a DateTime value to a cell value. |
| Implicit(Decimal to CellValue) static | Implicitly converts a Decimal value to a cell value. |
| Implicit(Double to CellValue) static | Implicitly converts a Double value to a cell value. |
| Implicit(Int32 to CellValue) static | Implicitly converts an Int32 value to a cell value. |
| Implicit(Int64 to CellValue) static | Implicitly converts an Int64 value to a cell value. |
| Implicit(Single to CellValue) static | Implicitly converts a Single value to a cell value. |
| Implicit(String to CellValue) static | Implicitly converts a String value to a cell value. |
| Implicit(TimeSpan to CellValue) static | Implicitly converts a TimeSpan value to a cell value. |
| Inequality(CellValue, CellValue) static | Compares two CellValue objects to determine whether they are not equal. |
See Also