Converts Excels numerical representation of a date to a DateTime. Syntax Parameters workbook excelDate The Microsoft Excel date format which should be converted to a DateTime. Remarks When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap...
Converts Excels numerical representation of a date to a DateTime. Syntax Parameters workbook excelDate The Microsoft Excel date format which should be converted to a DateTime.shouldCorrect1900Dates When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes ...
Converts Excels numerical representation of a date to a DateTime. Overload List
Converts Excels numerical representation of a time of day to a TimeSpan. Syntax Parameters excelDate The Microsoft Excel date format which should be converted to a DateTime.useDayInfo Optional parameter to allow the day information to be included as well. Remarks In Excel, only the fractional portion of the date v...
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. Syntax
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. Syntax Parameters willUseValueInCalculations True if the value returned will actually be used in calculations; False if the value is be...
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. Overload List
Returns the TypeCode for this instance Syntax Return Value The enumerated constant that is the TypeCode of the class or value type that implements this interface.
Returns whether this class instance contains an array value. Syntax Property Value True if this instance class contains an array, else false.
Returns whether this class instance contains a group of array values. Syntax Property Value True if this instance class contains an array group, else false.