Time when phpExcel accurately reads an excel table

PhpExcel correctly reads the excel table and uses phpExcel to read the excel file. The Read TIME column contains 5 digits, not the desired time (I don't know why ), after searching an excelTime function on the Internet, you can correctly convert the time Brand website construction: http: // ww phpExcel correct read excel table time
Using phpExcel to read an excel file, the Read TIME column contains 5 digits, not the desired time (I don't know why). I found an excelTime function on the Internet to convert the time correctly.
Brand Construction: http://www.ucantech.com/

Php code

Error_reporting (E_ALL );
Date_default_timezone_set ('Asia/Shanghai ');
/** PHPExcel_IOFactory */
Require_once '../Classes/PHPExcel/IOFactory. php ';
$ InputFileName = '6081076641077444758.xls ';
$ ObjReader = new PHPExcel_Reader_Excel5 ();
$ ObjPHPExcel = $ objReader-> load ($ inputFileName );
$ Sheet = $ objPHPExcel-> getSheet (0 );
$ HighestRow = $ sheet-> getHighestRow (); // gets the total number of rows.
$ HighestColumn = $ sheet-> getHighestColumn (); // gets the total number of columns
$ TempArray = array ();
For ($ j = 2; $ j <= $ highestRow; $ j ++ ){
For ($ k = 'a'; $ k <= $ highestColumn; $ k ++ ){
If ($ k = 'M' | $ k = 'O') // The M column and the O column are time
$ TempArray [] = excelTime ($ objPHPExcel-> getActiveSheet ()-> getCell ("$ k $ j")-> getValue ());
Else
$ TempArray [] = $ objPHPExcel-> getActiveSheet ()-> getCell ("$ k $ j")-> getValue ();
}
Print_r ($ tempArray );
Unset ($ tempArray );
}

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;
} (Fblww-0112)