How to get excel sheet title in laravel 5.2

Question

I want to get excel sheet title.
I have method controller like this:

use Maatwebsite\Excel\Facades\Excel;



public function importCSVEXCEl()
   {

    Excel::load('test.xls', function($reader) {
        foreach($reader as $sheet)
        {

         $temp= $sheet->getTitle();
        }
    });
}

after execute this method show me error

Call to undefined method PHPExcel::getTitle()

KazikM · Accepted Answer · 2016-04-02 13:16:12Z

2

According to Issue #316 discussion on Github:

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.

and second suggestion from the same source:

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

answered Apr 2, 2016 at 13:16

KazikM

1,3455 gold badges21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

paranoid Over a year ago

How can change import.force_sheets_collection. witch file should I change?

KazikM Over a year ago

@paranoid This setting is in import section of excel.php file in your Laravel config folder.

Collectives™ on Stack Overflow

How to get excel sheet title in laravel 5.2

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related