CALENDAR_WINDOWS_1900
CALENDAR_WINDOWS_1900 = 1900
constants
PHPExcel_Shared_Date
Copyright (c) 2006 - 2015 PHPExcel
This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
ExcelToPHP( $dateValue, boolean $adjustToTimezone = false, $timezone = null)
Convert a date from Excel to PHP
@param integer $dateValue Excel date/time value
| $dateValue | ||
| boolean | $adjustToTimezone | Flag indicating whether $dateValue should be treated as a UST timestamp, or adjusted to UST @param string $timezone The timezone for finding the adjustment from UST @return integer PHP serialized date/time |
| $timezone |
PHPToExcel( $dateValue, boolean $adjustToTimezone = false, $timezone = null)
Convert a date from PHP to Excel
@param mixed $dateValue PHP serialized date/time or date object
| $dateValue | ||
| boolean | $adjustToTimezone | Flag indicating whether $dateValue should be treated as a UST timestamp, or adjusted to UST @param string $timezone The timezone for finding the adjustment from UST @return mixed Excel date/time value or boolean FALSE on failure |
| $timezone |
FormattedPHPToExcel(integer $year, integer $month, integer $day, integer $hours, integer $minutes, integer $seconds) : integer
FormattedPHPToExcel
| integer | $year | |
| integer | $month | |
| integer | $day | |
| integer | $hours | |
| integer | $minutes | |
| integer | $seconds |
Excel date/time value
isDateTime(\PHPExcel_Cell $pCell) : boolean
Is a given cell a date/time?
| \PHPExcel_Cell | $pCell |
isDateTimeFormat(\PHPExcel_Style_NumberFormat $pFormat) : boolean
Is a given number format a date/time?
| \PHPExcel_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