Lyndon – PHP攻城师

excel里面时间是从1900-1-1开始以天计算，比如1900-1-1是1，1970-1-1是25569.

当用phpexcel或其他excel类把日期从excel中读取出来后，可用下面的函数转成成2009-1-1格式的时间。

echo exceltimtetophp(39899);   //2009-3-27

function exceltimtetophp($days,$time=false)
{
if(is_numeric($days))
{
$jd = GregorianToJD(1, 1, 1970);
$gregorian = JDToGregorian($jd+intval($days)-25569);
$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 $myDateStr;
}
return $time;
}