Example of php reading excel date data

Provides a READ function:

The Code is as follows:

// Excel date Conversion Function Function excelTime ($ date, $ time = false ){ If (function_exists ('gregoriantojd ')){ If (is_numeric ($ date )){ $ Jd = GregorianToJD (1, 1, 1970 ); $ Gregorian = JDToGregorian ($ jd + intval ($ date)-25569 ); $ Date = explode ('/', $ gregorian ); $ Date_str = str_pad ($ date [2], 4, '0', STR_PAD_LEFT) . "-". Str_pad ($ date [0], 2, '0', STR_PAD_LEFT) . "-". Str_pad ($ date [1], 2, '0', STR_PAD_LEFT) . ($ Time? "00:00:00 ":''); Return $ date_str; } } Else { $ Date = $ date> 25568? $ Date + 1: 25569; /* There was a bug if Converting date before 1-1-1970 (tstamp 0 )*/ $ Ofs = (70*365 + 17 + 2) * 86400; $ Date = date ("Y-m-d", ($ date * 86400)-$ ofs). ($ time? "00:00:00 ":''); } Return $ date; }

Articles you may be interested in

• Phpgeneration and reading excelfile (.csv) instance
• PHP reading excelfile (.csv) instance Introduction
• PHPExcel instance program for generating and reading Excel files
• PHP Excel reads excel files and imports them to the database
• Drupal reads the Excel file and imports the code to the mysql database.
• PHPExcel reads excel and imports mysql database code
• PHPExcel reads excel and imports the database
• POI reader EXCEL Implementation Program
• Use phpexcel to read the excel Code
• Phpexcel read excel document code