thinkPHP+PHPExcel实现读取文件日期的方法(含时分秒)

vendor('phpexcel.phpexcel.iofactory');
$inputfilename = 'public/demo/demo.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<=$highestrow;$j++){
  for($k='a';$k<=$highestcolumn;$k++){
    if($k=='h'){//指定h列为时间所在列
      $temparray[] = gmdate("y-m-d h:i:s", phpexcel_shared_date::exceltophp($objphpexcel->getactivesheet()->getcell("$k$j")->getvalue()));
    }else{
       $temparray[] = $objphpexcel->getactivesheet()->getcell("$k$j")->getvalue();
    }
    echo "<pre>";
    print_r($temparray);
    unset($temparray);
    echo "</pre>";
  }
}