PHPExcel_Shared
[ class tree: PHPExcel_Shared ] [ index: PHPExcel_Shared ] [ all elements ]
Packages:
PHPExcel
com-tecnick-tcpdf
JAMA
Math_Stats
PHPExcel_CachedObjectStorage
PHPExcel_Calculation
PHPExcel_Cell
PHPExcel_Reader
PHPExcel_Reader_Excel5
PHPExcel_Reader_Excel2007
PHPExcel_RichText
PHPExcel_Settings
PHPExcel_Shared
PHPExcel_Shared_Best_Fit
PHPExcel_Shared_Escher
PHPExcel_Shared_OLE
PHPExcel_Shared_ZipArchive
PHPExcel_Style
PHPExcel_Worksheet
PHPExcel_Worksheet_Drawing
PHPExcel_Writer
PHPExcel_Writer_Excel5
PHPExcel_Writer_Excel2007


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

Classes:
PHPExcel_Shared_CodePage
PHPExcel_Shared_Date
PHPExcel_Shared_Drawing
PHPExcel_Shared_Excel5
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 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
    • 


        




Variables






Constants






Methods
























Class Details



[line 37]

PHPExcel_Shared_Date





Tags:





  

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










[ Top ]







Class Variables



	
	

	
static $dateTimeObjectType =  'DateTime'

	
[line 45]

  



Tags:





  

    access:  public
  






  

	

  

    

      Type:  
      mixed
    

      

	



	
[ Top ]










Class Methods



  

	
	
static method ExcelToPHP [line 80]

	

    

    

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

	

    

    

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

	

    

    

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

	

    

    

		static integer getExcelCalendar(
)
    

    


	
		Return the Excel calendar (Windows 1900 or Mac 1904)





Tags:





  

    return:  Excel base date
  

  

    access:  public
  









	
        
[ Top ]

  

  

	
	
static method isDateTime [line 207]

	

    

    

		static boolean isDateTime(

$pCell)
    

    


	
		Is a given cell a date/time?





Tags:





  

    access:  public
  









	
        
Parameters:

    

    

          

        PHPExcel_Cell  
        $pCell  
        
      

        

    


        
[ Top ]

  

  

	
	
static method isDateTimeFormat [line 218]

	

    

    

		static boolean isDateTimeFormat(

$pFormat)
    

    


	
		Is a given number format a date/time?





Tags:





  

    access:  public
  









	
        
Parameters:

    

    

          

        PHPExcel_Style_NumberFormat  
        $pFormat  
        
      

        

    


        
[ Top ]

  

  

	
	
static method isDateTimeFormatCode [line 231]

	

    

    

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

	

    

    

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

	

    

    

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

	

    

    

		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 Constants



	
	

	
CALENDAR_MAC_1904 =  1904

	
[line 41]

  
  

	
[ Top ]


	
	

	
CALENDAR_WINDOWS_1900 =  1900

	
[line 40]

  constants


  

	
[ Top ]






        

		    

		    Documentation generated on Sun, 27 Feb 2011 16:29:22 -0800 by phpDocumentor 1.4.3