php导入excel 日期

<?php
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

// 读取 Excel 文件
$inputFileName = 'example.xlsx';
$spreadsheet = IOFactory::load($inputFileName);
$worksheet = $spreadsheet->getActiveSheet();

// 遍历日期数据
foreach ($worksheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false); // 遍历所有单元格，包括空单元格

    foreach ($cellIterator as $cell) {
        if ($cell->isDate()) {
            // 获取 Excel 中的日期值
            $dateValue = $cell->getValue();
            // 转换为 PHP 日期时间
            $dateTime = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($dateValue);
            echo $dateTime->format('Y-m-d') . PHP_EOL;
        }
    }
}
?>

<?php
$inputFileName = 'example.csv';

if (($handle = fopen($inputFileName, "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        for ($c=0; $c < $num; $c++) {
            if (strtotime($data[$c])) {
                // 转换为 PHP 日期时间
                $dateTime = date('Y-m-d', strtotime($data[$c]));
                echo $dateTime . PHP_EOL;
            }
        }
    }
    fclose($handle);
}
?>