如何在PHP中使用IReadFilter读取PhpSpreadsheet中的单元格？

composer require phpoffice/phpspreadsheet

use PhpOffice\PhpSpreadsheet\Reader\IReadFilter;

class CustomReadFilter implements IReadFilter
{
    private $startRow = 1;
    private $endRow = 10;
    private $columns = [];

    public function setRows($startRow, $endRow)
    {
        $this->startRow = $startRow;
        $this->endRow = $endRow;
    }

    public function setColumns($columns)
    {
        $this->columns = $columns;
    }

    public function readCell($column, $row, $worksheetName = '')
    {
        if ($row >= $this->startRow && $row <= $this->endRow) {
            if (empty($this->columns) || in_array($column, $this->columns)) {
                return true;
            }
        }
        return false;
    }
}

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

// 读取Excel文件
$reader = new Xlsx();
$spreadsheet = $reader->load('path/to/your/excel_file.xlsx');

// 设置要读取的行范围和列
$filter = new CustomReadFilter();
$filter->setRows(2, 10); // 设置要读取的行范围，例如从第2行到第10行
$filter->setColumns(['A', 'C']); // 设置要读取的列，例如A列和C列

// 应用筛选器并读取指定范围的单元格数据
$worksheet = $spreadsheet->getActiveSheet();
$worksheet->setReadFilter($filter);
$data = $worksheet->toArray();

// 打印读取到的数据
foreach ($data as $row) {
    foreach ($row as $cell) {
        echo $cell . ' ';
    }
    echo '<br>';
}