thinkphp 读取excel

<?php
namespace app\index\controller;

use think\Controller;
use PhpOffice\PhpSpreadsheet\IOFactory;

class Index extends Controller
{
    public function readExcel()
    {
        $file = './excels/example.xlsx'; // Excel 文件路径
        $spreadsheet = IOFactory::load($file);
        $worksheet = $spreadsheet->getActiveSheet();

        foreach ($worksheet->getRowIterator() as $row) {
            $cellIterator = $row->getCellIterator();
            $cellIterator->setIterateOnlyExistingCells(false); // 遍历所有单元格

            foreach ($cellIterator as $cell) {
                echo $cell->getValue() . "\t";
            }
            echo "\n";
        }
    }
}

$spreadsheet = IOFactory::load($file, 'Xlsx');

use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

$reader = new Xlsx();
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($file);

foreach ($spreadsheet->getActiveSheet()->getRowIterator() as $row) {
    // 处理每一行数据
}