CALENDAR_WINDOWS_1900
CALENDAR_WINDOWS_1900 = 1900
constants
excelToDateTimeObject(float|integer $excelTimestamp, null|\DateTimeZone|string $timeZone = null) : \DateTime
Convert a MS serialized datetime value from Excel to a PHP Date/Time object.
float|integer | $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|integer $excelTimestamp, null|\DateTimeZone|string $timeZone = null) : integer
Convert a MS serialized datetime value from Excel to a unix timestamp.
float|integer | $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
formattedPHPToExcel(integer $year, integer $month, integer $day, integer $hours, integer $minutes, integer $seconds) : float
formattedPHPToExcel.
integer | $year | |
integer | $month | |
integer | $day | |
integer | $hours | |
integer | $minutes | |
integer | $seconds |
Excel date/time value
monthStringToNumber(string $month) : integer|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