PhpSpreadsheet foreach 循环遍历多个工作表

使用PhpSpreadsheet库可以方便地处理Excel文件，并且可以通过foreach循环遍历多个工作表。在本文中，我们将介绍如何使用PhpSpreadsheet库来实现这一功能，并提供一个案例代码来帮助读者更好地理解。

bash
composer require phpoffice/phpspreadsheet

php
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
$spreadsheet = new Spreadsheet();

php
$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load('path/to/excel/file.xlsx');

php
$sheetNames = $spreadsheet->getSheetNames();
foreach ($sheetNames as $sheetName) {
    // 在这里进行操作
}

php
$worksheet = $spreadsheet->getSheetByName($sheetName);

php
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();
for ($row = 1; $row <= $highestRow; $row++) {
    for ($column = 'A'; $column <= $highestColumn; $column++) {
        $cellValue = $worksheet->getCell($column . $row)->getValue();
        
        // 在这里处理单元格的值
    }
}

php
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
$spreadsheet = new Spreadsheet();
$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load('path/to/excel/file.xlsx');
$sheetNames = $spreadsheet->getSheetNames();
foreach ($sheetNames as $sheetName) {
    $worksheet = $spreadsheet->getSheetByName($sheetName);
    
    $highestRow = $worksheet->getHighestRow();
    $highestColumn = $worksheet->getHighestColumn();
    for ($row = 1; $row <= $highestRow; $row++) {
        for ($column = 'A'; $column <= $highestColumn; $column++) {
            $cellValue = $worksheet->getCell($column . $row)->getValue();
            
            // 在这里处理单元格的值
        }
    }
}