利用phpexcel读取excel文件，读取出来的时间列出现5位数字，并不是想要的时间(不知道为啥)，在网上搜了一个exceltime的函数可以正确转化时间
品牌网站建设：http://www.ucantech.com/
php代码
error_reporting(e_all);
date_default_timezone_set('asia/shanghai');
/** phpexcel_iofactory */
require_once '../classes/phpexcel/iofactory.php';
$inputfilename = '6081076641077444758.xls';
$objreader = new phpexcel_reader_excel5();
$objphpexcel = $objreader->load($inputfilename);
$sheet = $objphpexcel->getsheet(0);
$highestrow = $sheet->gethighestrow(); // 取得总行数
$highestcolumn = $sheet->gethighestcolumn(); // 取得总列数
$temparray = array();
for($j=2;$j for($k='a';$k if($k=='m'||$k=='o') //m列和o列是时间
$temparray[] = exceltime($objphpexcel->getactivesheet()->getcell($k$j)->getvalue());
else
$temparray[] = $objphpexcel->getactivesheet()->getcell($k$j)->getvalue();
}
print_r($temparray);
unset($temparray);
}
function exceltime($date, $time = false) {
if(function_exists('gregoriantojd')){
if (is_numeric( $date )) {
$jd = gregoriantojd( 1, 1, 1970 );
$gregorian = jdtogregorian( $jd + intval ( $date ) - 25569 );
$date = explode( '/', $gregorian );
$date_str = str_pad( $date [2], 4, '0', str_pad_left )
.-. str_pad( $date [0], 2, '0', str_pad_left )
.-. str_pad( $date [1], 2, '0', str_pad_left )
. ($time ? 00:00:00 : '');
return $date_str;
}
}else{
$date=$date>25568?$date+1:25569;
/*there was a bug if converting date before 1-1-1970 (tstamp 0)*/
$ofs=(70 * 365 + 17+2) * 86400;
$date = date(y-m-d,($date * 86400) - $ofs).($time ? 00:00:00 : '');
}
return $date;
} (fblww-0112)