PHPExcel日期格式

require_once 'PHPExcel/IOFactory.php';

$inputFileName = 'example.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

$worksheet = $objPHPExcel->getActiveSheet();
$cell = $worksheet->getCell('A1');

if ($cell->isDate()) {
    $dateValue = $cell->getValue();
    $date = PHPExcel_Shared_Date::ExcelToPHPObject($dateValue);
    echo $date->format('Y-m-d');
}

require_once 'PHPExcel/IOFactory.php';

$inputFileName = 'example.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

$worksheet = $objPHPExcel->getActiveSheet();
$cell = $worksheet->getCell('A1');

$date = new DateTime();
$dateValue = $date->format('U');

$cell->setValueExplicit($dateValue, PHPExcel_Cell_DataType::TYPE_NUMERIC);
$cell->getStyle()->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX15);

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('output.xlsx');