phpexcel 日期 时分秒_phpEXCEL读取时间问题

public static function getExcelDate($datestr){

//PHPExcel_Shared_Date::ExcelToPHP

if($datestr=='' || $datestr=='0000-00-00'){

$datestr = "0000-00-00";

}else{

$datestr =

PHPExcel_Shared_Date::ExcelToPHP($datestr);$datestr =

date('Y-m-d',$datestr);

}

return $datestr;

}

public static function excelTime($date, $time = false)

{

return self::getExcelDate($date);

}

$borndate =

PHPExcel_Shared_Date::ExcelToPHP($rsexcel[$i][5]);

$borndate = date('Y-m-d',$borndate);

读取到对应的EXCEL内容后，用PHPEXCEL自带的静态函数处理下即可，以下几个函数都有些问题

https://www.cnblogs.com/cocowool/p/6074430.html

PHPexcel读取时间往往是5位数字，用以下函数转换下即可。

public static function excelTime($date, $time = f