xlldate.h contains some global functions that access Excel's native date functionality and a class CXlDate which offers the same functionality in a more convenient form.
The table below lists the C++ object classes declared in the header file.
Class | Description |
---|---|
CXlDate | Static class containing date helper functions. |
The table below lists the principal functions declared in the header file.
Function | Description |
---|---|
XlSerialToDate | Transform an Excel serial date to year, month and day. |
XlDateToSerial | Transform year, month and day to an Excel serial date. |
XlLSerialToDate | Transform an integer Excel serial date to year, month and day. |
XlDateToLSerial | Transform year, month and day to an Excel serial date. |
XlStringToDate | Transform a string to year, month and day. |
XlStringToSerial | Transform a string to a serial date. |
XlStringToLSerial | Transform a string to a serial date. |
XlToday | Get today's date. |
XlNow | Get the current time. |
XlWeekday | Convert a date to a day of the week. |
A full list can be found here.