Provides methods that manage a composite data type representing a value.
Inheritance
object
- IConvertible
- IComparable
Constructors
Section titled "Constructors"constructor
public ExcelCalcValue()Returns ExcelCalcValue
constructor
public ExcelCalcValue(object value)Returns ExcelCalcValue
Properties
Section titled "Properties"IsArray
Section titled "IsArray"Returns whether this class instance contains an array value.
public bool IsArray { get; }IsArrayGroup
Section titled "IsArrayGroup"Returns whether this class instance contains a group of array values.
public bool IsArrayGroup { get; }IsBoolean
Section titled "IsBoolean"Returns whether this class instance contains a boolean value
public bool IsBoolean { get; }IsDBNull
Section titled "IsDBNull"Returns whether this class instance contains a DBNull value
public bool IsDBNull { get; }IsDateTime
Section titled "IsDateTime"Returns whether this class instance contains a DateTime value
public bool IsDateTime { get; }IsError
Section titled "IsError"Returns whether this class instance contains an error value
public bool IsError { get; }IsNull
Section titled "IsNull"Returns whether this class instance contains a null value
public bool IsNull { get; }IsReference
Section titled "IsReference"Returns whether this class instance contains a value
public bool IsReference { get; }IsString
Section titled "IsString"Returns whether this class instance contains a string value
public bool IsString { get; }Value
Section titled "Value"Return the underlying value
public object Value { get; }Methods
Section titled "Methods"AreValuesEqual(ExcelCalcValue, ExcelCalcValue)
Section titled "AreValuesEqual(ExcelCalcValue, ExcelCalcValue)"Indicates if the value of the specified is equivalent to the
public static bool AreValuesEqual(ExcelCalcValue x, ExcelCalcValue y)Parameters
- x:
ExcelCalcValue - y:
ExcelCalcValue
Returns any
CompareTo(ExcelCalcValue)
Section titled "CompareTo(ExcelCalcValue)"Compares current instance with the passed in instance. Returns -1, 1 or 0 depending on whether the current instance is less than, greater than or equal to the passed in instance respectively.
public int CompareTo(ExcelCalcValue value)Parameters
- value:
ExcelCalcValue
Returns any
CompareTo(ExcelCalcValue, ExcelCalcValue)
Section titled "CompareTo(ExcelCalcValue, ExcelCalcValue)"Compares x and y instances and returns -1 if x is less than y, 1 if x is greater than y and 0 if x and y are equal.
public static int CompareTo(ExcelCalcValue x, ExcelCalcValue y)Parameters
- x:
ExcelCalcValue - y:
ExcelCalcValue
Returns any
DateTimeToExcelDate(Workbook, DateTime)
Section titled "DateTimeToExcelDate(Workbook, DateTime)"Converts a DateTime to Excel's numerical representation of a date.
public static double? DateTimeToExcelDate(Workbook workbook, DateTime dateValue)Parameters
- workbook:
Workbook - dateValue:
DateTime
Returns any
DateTimeToExcelDate(Workbook, DateTime, bool)
Section titled "DateTimeToExcelDate(Workbook, DateTime, bool)"Converts a DateTime to Excel's numerical representation of a date.
public static double? DateTimeToExcelDate(Workbook workbook, DateTime dateValue, bool shouldCorrect1900Dates)Parameters
- workbook:
Workbook - dateValue:
DateTime - shouldCorrect1900Dates:
bool
Returns any
ExcelDateToDateTime(Workbook, double)
Section titled "ExcelDateToDateTime(Workbook, double)"Converts Excel's numerical representation of a date to a DateTime.
public static DateTime? ExcelDateToDateTime(Workbook workbook, double excelDate)Parameters
- workbook:
Workbook - excelDate:
double
Returns any
ExcelDateToDateTime(Workbook, double, bool)
Section titled "ExcelDateToDateTime(Workbook, double, bool)"Converts Excel's numerical representation of a date to a DateTime.
public static DateTime? ExcelDateToDateTime(Workbook workbook, double excelDate, bool shouldCorrect1900Dates)Parameters
- workbook:
Workbook - excelDate:
double - shouldCorrect1900Dates:
bool
Returns any
ExcelDateToTimeOfDay(double, bool)
Section titled "ExcelDateToTimeOfDay(double, bool)"Converts Excel's numerical representation of a time of day to a TimeSpan.
public static TimeSpan ExcelDateToTimeOfDay(double excelDate, bool useDayInfo = false)Parameters
- excelDate:
double - useDayInfo:
bool
Returns any
GetResolvedValue()
Section titled "GetResolvedValue()"Gets the resolved value of the reference. This method will walk down the reference chain recursively to get the resolved value of the reference that is not just another reference.
public object GetResolvedValue()Returns any
GetResolvedValue(bool)
Section titled "GetResolvedValue(bool)"Gets the resolved value of the reference. This method will walk down the reference chain recursively to get the resolved value of the reference that is not just another reference.
public object GetResolvedValue(bool willUseValueInCalculations)Parameters
- willUseValueInCalculations:
bool
Returns any
GetTypeCode()
Section titled "GetTypeCode()"Returns the TypeCode for this instance
public TypeCode GetTypeCode()Returns any
IsSameValue(ExcelCalcValue)
Section titled "IsSameValue(ExcelCalcValue)"Indicates if the specified has the save as this instance.
public bool IsSameValue(ExcelCalcValue value)Parameters
- value:
ExcelCalcValue
Returns any
TimeOfDayToExcelDate(TimeSpan, bool)
Section titled "TimeOfDayToExcelDate(TimeSpan, bool)"Converts a TimeSpan to Excel's numerical representation of a date.
public static double TimeOfDayToExcelDate(TimeSpan timeValue, bool useDayInfo = false)Parameters
- timeValue:
TimeSpan - useDayInfo:
bool
Returns any
ToArrayProxy()
Section titled "ToArrayProxy()"Convert this class instance's value to an data type.
public ArrayProxy ToArrayProxy()Returns any
ToArrayProxyGroup()
Section titled "ToArrayProxyGroup()"Convert this class instance's value to an array group data type.
public ArrayProxy[] ToArrayProxyGroup()Returns any
ToBoolean()
Section titled "ToBoolean()"Convert this class instance's value to a boolean data type
public bool ToBoolean()Returns any
ToBoolean(IFormatProvider)
Section titled "ToBoolean(IFormatProvider)"Convert this class instance's value to a boolean data type
public bool ToBoolean(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToByte()
Section titled "ToByte()"Convert this class instance's value to a byte data type
public byte ToByte()Returns any
ToByte(IFormatProvider)
Section titled "ToByte(IFormatProvider)"Convert this class instance's value to a byte data type
public byte ToByte(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToChar()
Section titled "ToChar()"Convert this class instance's value to a char data type
public char ToChar()Returns any
ToChar(IFormatProvider)
Section titled "ToChar(IFormatProvider)"Convert this class instance's value to a char type
public char ToChar(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToDateTime()
Section titled "ToDateTime()"Convert this class instance's value to a DateTime data type
public DateTime ToDateTime()Returns any
ToDateTime(IFormatProvider)
Section titled "ToDateTime(IFormatProvider)"Convert this class instance's value to a DateTime data type
public DateTime ToDateTime(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToDecimal()
Section titled "ToDecimal()"Convert this class instance's value to a decimal data type
public decimal ToDecimal()Returns any
ToDecimal(out decimal)
Section titled "ToDecimal(out decimal)"Converts the to a decimal data type
public bool ToDecimal(out decimal result)Parameters
- result:
decimal
Returns any
ToDecimal(IFormatProvider)
Section titled "ToDecimal(IFormatProvider)"Convert this class instance's value to a decimal data type
public decimal ToDecimal(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToDouble()
Section titled "ToDouble()"Convert this class instance's value to a double data type
public double ToDouble()Returns any
ToDouble(out double)
Section titled "ToDouble(out double)"Converts the to a double data type
public bool ToDouble(out double result)Parameters
- result:
double
Returns any
ToDouble(IFormatProvider)
Section titled "ToDouble(IFormatProvider)"Convert this class instance's value to a double data type
public double ToDouble(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToErrorValue()
Section titled "ToErrorValue()"Convert this instance's value to an
public ExcelCalcErrorValue ToErrorValue()Returns any
ToInt()
Section titled "ToInt()"Convert this class instance's value to an int
public int ToInt()Returns any
ToInt(IFormatProvider)
Section titled "ToInt(IFormatProvider)"Convert this class instance's value to an int
public int ToInt(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToInt16()
Section titled "ToInt16()"Convert this class instance's value to a short data type
public short ToInt16()Returns any
ToInt16(IFormatProvider)
Section titled "ToInt16(IFormatProvider)"Convert this class instance's value to a short data type
public short ToInt16(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToInt32()
Section titled "ToInt32()"Convert this class instance's value to a int data type
public int ToInt32()Returns any
ToInt32(IFormatProvider)
Section titled "ToInt32(IFormatProvider)"Convert this class instance's value to a int data type
public int ToInt32(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToInt64()
Section titled "ToInt64()"Convert this class instance's value to a long data type
public long ToInt64()Returns any
ToInt64(IFormatProvider)
Section titled "ToInt64(IFormatProvider)"Convert this class instance's value to a long data type
public long ToInt64(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToReference()
Section titled "ToReference()"Convert this instance's value to a .
public IExcelCalcReference ToReference()Returns any
ToSingle()
Section titled "ToSingle()"Convert this class instance's value to a float data type
public float ToSingle()Returns any
ToSingle(IFormatProvider)
Section titled "ToSingle(IFormatProvider)"Convert this class instance's value to a float data type
public float ToSingle(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToString()
Section titled "ToString()"Returns a string representation of this instance's value.
public override string ToString()Returns any
ToString(IFormatProvider)
Section titled "ToString(IFormatProvider)"Convert this class instance's value to a string instance data type
public string ToString(IFormatProvider provider)Parameters
- provider:
IFormatProvider
Returns any
ToType(Type, IFormatProvider)
Section titled "ToType(Type, IFormatProvider)"Convert this class instance's value to a uint data type
public object ToType(Type conversionType, IFormatProvider provider)Parameters
- conversionType:
Type - provider:
IFormatProvider