PhpSpreadsheet foreach循环遍历多个工作表

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

$spreadsheet = IOFactory::load('path/to/spreadsheet.xlsx');

$sheetNames = $spreadsheet->getSheetNames();
foreach ($sheetNames as $sheetName) {
    $worksheet = $spreadsheet->getSheetByName($sheetName);
    // 在这里进行工作表的操作
}

foreach ($sheetNames as $sheetName) {
    $worksheet = $spreadsheet->getSheetByName($sheetName);
    
    // 获取工作表的行数和列数
    $highestRow = $worksheet->getHighestRow();
    $highestColumn = $worksheet->getHighestColumn();
    
    // 遍历每一行
    for ($row = 1; $row <= $highestRow; $row++) {
        // 遍历每一列
        for ($col = 'A'; $col <= $highestColumn; $col++) {
            $cellValue = $worksheet->getCell($col.$row)->getValue();
            // 在这里处理单元格的值
        }
    }
}