標籤:nbsp mat test image int top 運用 return png
excel時間
function exceltimtetophp($days,$time=false)
{
if(is_numeric($days))
{
//凱撒日計數,要把我們運用的從1970年開始的日期運用函數GregorianToJD(),轉換為凱撒日計數
$jd = GregorianToJD(1, 1, 1970);
$gregorian = JDToGregorian($jd+intval($days)-25569);
$gregorian = strtotime($gregorian);
$gregorian = date("Y/m/d",$gregorian);
// $myDate = explode(‘\\‘,$gregorian);
// $myDateStr = str_pad($myDate[2],4,‘0‘, STR_PAD_LEFT)."-".str_pad($myDate[0],2,‘0‘,STR_PAD_LEFT)."-".str_pad($myDate[1],2,‘0‘, STR_PAD_LEFT).($time?"00:00:00":‘\\‘);
return $gregorian;
}
return $time;
}
$val = ‘42930‘; //excel讀取的內容
$val = exceltimtetophp($val);
$preg_date = ‘/^(\d{4})\/(0\d{1}|[1-9]{1}||1[0-2])\/(0\d{1}|[1-9]{1}|[12]\d{1}|3[01])$/‘; //正則驗證時間:當時間為 2017/01/01或2017/1/1或2017/11/11這種的都通過
$status_date = trim($val);
echo $status_date;
preg_match($preg_date,$status_date,$matches);
var_dump($matches);
結果如下:
php讀取excel時間42930轉化為時間然後正則驗證時間是否通過