laravel - 如何在 laravel Maatwebsite excel 中读取工作表名称

Question

我有一个包含多个工作表的 Excel 表，我想获取当前事件的工作表的名称

Answer 1

我认为 $event->getSheet()->getTitle() 应该可以工作。您也可以使用事件。

class HImport1 implements ToCollection, WithHeadingRow, WithEvents
{
    public $sheetNames;
    public $sheetData;
    
    public function __construct(){
        $this->sheetNames = [];
        $this->sheetData = [];
    }

    public function collection(Collection $collection)
    {
        $this->sheetData[] = $collection;
    }

    public function registerEvents(): array
    {
        return [
            BeforeSheet::class => function(BeforeSheet $event) {
                $this->sheetNames[] = $event->getSheet()->getTitle();
            } 
        ];
    }

}