phpexcel 导入大数据

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;

$inputFileName = 'large_data.xlsx';

try {
    $reader = IOFactory::createReader('Xlsx');
    $spreadsheet = $reader->load($inputFileName);

    $worksheet = $spreadsheet->getActiveSheet();

    $highestRow = $worksheet->getHighestRow();
    $highestColumn = $worksheet->getHighestColumn();

    for ($row = 1; $row <= $highestRow; ++$row) {
        for ($column = 'A'; $column <= $highestColumn; ++$column) {
            $cellValue = $worksheet->getCell($column . $row)->getValue();
            // 处理单元格数据
            echo $cellValue . "\t";
        }
        echo "\n";
    }
} catch (ReaderException $e) {
    echo 'Error reading file: ' . $e->getMessage();
}