CALENDAR_WINDOWS_1900
CALENDAR_WINDOWS_1900 = 1900
constants
$monthNames : string[]
Names of the months of the year, indexed by shortname Planned usage for locale settings.
$numberSuffixes : string[]
$excelCalendar : int
Base calendar year to use for calculations Value is either CALENDAR_WINDOWS_1900 (1900) or CALENDAR_MAC_1904 (1904).
$defaultTimeZone : null|\DateTimeZone
Default timezone to use for DateTime objects.
excelToDateTimeObject(float|int $excelTimestamp, null|\DateTimeZone|string $timeZone = null) : \DateTime
Convert a MS serialized datetime value from Excel to a PHP Date/Time object.
float|int | $excelTimestamp | MS Excel serialized date/time value |
null|\DateTimeZone|string | $timeZone | The timezone to assume for the Excel timestamp, if you don't want to treat it as a UTC value Use the default (UST) unless you absolutely need a conversion |
PHP date/time object
excelToTimestamp(float|int $excelTimestamp, null|\DateTimeZone|string $timeZone = null) : int
Convert a MS serialized datetime value from Excel to a unix timestamp.
float|int | $excelTimestamp | MS Excel serialized date/time value |
null|\DateTimeZone|string | $timeZone | The timezone to assume for the Excel timestamp, if you don't want to treat it as a UTC value Use the default (UST) unless you absolutely need a conversion |
Unix timetamp for this date/time
monthStringToNumber(string $month) : int|string
Converts a month name (either a long or a short name) to a month number.
string | $month | Month name or abbreviation |
Month number (1 - 12), or the original string argument if it isn't a valid month name