PHP之 导入excel表格时，获取日期时间变成浮点数

读取到的时间 float(0.20833333333333)
原格式 15:00:00

代码

if (Request::isPost()) {$file_url = input('upfile');  // 本地上传文件地址// 读取文件内容$local_file_url = __dir__.'/../../../public'.$file_url;// $spreadsheet = new Spreadsheet();// $sheet = $spreadsheet->getActiveSheet();$inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($local_file_url);$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);$spreadsheet = $reader->load($local_file_url); //载入excel表格  // $spreadsheet = $reader->load('students.xlsx'); //载入excel表格$worksheet = $spreadsheet->getActiveSheet();$highestRow = $worksheet->getHighestRow(); // 总行数$highestColumn = $worksheet->getHighestColumn(); // 总列数$highestColumnIndex = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($highestColumn); // e.g. 5$lines = $highestRow - 1; // 行数if ($lines <= 0) {$this->error('Excel表格中没有数据');}// $sql = "INSERT INTO `tp_enroll` (`team_num`,`firing_time`,`member_num`) VALUES ";$new = [];for ($row = 1; $row <= $highestRow; ++$row) {$new[$row]['id'] = $worksheet->getCellByColumnAndRow(1, $row)->getValue(); //id$e_time = $worksheet->getCellByColumnAndRow(12, $row)->getValue();      // float(0.20833333333333)if(!empty($e_time) ){// $toTimestamp = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimestamp($e_time);  // 可以调用$toTimestamp = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimestampMy($e_time);   // 自定义的方法 调用的方法 可以获取到时间格式}else{$toTimestamp = 0;}$new[$row]['team_ok_time']= $toTimestamp;}

调用的方法 是我改写的

// 改的自定义方法
public static function excelToTimestampMy($excelTimestamp, $timeZone = null)
{// return (int) self::excelToDateTimeObjectMy($excelTimestamp, $timeZone)//     ->format('U');return self::excelToDateTimeObjectMy($excelTimestamp, $timeZone);
}public static function excelToDateTimeObjectMy($excelTimestamp, $timeZone = null)
{$timeZone = ($timeZone === null) ? self::getDefaultTimezone() : self::validateTimeZone($timeZone);if (Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {if ($excelTimestamp < 1 && self::$excelCalendar === self::CALENDAR_WINDOWS_1900) {// Unix timestamp base date$baseDate = new \DateTime('1970-01-01', $timeZone);} else {// MS Excel calendar base datesif (self::$excelCalendar == self::CALENDAR_WINDOWS_1900) {// Allow adjustment for 1900 Leap Year in MS Excel$baseDate = ($excelTimestamp < 60) ? new \DateTime('1899-12-31', $timeZone) : new \DateTime('1899-12-30', $timeZone);} else {$baseDate = new \DateTime('1904-01-01', $timeZone);}}} else {$baseDate = new \DateTime('1899-12-30', $timeZone);}$days = floor($excelTimestamp);return $excelTimestamp;// $partDay = $excelTimestamp ;// // $partDay = $excelTimestamp - $days;// $hours = floor($partDay * 24);// $partDay = $partDay * 24 - $hours;// $minutes = floor($partDay * 60);// $partDay = $partDay * 60 - $minutes;// $seconds = round($partDay * 60);// if ($days >= 0) {//     $days = '+' . $days;// }// $interval = $days . ' days';// return $baseDate->modify($interval)//     ->setTime((int) $hours, (int) $minutes, (int) $seconds);
}