How to get workbook/file name in the import class?

[dzymail]

Hi, I have an upload form to import Excel file data into the database,
I using registerEvents() for register events then $event->getSheet()->getTitle() get sheet name.
how can I get the workbook/file name?
thanks!

[patrickbrouwers]

You can use the beforeimport event and then call getDelegate on the reader

$event->reader->getDelegate()->getProperties()->getTitle()

[dzymail]

thanks for the help. now i got error:
Undefined property: Maatwebsite\Excel\Events\BeforeSheet::$reader
or this error:
Call to a member function getProperties() on null

here is the code.

class XlrawdataImport implements ToCollection, WithCalculatedFormulas, WithValidation, WithEvents, WithChunkReading
......
......
public function registerEvents(): array
    {
        return [
            BeforeImport::class => function(BeforeImport $event) {
                // $this->workBookName = $event->reader->getDelegate()->getProperties()->getTitle();
                // got error: Call to a member function getProperties() on null.
            },
            BeforeSheet::class => function(BeforeSheet $event) {
                $this->currSheetName = $event->getSheet()->getTitle(); // working.
                $this->workBookName = $event->reader->getDelegate()->getProperties()->getTitle(); // NOT working. Undefined property: Maatwebsite\Excel\Events\BeforeSheet::$reader
            }
        ];
    }

[dzymail]

after deleting WithChunkReading from class, BeforeImport event errors are gone. but the file name is "Untitled Spreadsheet" which is not correct.

[patrickbrouwers]

Yeah probably with chunkreading this data is not available to minimize the memory impact as much as is possible. You can always read out the spreadsheet directly with phpspreadsheet to get the information before you trigger the actual import.