Collaboration diagram for PhpOffice\PhpSpreadsheet\Shared\Date:

Static Public Member Functions
static	setExcelCalendar ($baseDate)
	Set the Excel calendar (Windows 1900 or Mac 1904). More...

static	getExcelCalendar ()
	Return the Excel calendar (Windows 1900 or Mac 1904). More...

static	setDefaultTimezone ($timeZone)
	Set the Default timezone to use for dates. More...

static	getDefaultTimezone ()
	Return the Default timezone, or UTC if default not set. More...

static	getDefaultOrLocalTimezone ()
	Return the Default timezone, or local timezone if default is not set. More...

static	getDefaultTimezoneOrNull ()
	Return the Default timezone even if null. More...

static	excelToDateTimeObject ($excelTimestamp, $timeZone=null)
	Convert a MS serialized datetime value from Excel to a PHP Date/Time object. More...

static	excelToTimestamp ($excelTimestamp, $timeZone=null)
	Convert a MS serialized datetime value from Excel to a unix timestamp. More...

static	PHPToExcel ($dateValue)
	Convert a date from PHP to an MS Excel serialized date/time value. More...

static	dateTimeToExcel (DateTimeInterface $dateValue)
	Convert a PHP DateTime object to an MS Excel serialized date/time value. More...

static	timestampToExcel ($dateValue)
	Convert a Unix timestamp to an MS Excel serialized date/time value. More...

static	formattedPHPToExcel ($year, $month, $day, $hours=0, $minutes=0, $seconds=0)
	formattedPHPToExcel. More...

static	isDateTime (Cell $pCell)
	Is a given cell a date/time? More...

static	isDateTimeFormat (NumberFormat $pFormat)
	Is a given number format a date/time? More...

static	isDateTimeFormatCode ($pFormatCode)
	Is a given number format code a date/time? More...

static	stringToExcel ($dateValue)
	Convert a date/time string to Excel time. More...

static	monthStringToNumber ($month)
	Converts a month name (either a long or a short name) to a month number. More...

static	dayStringToNumber ($day)
	Strips an ordinal from a numeric value. More...

static	dateTimeFromTimestamp (string $date, ?DateTimeZone $timeZone=null)

static	formattedDateTimeFromTimestamp (string $date, string $format, ?DateTimeZone $timeZone=null)

Data Fields
const	CALENDAR_WINDOWS_1900 = 1900
	constants More...

const	CALENDAR_MAC_1904 = 1904

Static Public Attributes
static	$monthNames

static	$numberSuffixes

Static Protected Attributes
static	$excelCalendar = self::CALENDAR_WINDOWS_1900

static	$defaultTimeZone

Static Private Member Functions
static	validateTimeZone ($timeZone)
	Validate a timezone. More...

Static Private Attributes
static	$possibleDateFormatCharacters = 'eymdHs'

Detailed Description

Definition at line 14 of file Date.php.

Member Function Documentation

◆ dateTimeFromTimestamp()

static PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeFromTimestamp	(	string	$date,
		?DateTimeZone	$timeZone = `null`
	)

static

Definition at line 504 of file Date.php.

                                                                                              : DateTime
    {
        $dtobj = DateTime::createFromFormat('U', $date) ?: new DateTime();
        $dtobj->setTimeZone($timeZone ?? self::getDefaultOrLocalTimezone());
 
        return $dtobj;
    }

References $timeZone.

Referenced by PhpOffice\PhpSpreadsheet\Writer\Ods\Meta\write(), PhpOffice\PhpSpreadsheet\Writer\Xlsx\DocProps\writeDocPropsCore(), PhpOffice\PhpSpreadsheet\Writer\Xlsx\DocProps\writeDocPropsCustom(), and PhpOffice\PhpSpreadsheet\Writer\Ods\Meta\writeDocPropsCustom().

Here is the caller graph for this function:

◆ dateTimeToExcel()

static PhpOffice\PhpSpreadsheet\Shared\Date::dateTimeToExcel ( DateTimeInterface $dateValue )

static

Convert a PHP DateTime object to an MS Excel serialized date/time value.

Parameters

DateTimeInterface $dateValue PHP DateTime object

Returns: float MS Excel serialized date/time value

Definition at line 251 of file Date.php.

    {
        return self::formattedPHPToExcel(
            (int) $dateValue->format('Y'),
            (int) $dateValue->format('m'),
            (int) $dateValue->format('d'),
            (int) $dateValue->format('H'),
            (int) $dateValue->format('i'),
            (int) $dateValue->format('s')
        );
    }

◆ dayStringToNumber()

static PhpOffice\PhpSpreadsheet\Shared\Date::dayStringToNumber ( $day )

static

Strips an ordinal from a numeric value.

Parameters

string $day Day number with an ordinal

Returns: int|string The integer value with any ordinal stripped, or the original string argument if it isn't a valid numeric

Definition at line 494 of file Date.php.

    {
        $strippedDayValue = (str_replace(self::$numberSuffixes, '', $day));
        if (is_numeric($strippedDayValue)) {
            return (int) $strippedDayValue;
        }
 
        return $day;
    }

◆ excelToDateTimeObject()

static PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject	(	$excelTimestamp,
		$timeZone = `null`
	)

static

Convert a MS serialized datetime value from Excel to a PHP Date/Time object.

Parameters

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

Returns: DateTime PHP date/time object

Definition at line 170 of file Date.php.

    {
        $timeZone = ($timeZone === null) ? self::getDefaultTimezone() : self::validateTimeZone($timeZone);
        if (Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {
            if ($excelTimestamp < 1 && self::$excelCalendar === self::CALENDAR_WINDOWS_1900) {
                // Unix timestamp base date
                $baseDate = new DateTime('1970-01-01', $timeZone);
            } else {
                // MS Excel calendar base dates
                if (self::$excelCalendar == self::CALENDAR_WINDOWS_1900) {
                    // Allow adjustment for 1900 Leap Year in MS Excel
                    $baseDate = ($excelTimestamp < 60) ? new DateTime('1899-12-31', $timeZone) : new DateTime('1899-12-30', $timeZone);
                } else {
                    $baseDate = new DateTime('1904-01-01', $timeZone);
                }
            }
        } else {
            $baseDate = new DateTime('1899-12-30', $timeZone);
        }
 
        $days = floor($excelTimestamp);
        $partDay = $excelTimestamp - $days;
        $hours = floor($partDay * 24);
        $partDay = $partDay * 24 - $hours;
        $minutes = floor($partDay * 60);
        $partDay = $partDay * 60 - $minutes;
        $seconds = round($partDay * 60);
 
        if ($days >= 0) {
            $days = '+' . $days;
        }
        $interval = $days . ' days';
 
        return $baseDate->modify($interval)
            ->setTime((int) $hours, (int) $minutes, (int) $seconds);
    }

References $timeZone, PhpOffice\PhpSpreadsheet\Calculation\Functions\COMPATIBILITY_EXCEL, and PhpOffice\PhpSpreadsheet\Calculation\Functions\getCompatibilityMode().

Referenced by PhpOffice\PhpSpreadsheet\Style\NumberFormat\DateFormatter\format().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ excelToTimestamp()

static PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimestamp	(	$excelTimestamp,
		$timeZone = `null`
	)

static

Convert a MS serialized datetime value from Excel to a unix timestamp.

Parameters

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

Returns: int Unix timetamp for this date/time

Definition at line 217 of file Date.php.

    {
        return (int) self::excelToDateTimeObject($excelTimestamp, $timeZone)
            ->format('U');
    }

References $timeZone.

◆ formattedDateTimeFromTimestamp()

static PhpOffice\PhpSpreadsheet\Shared\Date::formattedDateTimeFromTimestamp	(	string	$date,
		string	$format,
		?DateTimeZone	$timeZone = `null`
	)

static

Definition at line 512 of file Date.php.

                                                                                                                       : string
    {
        $dtobj = self::dateTimeFromTimestamp($date, $timeZone);
 
        return $dtobj->format($format);
    }

References $format, and $timeZone.

◆ formattedPHPToExcel()

static PhpOffice\PhpSpreadsheet\Shared\Date::formattedPHPToExcel	(	$year,
		$month,
		$day,
		$hours = `0`,
		$minutes = `0`,
		$seconds = `0`
	)

static

formattedPHPToExcel.

Parameters

int	$year
int	$month
int	$day
int	$hours
int	$minutes
int	$seconds

Returns: float Excel date/time value

Definition at line 291 of file Date.php.

    {
        if (self::$excelCalendar == self::CALENDAR_WINDOWS_1900) {
            //
            //    Fudge factor for the erroneous fact that the year 1900 is treated as a Leap Year in MS Excel
            //    This affects every date following 28th February 1900
            //
            $excel1900isLeapYear = true;
            if (($year == 1900) && ($month <= 2)) {
                $excel1900isLeapYear = false;
            }
            $myexcelBaseDate = 2415020;
        } else {
            $myexcelBaseDate = 2416481;
            $excel1900isLeapYear = false;
        }
 
        //    Julian base date Adjustment
        if ($month > 2) {
            $month -= 3;
        } else {
            $month += 9;
            --$year;
        }
 
        //    Calculate the Julian Date, then subtract the Excel base date (JD 2415020 = 31-Dec-1899 Giving Excel Date of 0)
        $century = (int) substr($year, 0, 2);
        $decade = (int) substr($year, 2, 2);
        $excelDate = floor((146097 * $century) / 4) + floor((1461 * $decade) / 4) + floor((153 * $month + 2) / 5) + $day + 1721119 - $myexcelBaseDate + $excel1900isLeapYear;
 
        $excelTime = (($hours * 3600) + ($minutes * 60) + $seconds) / 86400;
 
        return (float) $excelDate + $excelTime;
    }

◆ getDefaultOrLocalTimezone()

static PhpOffice\PhpSpreadsheet\Shared\Date::getDefaultOrLocalTimezone ( )

static

Return the Default timezone, or local timezone if default is not set.

Definition at line 128 of file Date.php.

                                                      : DateTimeZone
    {
        return self::$defaultTimeZone ?? new DateTimeZone(date_default_timezone_get());
    }

◆ getDefaultTimezone()

static PhpOffice\PhpSpreadsheet\Shared\Date::getDefaultTimezone ( )

static

Return the Default timezone, or UTC if default not set.

Definition at line 120 of file Date.php.

                                               : DateTimeZone
    {
        return self::$defaultTimeZone ?? new DateTimeZone('UTC');
    }

◆ getDefaultTimezoneOrNull()

static PhpOffice\PhpSpreadsheet\Shared\Date::getDefaultTimezoneOrNull ( )

static

Return the Default timezone even if null.

Definition at line 136 of file Date.php.

                                                     : ?DateTimeZone
    {
        return self::$defaultTimeZone;
    }

◆ getExcelCalendar()

static PhpOffice\PhpSpreadsheet\Shared\Date::getExcelCalendar ( )

static

Return the Excel calendar (Windows 1900 or Mac 1904).

Returns: int Excel base date (1900 or 1904)

Definition at line 92 of file Date.php.

    {
        return self::$excelCalendar;
    }

Referenced by PhpOffice\PhpSpreadsheet\Writer\Xls\Workbook\writeDateMode(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Workbook\writeWorkbookPr().

Here is the caller graph for this function:

◆ isDateTime()

static PhpOffice\PhpSpreadsheet\Shared\Date::isDateTime ( Cell $pCell )

static

Is a given cell a date/time?

Returns: bool

Definition at line 331 of file Date.php.

    {
        return is_numeric($pCell->getCalculatedValue()) &&
            self::isDateTimeFormat(
                $pCell->getWorksheet()->getStyle(
                    $pCell->getCoordinate()
                )->getNumberFormat()
            );
    }

References PhpOffice\PhpSpreadsheet\Cell\Cell\getCalculatedValue(), PhpOffice\PhpSpreadsheet\Cell\Cell\getCoordinate(), and PhpOffice\PhpSpreadsheet\Cell\Cell\getWorksheet().

Here is the call graph for this function:

◆ isDateTimeFormat()

static PhpOffice\PhpSpreadsheet\Shared\Date::isDateTimeFormat ( NumberFormat $pFormat )

static

Is a given number format a date/time?

Returns: bool

Definition at line 346 of file Date.php.

    {
        return self::isDateTimeFormatCode($pFormat->getFormatCode());
    }

References PhpOffice\PhpSpreadsheet\Style\NumberFormat\getFormatCode().

Here is the call graph for this function:

◆ isDateTimeFormatCode()

static PhpOffice\PhpSpreadsheet\Shared\Date::isDateTimeFormatCode ( $pFormatCode )

static

Is a given number format code a date/time?

Parameters

string $pFormatCode

Returns: bool

Definition at line 360 of file Date.php.

    {
        if (strtolower($pFormatCode) === strtolower(NumberFormat::FORMAT_GENERAL)) {
            //    "General" contains an epoch letter 'e', so we trap for it explicitly here (case-insensitive check)
            return false;
        }
        if (preg_match('/[0#]E[+-]0/i', $pFormatCode)) {
            //    Scientific format
            return false;
        }
 
        // Switch on formatcode
        switch ($pFormatCode) {
            //    Explicitly defined date formats
            case NumberFormat::FORMAT_DATE_YYYYMMDD:
            case NumberFormat::FORMAT_DATE_YYYYMMDD2:
            case NumberFormat::FORMAT_DATE_DDMMYYYY:
            case NumberFormat::FORMAT_DATE_DMYSLASH:
            case NumberFormat::FORMAT_DATE_DMYMINUS:
            case NumberFormat::FORMAT_DATE_DMMINUS:
            case NumberFormat::FORMAT_DATE_MYMINUS:
            case NumberFormat::FORMAT_DATE_DATETIME:
            case NumberFormat::FORMAT_DATE_TIME1:
            case NumberFormat::FORMAT_DATE_TIME2:
            case NumberFormat::FORMAT_DATE_TIME3:
            case NumberFormat::FORMAT_DATE_TIME4:
            case NumberFormat::FORMAT_DATE_TIME5:
            case NumberFormat::FORMAT_DATE_TIME6:
            case NumberFormat::FORMAT_DATE_TIME7:
            case NumberFormat::FORMAT_DATE_TIME8:
            case NumberFormat::FORMAT_DATE_YYYYMMDDSLASH:
            case NumberFormat::FORMAT_DATE_XLSX14:
            case NumberFormat::FORMAT_DATE_XLSX15:
            case NumberFormat::FORMAT_DATE_XLSX16:
            case NumberFormat::FORMAT_DATE_XLSX17:
            case NumberFormat::FORMAT_DATE_XLSX22:
                return true;
        }
 
        //    Typically number, currency or accounting (or occasionally fraction) formats
        if ((substr($pFormatCode, 0, 1) == '_') || (substr($pFormatCode, 0, 2) == '0 ')) {
            return false;
        }
        // Some "special formats" provided in German Excel versions were detected as date time value,
        // so filter them out here - "\C\H\-00000" (Switzerland) and "\D-00000" (Germany).
        if (\strpos($pFormatCode, '-00000') !== false) {
            return false;
        }
        // Try checking for any of the date formatting characters that don't appear within square braces
        if (preg_match('/(^|\])[^\[]*[' . self::$possibleDateFormatCharacters . ']/i', $pFormatCode)) {
            //    We might also have a format mask containing quoted strings...
            //        we don't want to test for any of our characters within the quoted blocks
            if (strpos($pFormatCode, '"') !== false) {
                $segMatcher = false;
                foreach (explode('"', $pFormatCode) as $subVal) {
                    //    Only test in alternate array entries (the non-quoted blocks)
                    if (
                        ($segMatcher = !$segMatcher) &&
                        (preg_match('/(^|\])[^\[]*[' . self::$possibleDateFormatCharacters . ']/i', $subVal))
                    ) {
                        return true;
                    }
                }
 
                return false;
            }
 
            return true;
        }
 
        // No date...
        return false;
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Gnumeric\Styles\readStyles().

Here is the caller graph for this function:

◆ monthStringToNumber()

static PhpOffice\PhpSpreadsheet\Shared\Date::monthStringToNumber ( $month )

static

Converts a month name (either a long or a short name) to a month number.

Parameters

string $month Month name or abbreviation

Returns: int|string Month number (1 - 12), or the original string argument if it isn't a valid month name

Definition at line 474 of file Date.php.

    {
        $monthIndex = 1;
        foreach (self::$monthNames as $shortMonthName => $longMonthName) {
            if (($month === $longMonthName) || ($month === $shortMonthName)) {
                return $monthIndex;
            }
            ++$monthIndex;
        }
 
        return $month;
    }

◆ PHPToExcel()

static PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel ( $dateValue )

static

Convert a date from PHP to an MS Excel serialized date/time value.

Parameters

mixed $dateValue Unix Timestamp or PHP DateTime object or a string

Returns: bool|float Excel date/time value or boolean FALSE on failure

Definition at line 231 of file Date.php.

    {
        if ((is_object($dateValue)) && ($dateValue instanceof DateTimeInterface)) {
            return self::dateTimeToExcel($dateValue);
        } elseif (is_numeric($dateValue)) {
            return self::timestampToExcel($dateValue);
        } elseif (is_string($dateValue)) {
            return self::stringToExcel($dateValue);
        }
 
        return false;
    }

◆ setDefaultTimezone()

static PhpOffice\PhpSpreadsheet\Shared\Date::setDefaultTimezone ( $timeZone )

static

Set the Default timezone to use for dates.

Parameters

null | DateTimeZone | string $timeZone The timezone to set for all Excel datetimestamp to PHP DateTime Object conversions

Returns: bool Success or failure

Definition at line 104 of file Date.php.

    {
        try {
            $timeZone = self::validateTimeZone($timeZone);
            self::$defaultTimeZone = $timeZone;
            $retval = true;
        } catch (PhpSpreadsheetException $e) {
            $retval = false;
        }
 
        return $retval;
    }

References $timeZone.

◆ setExcelCalendar()

static PhpOffice\PhpSpreadsheet\Shared\Date::setExcelCalendar ( $baseDate )

static

Set the Excel calendar (Windows 1900 or Mac 1904).

Parameters

int $baseDate Excel base date (1900 or 1904)

Returns: bool Success or failure

Definition at line 73 of file Date.php.

    {
        if (
            ($baseDate == self::CALENDAR_WINDOWS_1900) ||
            ($baseDate == self::CALENDAR_MAC_1904)
        ) {
            self::$excelCalendar = $baseDate;
 
            return true;
        }
 
        return false;
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Xls\readDateMode().

Here is the caller graph for this function:

◆ stringToExcel()

static PhpOffice\PhpSpreadsheet\Shared\Date::stringToExcel ( $dateValue )

static

Convert a date/time string to Excel time.

Parameters

string $dateValue Examples: '2009-12-31', '2009-12-31 15:59', '2009-12-31 15:59:10'

Returns: false|float Excel date/time serial value

Definition at line 441 of file Date.php.

    {
        if (strlen($dateValue) < 2) {
            return false;
        }
        if (!preg_match('/^(\d{1,4}[ \.\/\-][A-Z]{3,9}([ \.\/\-]\d{1,4})?|[A-Z]{3,9}[ \.\/\-]\d{1,4}([ \.\/\-]\d{1,4})?|\d{1,4}[ \.\/\-]\d{1,4}([ \.\/\-]\d{1,4})?)( \d{1,2}:\d{1,2}(:\d{1,2})?)?$/iu', $dateValue)) {
            return false;
        }
 
        $dateValueNew = DateTimeExcel\DateValue::fromString($dateValue);
 
        if ($dateValueNew === Functions::VALUE()) {
            return false;
        }
 
        if (strpos($dateValue, ':') !== false) {
            $timeValue = DateTimeExcel\TimeValue::fromString($dateValue);
            if ($timeValue === Functions::VALUE()) {
                return false;
            }
            $dateValueNew += $timeValue;
        }
 
        return $dateValueNew;
    }

References PhpOffice\PhpSpreadsheet\Calculation\Functions\VALUE().

Referenced by PhpOffice\PhpSpreadsheet\Cell\AdvancedValueBinder\bindValue().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ timestampToExcel()

static PhpOffice\PhpSpreadsheet\Shared\Date::timestampToExcel ( $dateValue )

static

Convert a Unix timestamp to an MS Excel serialized date/time value.

Parameters

int $dateValue Unix Timestamp

Returns: false|float MS Excel serialized date/time value

Definition at line 270 of file Date.php.

    {
        if (!is_numeric($dateValue)) {
            return false;
        }
 
        return self::dateTimeToExcel(new DateTime('@' . $dateValue));
    }

◆ validateTimeZone()

static PhpOffice\PhpSpreadsheet\Shared\Date::validateTimeZone ( $timeZone )

staticprivate

Validate a timezone.

Parameters

null | DateTimeZone | string $timeZone The timezone to validate, either as a timezone string or object

Returns: ?DateTimeZone The timezone as a timezone object

Definition at line 148 of file Date.php.

    {
        if ($timeZone instanceof DateTimeZone || $timeZone === null) {
            return $timeZone;
        }
        if (in_array($timeZone, DateTimeZone::listIdentifiers(DateTimeZone::ALL_WITH_BC))) {
            return new DateTimeZone($timeZone);
        }
 
        throw new PhpSpreadsheetException('Invalid timezone');
    }

References $timeZone.

Field Documentation

◆ $defaultTimeZone

PhpOffice\PhpSpreadsheet\Shared\Date::$defaultTimeZone

staticprotected

Definition at line 64 of file Date.php.

◆ $excelCalendar

PhpOffice\PhpSpreadsheet\Shared\Date::$excelCalendar = self::CALENDAR_WINDOWS_1900

staticprotected

Definition at line 57 of file Date.php.

◆ $monthNames

PhpOffice\PhpSpreadsheet\Shared\Date::$monthNames

static

Initial value:

= [
        'Jan' => 'January',
        'Feb' => 'February',
        'Mar' => 'March',
        'Apr' => 'April',
        'May' => 'May',
        'Jun' => 'June',
        'Jul' => 'July',
        'Aug' => 'August',
        'Sep' => 'September',
        'Oct' => 'October',
        'Nov' => 'November',
        'Dec' => 'December',
    ]

Definition at line 26 of file Date.php.

◆ $numberSuffixes

PhpOffice\PhpSpreadsheet\Shared\Date::$numberSuffixes

static

Initial value:

= [
        'st',
        'nd',
        'rd',
        'th',
    ]

Definition at line 44 of file Date.php.

◆ $possibleDateFormatCharacters

PhpOffice\PhpSpreadsheet\Shared\Date::$possibleDateFormatCharacters = 'eymdHs'

staticprivate

Definition at line 351 of file Date.php.

◆ CALENDAR_MAC_1904

const PhpOffice\PhpSpreadsheet\Shared\Date::CALENDAR_MAC_1904 = 1904

Definition at line 18 of file Date.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Xls\readDateMode(), PhpOffice\PhpSpreadsheet\Writer\Xls\Workbook\writeDateMode(), and PhpOffice\PhpSpreadsheet\Writer\Xlsx\Workbook\writeWorkbookPr().

◆ CALENDAR_WINDOWS_1900

const PhpOffice\PhpSpreadsheet\Shared\Date::CALENDAR_WINDOWS_1900 = 1900

constants

Definition at line 17 of file Date.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Xls\readDateMode().

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/Date.php

Static Public Member Functions

Data Fields

Static Public Attributes

Static Protected Attributes

Static Private Member Functions

Static Private Attributes

Detailed Description

Member Function Documentation

◆ dateTimeFromTimestamp()

◆ dateTimeToExcel()

◆ dayStringToNumber()

◆ excelToDateTimeObject()

◆ excelToTimestamp()

◆ formattedDateTimeFromTimestamp()

◆ formattedPHPToExcel()

◆ getDefaultOrLocalTimezone()

◆ getDefaultTimezone()

◆ getDefaultTimezoneOrNull()

◆ getExcelCalendar()

◆ isDateTime()

◆ isDateTimeFormat()

◆ isDateTimeFormatCode()

◆ monthStringToNumber()

◆ PHPToExcel()

◆ setDefaultTimezone()

◆ setExcelCalendar()

◆ stringToExcel()

◆ timestampToExcel()

◆ validateTimeZone()

Field Documentation

◆ $defaultTimeZone

◆ $excelCalendar

◆ $monthNames

◆ $numberSuffixes

◆ $possibleDateFormatCharacters

◆ CALENDAR_MAC_1904

◆ CALENDAR_WINDOWS_1900