Represents a value inside a cell.
TCellValue = record;
|Empty||Creates a cell value without value.
|IsEmpty||Returns true if the cell is empty.
|HasValue||Returns true if the cell has a value. This is the opposite of IsEmpty|
|IsNumber||Returns true if the cell contains a number. Note that cells with dates will be reported as Number too.
|IsDateTime||Returns true if the value is a DateTime.
Note::This value will never be true when reading cells from a file.
When reading a file, dates are stored as number so they will be returned as numbers.
This property only will return true if you manually created a TCellValue from a TDateTime.
To know if a cell has a date, you need to look at its format, not its value.
|IsString||Returns true if the cell has a string.
|IsBoolean||Returns true if the cell has a boolean.
|IsError||Returns true if the cell has an error like #N/A! or #DIV0!.
Note that this only applies to error values entered directly in the cell.
If the cell has a formula that returns #N/A!, then the cell has a formula and the formula has an error. But the cell itself doesn't have an error.
|IsFormula||Returns true if the cell has a formula.
|AsNumber||Returns the value of the cell if it contains a number or a date.
If the cell doesn't contain a number this method will raise an exception so you might want to check first the cell data type before calling it.
|AsDateTime||If the cell contains a datetime, it returns the value. If not, it raises an Exception. Remember that cells returned from a file will never have a datetime, they will have numbers instead.
|AsString||If the cell contains a string, it returns the string. If not, it raises an Exception. To get a string with whatever value is in the class, use ToString|
|ToString||Returns a rich string with whatever the cell value is. If this is an integer or a boolean, it will be converted to a string.
|ToSimpleString||Returns a string without formatting. This is equivalent to ToString.ToString, but it can be faster.
|ToStringInvariant||Returns a string with whatever the cell value is. If this is number, it will be converted to a string, using invariant format settings (decimal separator will always be "." for example).
|ToDateTime||Returns the value as a DateTime, if it can be converted, or DateTime(0) if it can't.
|ToNumberInvariant||Returns the value as a number, if it can be converted, or 0 if it can't. Note that this conversion uses invariant culture so even if your decimal separator is ",", the strings converted should be like "2.0"|
|AsBoolean||If the cell contains a boolean, it returns the value. If not, it raises an exception.
|AsError||If the cell contains an error, it returns the value. If not, it raises an exception.
|AsFormula||If the cell contains a formula, it returns the value. If not, it raises an exception.
|AsVariant||Returns the cell value as a variant.
|AsTValue||Returns the cell value as a TValue.
|ClearValue||Sets the value of the cell to empty.