Example of php reading excel date data _ PHP Tutorial

Example of php reading excel date data. Provides a read function: the code is as follows: excel date conversion function functionexcelTime ($ date, $ timefalse) {if (function_exists (GregorianToJD) {if (is_numeric ($ date )) {$ jd 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

The expiration code is as follows // excel date conversion function excelTime ($ date, $ time = false) {if (function_exists ('gregoriantojd ') {if (is_numeric ($ date )) {$ jd...