PHPExcel_Shared
[ class tree: PHPExcel_Shared ] [ index: PHPExcel_Shared ] [ all elements ]
Packages:
default
JAMA
Math_Stats
PHPExcel
PHPExcel_Calculation
PHPExcel_Cell
PHPExcel_Reader
PHPExcel_Reader_Excel5
PHPExcel_RichText
PHPExcel_Shared
PHPExcel_Shared_Escher
PHPExcel_Shared_OLE
PHPExcel_Style
PHPExcel_Worksheet
PHPExcel_Worksheet_Drawing
PHPExcel_Writer
PHPExcel_Writer_Excel5
PHPExcel_Writer_Excel2007


Files:
Date.php
Drawing.php
File.php
Font.php
OLERead.php
PasswordHasher.php
PDF.php
String.php
XMLWriter.php
ZipStreamWrapper.php

Classes:
PHPExcel_Shared_Date
PHPExcel_Shared_Drawing
PHPExcel_Shared_File
PHPExcel_Shared_Font
PHPExcel_Shared_OLERead
PHPExcel_Shared_PasswordHasher
PHPExcel_Shared_String
PHPExcel_Shared_XMLWriter
PHPExcel_Shared_ZipStreamWrapper

Class: PHPExcel_Shared_Date

Source Location: /PHPExcel/Shared/Date.php

Class Overview




PHPExcel_Shared_Date




Author(s):


    
        





      
  


Copyright:


    
  
  • Copyright (c) 2006 - 2009 PHPExcel (http://www.codeplex.com/PHPExcel)
    • 


        




Variables






Constants






Methods
























Class Details



[line 44]

PHPExcel_Shared_Date

PHPExcel_Shared_Date





Tags:





  

    copyright:  Copyright (c) 2006 - 2009 PHPExcel (http://www.codeplex.com/PHPExcel)
  










[ Top ]







Class Variables



	
	

	
static $dateTimeObjectType =  'DateTime'

	
[line 52]

  



Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]


	
	

	
static $ExcelBaseDate =  self::CALENDAR_WINDOWS_1900

	
[line 50]

  



Tags:





  

    access:  private
  






  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]


	
	

	
static $possibleCharacters = array('y', 'm', 'd', 'H', 'i', 's')

	
[line 225]

  



Tags:





  

    access:  private
  






  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]










Class Methods



  

	
	
static method ExcelToPHP [line 87]

	

    

    

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

    


	
		Convert a date from Excel to PHP

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 120]

	

    

    

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

    


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

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 170]

	

    

    

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

    


	
		FormattedPHPToExcel

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 76]

	

    

    

		static integer getExcelCalendar(
)
    

    


	
		Return the Excel calendar (Windows 1900 or Mac 1904)

Return the Excel calendar (Windows 1900 or Mac 1904)





Tags:





  

    return:  Excel base date
  

  

    access:  public
  









	
        
[ Top ]

  

  

	
	
static method isDateTime [line 209]

	

    

    

		static boolean isDateTime(

$pCell)
    

    


	
		Is a given cell a date/time?

Is a given cell a date/time?





Tags:





  

    access:  public
  









	
        
Parameters:

    

    

          

        PHPExcel_Cell  
        $pCell  
        
      

        

    


        
[ Top ]

  

  

	
	
static method isDateTimeFormat [line 220]

	

    

    

		static boolean isDateTimeFormat(

$pFormat)
    

    


	
		Is a given number format a date/time?

Is a given number format a date/time?





Tags:





  

    access:  public
  









	
        
Parameters:

    

    

          

        PHPExcel_Style_NumberFormat  
        $pFormat  
        
      

        

    


        
[ Top ]

  

  

	
	
static method isDateTimeFormatCode [line 233]

	

    

    

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

    


	
		Is a given number format code a date/time?

Is a given number format code a date/time?





Tags:





  

    access:  public
  









	
        
Parameters:

    

    

          

        string  
        $pFormatCode  
        
      

        

    


        
[ Top ]

  

  

	
	
static method PHPToExcel [line 140]

	

    

    

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

    


	
		Convert a date from PHP to Excel

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 61]

	

    

    

		static boolean setExcelCalendar(
integer
$baseDate)
    

    


	
		Set the Excel calendar (Windows 1900 or Mac 1904)

Set the Excel calendar (Windows 1900 or Mac 1904)





Tags:





  

    return:  Success or failure
  

  

    access:  public
  









	
        
Parameters:

    

    

          

        integer  
        $baseDate  
        Excel base date
      

        

    


        
[ Top ]

  










Class Constants



	
	

	
CALENDAR_MAC_1904 =  1904

	
[line 48]

  
  

	
[ Top ]


	
	

	
CALENDAR_WINDOWS_1900 =  1900

	
[line 47]

  constants

constants


  

	
[ Top ]






        

		    

		    Documentation generated on Mon, 05 Jan 2009 20:36:47 +0100 by phpDocumentor 1.4.1