phpexcelreader导入

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

$inputFileName = './excelsample.xlsx';
try {
    $spreadsheet = IOFactory::load($inputFileName);
} catch (Exception $e) {
    echo 'Error: ' . $e->getMessage();
}

$worksheet = $spreadsheet->getActiveSheet();
foreach ($worksheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false); // 遍历所有单元格
    foreach ($cellIterator as $cell) {
        $value = $cell->getValue();
        if ($cell->getDataType() == 's') { // 字符串类型
            echo $value . "\t";
        } elseif ($cell->getDataType() == 'n') { // 数值类型
            echo $cell->getFormattedValue() . "\t";
        }
    }
    echo "\n";
}

ini_set('memory_limit', '256M'); // 增加内存限制