Docs For Class PHPExcel_Shared

static $dateTimeObjectType = 'DateTime'

[line 78]

Tags:

access:

public

Type:

mixed

[ Top ]

static $_monthNames = array(   'Jan' => 'January',
                              'Feb' => 'February',
                              'Mar' => 'March',
                              'Apr' => 'April',
                              'May' => 'May',
                              'Jun' => 'June',
                              'Jul' => 'July',
                              'Aug' => 'August',
                              'Sep' => 'September',
                              'Oct' => 'October',
                              'Nov' => 'November',
                              'Dec' => 'December'
                             )

[line 50]

Tags:

access:

public

Type:

mixed

[ Top ]

static method ExcelToPHP [line 113]

static long ExcelToPHP(
[long
$dateValue = 0])

Convert a date from Excel to PHP

Tags:

return:	PHP serialized date/time
access:	public

Parameters:

long

$dateValue

Excel date/time value

[ Top ]

static method ExcelToPHPObject [line 149]

static long ExcelToPHPObject(
[long
$dateValue = 0])

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

Tags:

return:	PHP date/time object
access:	public

Parameters:

long

$dateValue

Excel date/time value

[ Top ]

static method FormattedPHPToExcel [line 201]

static long FormattedPHPToExcel(
long
$year, long
$month, long
$day, [long
$hours = 0], [long
$minutes = 0], [long
$seconds = 0])

FormattedPHPToExcel

Tags:

return:	Excel date/time value
access:	public

Parameters:

long	$year
long	$month
long	$day
long	$hours
long	$minutes
long	$seconds

[ Top ]

static method getExcelCalendar [line 102]

static integer getExcelCalendar(
)

Return the Excel calendar (Windows 1900 or Mac 1904)

Tags:

return:	Excel base date
access:	public

[ Top ]

static method isDateTime [line 240]

static boolean isDateTime(
PHPExcel_Cell
$pCell)

Is a given cell a date/time?

Tags:

access:

public

Parameters:

PHPExcel_Cell

$pCell

[ Top ]

static method isDateTimeFormat [line 255]

static boolean isDateTimeFormat(
PHPExcel_Style_NumberFormat
$pFormat)

Is a given number format a date/time?

Tags:

access:

public

Parameters:

PHPExcel_Style_NumberFormat

$pFormat

[ Top ]

static method isDateTimeFormatCode [line 268]

static boolean isDateTimeFormatCode(
[string
$pFormatCode = ''])

Is a given number format code a date/time?

Tags:

access:

public

Parameters:

string

$pFormatCode

[ Top ]

static method PHPToExcel [line 171]

static mixed PHPToExcel(
[mixed
$dateValue = 0])

Convert a date from PHP to Excel

Tags:

return:	Excel date/time value or boolean FALSE on failure
access:	public

Parameters:

mixed

$dateValue

PHP serialized date/time or date object

[ Top ]

static method setExcelCalendar [line 87]

static boolean setExcelCalendar(
integer
$baseDate)

Set the Excel calendar (Windows 1900 or Mac 1904)

Tags:

return:	Success or failure
access:	public

Parameters:

integer

$baseDate

Excel base date

[ Top ]

static method stringToExcel [line 332]

static float|FALSE stringToExcel(
[string
$dateValue = ''])

Convert a date/time string to Excel time

Tags:

return:	Excel date/time serial value
access:	public

Parameters:

string

$dateValue

Examples: '2009-12-31', '2009-12-31 15:59', '2009-12-31 15:59:10'

[ Top ]

Class: PHPExcel_Shared_Date

Class Overview

Author(s):

Copyright:

Variables

Constants

Methods

Class Details

Tags:

Class Variables

static $dateTimeObjectType = 'DateTime'

Tags:

static $_monthNames = array( 'Jan' => 'January', 'Feb' => 'February', 'Mar' => 'March', 'Apr' => 'April', 'May' => 'May', 'Jun' => 'June', 'Jul' => 'July', 'Aug' => 'August', 'Sep' => 'September', 'Oct' => 'October', 'Nov' => 'November', 'Dec' => 'December' )

Tags:

Class Methods

static method ExcelToPHP [line 113]

Tags:

Parameters:

static method ExcelToPHPObject [line 149]

Tags:

Parameters:

static method FormattedPHPToExcel [line 201]

Tags:

Parameters:

static method getExcelCalendar [line 102]

Tags:

static method isDateTime [line 240]

Tags:

Parameters:

static method isDateTimeFormat [line 255]

Tags:

Parameters:

static method isDateTimeFormatCode [line 268]

Tags:

Parameters:

static method PHPToExcel [line 171]

Tags:

Parameters:

static method setExcelCalendar [line 87]

Tags:

Parameters:

static method stringToExcel [line 332]

Tags:

Parameters:

Class Constants

CALENDAR_MAC_1904 = 1904

CALENDAR_WINDOWS_1900 = 1900

static $_monthNames = array( 'Jan' => 'January',
'Feb' => 'February',
'Mar' => 'March',
'Apr' => 'April',
'May' => 'May',
'Jun' => 'June',
'Jul' => 'July',
'Aug' => 'August',
'Sep' => 'September',
'Oct' => 'October',
'Nov' => 'November',
'Dec' => 'December'
)