>[info] PHPExcel导入日期格式问题 ~~~ /** * excel导入日期格式问题 * * @param $date * @return false|string|null */ public function get_date_by_excel($date){ if (!$date || $date == '0000-00-00') return null; $unix_time = \PHPExcel_Shared_Date::ExcelToPHP($date); return gmdate('Y-m-d',$unix_time); } ~~~ **示例：** ~~~ // 出生日期 $dataArr['birthday'] = $this->get_date_by_excel($objPHPExcel->getActiveSheet()->getCell("D" . $row)->getValue()); ~~~