在PhpSpreadsheet中读取多个文件

use PhpOffice\PhpSpreadsheet\IOFactory;

// 文件路径数组
$files = [
    'path/to/file1.xlsx',
    'path/to/file2.xlsx',
    'path/to/file3.xlsx'
];

// 创建一个新的工作簿
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

// 循环遍历文件路径数组，逐个读取文件并合并到工作簿中
foreach ($files as $file) {
    $reader = IOFactory::createReaderForFile($file);
    $reader->setReadDataOnly(true);
    $worksheet = $reader->load($file);
    $spreadsheet->addSheet($worksheet->getActiveSheet());
}

// 设置活动表单为第一个工作表
$spreadsheet->setActiveSheetIndex(0);

// 获取合并后的工作簿的数据
$data = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

// 打印数据
foreach ($data as $row) {
    foreach ($row as $cell) {
        echo $cell . "\t";
    }
    echo "\n";
}