用PHP读取xls文件的最简单方法

composer require phpoffice/phpspreadsheet

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

use PhpOffice\PhpSpreadsheet\IOFactory;

// 文件路径
$filePath = 'path/to/your/file.xls';

try {
    // 使用IOFactory创建一个读取器
    $reader = IOFactory::createReader('Xls');
    
    // 加载电子表格文档
    $spreadsheet = $reader->load($filePath);
    
    // 获取活动工作表
    $worksheet = $spreadsheet->getActiveSheet();
    
    // 遍历所有行和列
    foreach ($worksheet->getRowIterator() as $row) {
        $cellIterator = $row->getCellIterator();
        $cellIterator->setIterateOnlyExistingCells(false); // 迭代所有单元格，即使它们没有值
        
        foreach ($cellIterator as $cell) {
            echo $cell->getValue() . "\t";
        }
        echo "\n";
    }
} catch (\Exception $e) {
    echo 'Error: ', $e->getMessage(), "\n";
}

ini_set('memory_limit', '512M'); // 设置内存限制