PHPXRef 0.7.1 : Unnamed Project : Detail view of Date.php

Class: PHPExcel_Shared_Date - X-Ref

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

setExcelCalendar($baseDate) X-Ref

Set the Excel calendar (Windows 1900 or Mac 1904)

param: integer $baseDate Excel base date (1900 or 1904)
return: boolean Success or failure

getExcelCalendar() X-Ref

Return the Excel calendar (Windows 1900 or Mac 1904)

return: integer Excel base date (1900 or 1904)

ExcelToPHP($dateValue = 0, $adjustToTimezone = false, $timezone = null) X-Ref

Convert a date from Excel to PHP

param: integer        $dateValue            Excel date/time value
param: boolean        $adjustToTimezone    Flag indicating whether $dateValue should be treated as
param: string         $timezone            The timezone for finding the adjustment from UST
return: integer        PHP serialized date/time

ExcelToPHPObject($dateValue = 0) X-Ref

Convert a date from Excel to a PHP Date/Time object

param: integer $dateValue Excel date/time value
return: DateTime PHP date/time object

PHPToExcel($dateValue = 0, $adjustToTimezone = false, $timezone = null) X-Ref

Convert a date from PHP to Excel

param: mixed        $dateValue            PHP serialized date/time or date object
param: boolean        $adjustToTimezone    Flag indicating whether $dateValue should be treated as
param: string         $timezone            The timezone for finding the adjustment from UST
return: mixed        Excel date/time value

FormattedPHPToExcel($year, $month, $day, $hours = 0, $minutes = 0, $seconds = 0) X-Ref

FormattedPHPToExcel

param: integer    $year
param: integer    $month
param: integer    $day
param: integer    $hours
param: integer    $minutes
param: integer    $seconds
return: integer    Excel date/time value

isDateTime(PHPExcel_Cell $pCell) X-Ref

Is a given cell a date/time?

param: PHPExcel_Cell $pCell
return: boolean

isDateTimeFormat(PHPExcel_Style_NumberFormat $pFormat) X-Ref

Is a given number format a date/time?

param: PHPExcel_Style_NumberFormat $pFormat
return: boolean

isDateTimeFormatCode($pFormatCode = '') X-Ref

Is a given number format code a date/time?

param: string $pFormatCode
return: boolean

stringToExcel($dateValue = '') X-Ref

Convert a date/time string to Excel time

param: string $dateValue Examples: '2009-12-31', '2009-12-31 15:59', '2009-12-31 15:59:10'
return: float|FALSE Excel date/time serial value

monthStringToNumber($month) X-Ref

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

param: string $month Month name or abbreviation
return: integer|string Month number (1 - 12), or the original string argument if it isn't a valid month name

dayStringToNumber($day) X-Ref

Strips an ordinal froma numeric value

param: string $day Day number with an ordinal
return: integer|string The integer value with any ordinal stripped, or the original string argument if it isn't a valid numeric

File Size:	409 lines (15 kb)
Included or required:	0 times
Referenced:	0 times
Includes or requires:	0 files

PHP Cross Reference of Unnamed Project

/lib/phpexcel/PHPExcel/Shared/ -> Date.php (summary)

Defines 1 class