Getting Sheet Title Error

[melvin0008]

Excel::load(public_path().$destinationPath.'/'.$name, function($reader) {
          // reader methods
          $workbookTitle = $reader->getTitle();
          Log::info($workbookTitle);
          foreach($reader as $sheet)
            {
                // get sheet title
                 $sheetTitle = $sheet->getTitle();
                 Log::info($sheetTitle);
            }
        });

Getting an error for get title.

 production.ERROR: exception 'Symfony\Component\Debug\Exception\FatalErrorException' with message 'Call to undefined method PHPExcel::getTitle()' in

[vuchl]

Hmm strange. The method is there.

[melvin0008]

Yup strange.
Is the error on this line
$this->excel->getProperties()->getTitle();

[melvin0008]

This is weird PHPExcel does have a method called getTitle . Its here

[MaatwebsiteSupport]

No need to add an extra method.
If you have only one sheet, then you don't have to loop through the sheets.

Excel::load(public_path().$destinationPath.'/'.$name, function($sheet) {
          // reader methods
          $sheetTitle = $sheet->getTitle();
 });

To verify the injected value in the closure is indeed a Sheet, you can dump it and see if the class is called "RowCollection".

If you always want to loop through the sheets no matter what, you'll have to set the import.force_sheets_collection to true.

[melvin0008]

Thanks

[ericmuigai]

This is what I used and seems to work
$sheetNames = Excel::load($file)->getSheetNames();
Hope it helps :)

[flosej]

That works

foreach($reader->all() as $sheet) { // get sheet title $sheetTitle = $sheet->getTitle(); dd($sheetTitle); }