use Carbon\Carbon;
use PhpOffice\PhpSpreadsheet\Shared\Date;
public static function transformDateTime(string $value, string $format = 'Y-m-d')
{
try {
return Carbon::instance(Date::excelToDateTimeObject($value))->format($format);
} catch (\ErrorException $e) {
return Carbon::createFromFormat($format, $value);
}
}本作品採用《CC 協議》，轉載必須註明作者和本文連結