CALENDAR_WINDOWS_1900
CALENDAR_WINDOWS_1900 = 1900
constants
setDefaultTimezone(\DateTimeZone|string $timeZone) : boolean
Set the Default timezone to use for dates.
| \DateTimeZone|string | $timeZone | The timezone to set for all Excel datetimestamp to PHP DateTime Object conversions |
Success or failure
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
isDateTime(\PhpOffice\PhpSpreadsheet\Cell\Cell $pCell) : boolean
Is a given cell a date/time?
| \PhpOffice\PhpSpreadsheet\Cell\Cell | $pCell |
isDateTimeFormat(\PhpOffice\PhpSpreadsheet\Style\NumberFormat $pFormat) : boolean
Is a given number format a date/time?
| \PhpOffice\PhpSpreadsheet\Style\NumberFormat | $pFormat |
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