Laravel-excel: FatalThrowableError on excel generate

Created on 25 Jan 2018  路  12Comments  路  Source: Maatwebsite/Laravel-Excel

Parse error: syntax error, unexpected '?', expecting variable (T_VARIABLE) in AttributeMatchingExtension.php (line 46)

dont enter into the first function for example:

public function reportParticipantXls()  
   {
          Excel::create('Reportes IPT Super Admin', function ($excel) {
            dd("stop here");
            $excel->sheet('Reporte por Participantes', function ($sheet) {      

                $participantes = \DB::select("CALL get_participantXls()");

                 //definir los titulos
                 $sheet->row(1, [
                 'C茅dula del participante','Nombres','Apellidos','Nombre de Usuario','Correo electr贸nico','Organizaci贸n del participante','Estado','Plan','Servicio','Contenidos Tomados','Contenidos Logrados','Eficiencia General','Contenidos tomados l铆nea Esencial','Conteni$
                 ]);

                 $sheet->row(1,  function($row){
                    $row->setBackground('#cadf24');
                    $row->setFontColor('#000000');
                    $row->setFontSize(14);
                    $row->setAlignment('center');
                    $row->setValignment('center');
                    $row->setFontWeight('bold');
                });

                $sheet->freezeFirstRow(1);

                foreach ($participantes as $index => $participante) {

                    // calculamos la eficiencia general
                    $eficiencia = 0;
                    if($participante->contenido_tomados != 0){
                        $eficiencia = round((($participante->contenido_logrados / $participante->contenido_tomados)*100),2).'%';
                    }

                    // calculamos la eficiencia linea de enfasis esencial
                    $eficiencia_esencial = 0;
                    if($participante->contenidos_tomados_linea_esencial != 0){
                        $eficiencia_esencial = round((($participante->contenido_logrados_linea_esencial / $participante->contenidos_tomados_linea_esencial)*100),2).'%';
                    }



                    $sheet->row($index+2, [
                    $participante->cedula, $participante->nombres, $participante->apellidos, $participante->username, $participante->email, $participante->business_name, $participante->estado, $participante->plan, $participante->servicio, $participante->contenido_tomados, $
                    ]);
                }

                $sheet->setAllBorders('thin');
            });
         })->export('xls');
    }

didn't show the message
Package version, 5.4
deepinscreenshot_20180125145028

[2018-01-25 22:06:50] production.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Parse error: syntax error, unexpected '?', expecting variable (T_VARIABLE) in /var/www/ipt_saas/vendor/symfony/css-selector/XPath/Extension/AttributeMatchingExtension.php:46
Stack trace:
#0 /var/www/ipt_saas/vendor/composer/ClassLoader.php(301): Composer\Autoload\includeFile('/var/www/ipt_sa...')
#1 [internal function]: Composer\Autoload\ClassLoader->loadClass('Symfony\\Compone...')
#2 /var/www/ipt_saas/vendor/symfony/css-selector/XPath/Translator.php(60): spl_autoload_call('Symfony\\Compone...')
#3 /var/www/ipt_saas/vendor/symfony/css-selector/CssSelectorConverter.php(36): Symfony\Component\CssSelector\XPath\Translator->__construct()
#4 /var/www/ipt_saas/vendor/tijsverkoyen/css-to-inline-styles/src/CssToInlineStyles.php(20): Symfony\Component\CssSelector\CssSelectorConverter->__construct()
#5 /var/www/ipt_saas/vendor/maatwebsite/excel/src/Maatwebsite/Excel/ExcelServiceProvider.php(124): TijsVerkoyen\CssToInlineStyles\CssToInlineStyles->__construct()
#6 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(726): Maatwebsite\Excel\ExcelServiceProvider->Maatwebsite\Excel\{closure}(Object(Illuminate\Foundation\Application), Array)
#7 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(608): Illuminate\Container\Container->build(Object(Closure))
#8 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(575): Illuminate\Container\Container->resolve('excel.parsers.c...')
#9 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(728): Illuminate\Container\Container->make('excel.parsers.c...')
#10 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(1172): Illuminate\Foundation\Application->make('excel.parsers.c...')
#11 /var/www/ipt_saas/vendor/maatwebsite/excel/src/Maatwebsite/Excel/ExcelServiceProvider.php(149): Illuminate\Container\Container->offsetGet('excel.parsers.c...')
#12 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(726): Maatwebsite\Excel\ExcelServiceProvider->Maatwebsite\Excel\{closure}(Object(Illuminate\Foundation\Application), Array)
#13 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(608): Illuminate\Container\Container->build(Object(Closure))
#14 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(575): Illuminate\Container\Container->resolve('excel.readers.h...')
#15 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(728): Illuminate\Container\Container->make('excel.readers.h...')
#16 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(1172): Illuminate\Foundation\Application->make('excel.readers.h...')
#17 /var/www/ipt_saas/vendor/maatwebsite/excel/src/Maatwebsite/Excel/ExcelServiceProvider.php(164): Illuminate\Container\Container->offsetGet('excel.readers.h...')
#18 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(726): Maatwebsite\Excel\ExcelServiceProvider->Maatwebsite\Excel\{closure}(Object(Illuminate\Foundation\Application), Array)
#19 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(608): Illuminate\Container\Container->build(Object(Closure))
#20 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(575): Illuminate\Container\Container->resolve('excel.parsers.v...')
#21 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(728): Illuminate\Container\Container->make('excel.parsers.v...')
#22 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(1172): Illuminate\Foundation\Application->make('excel.parsers.v...')
#23 /var/www/ipt_saas/vendor/maatwebsite/excel/src/Maatwebsite/Excel/ExcelServiceProvider.php(199): Illuminate\Container\Container->offsetGet('excel.parsers.v...')
#24 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(726): Maatwebsite\Excel\ExcelServiceProvider->Maatwebsite\Excel\{closure}(Object(Illuminate\Foundation\Application), Array)
#25 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(608): Illuminate\Container\Container->build(Object(Closure))
#26 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(575): Illuminate\Container\Container->resolve('excel')
#27 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(728): Illuminate\Container\Container->make('excel')
#28 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Container/Container.php(1172): Illuminate\Foundation\Application->make('excel')
#29 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(159): Illuminate\Container\Container->offsetGet('excel')
#30 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(128): Illuminate\Support\Facades\Facade::resolveFacadeInstance('excel')
#31 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(215): Illuminate\Support\Facades\Facade::getFacadeRoot()
#32 /var/www/ipt_saas/app/Http/Controllers/SuperAdmin/ReportController.php(787): Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#33 [internal function]: ipt_saas\Http\Controllers\SuperAdmin\ReportController->reportParticipantXls()
#34 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#35 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('reportParticipa...', Array)
#36 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(ipt_saas\Http\Controllers\SuperAdmin\ReportController), 'reportParticipa...')
#37 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#38 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Router.php(572): Illuminate\Routing\Route->run()
#39 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /var/www/ipt_saas/app/Http/Middleware/SuperAdmin.php(26): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#41 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): ipt_saas\Http\Middleware\SuperAdmin->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#43 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#47 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#50 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#51 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#52 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#53 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#59 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#62 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Router.php(574): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#63 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Router.php(533): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#64 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Router.php(511): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#65 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#66 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#67 /var/www/ipt_saas/vendor/garygreen/pretty-routes/src/MainMiddleware.php(29): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#68 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): PrettyRoutes\MainMiddleware->handle(Object(Illuminate\Http\Request), Object(Closure))
#69 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#70 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#71 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#72 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#73 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#74 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#75 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#76 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#77 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#78 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#79 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#80 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#81 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#82 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#83 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#84 /var/www/ipt_saas/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#85 /var/www/ipt_saas/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#86 {main}
picture fabpin

Most helpful comment

For those who cannot update PHP version and want an fast and ugly 'patch' composer require "symfony/css-selector:3.4.4", it save when final customer not happy.
(But please don't do that and upgrade your PHP version)

picture Hugome on 1 Feb 2018
👍4

All 12 comments

Hello,
have you found the solution for this problem?
I get this error message on the server while on the localhost everything works fine

iturcanu picture iturcanu on 29 Jan 2018

I am also having the same error. It works on localhost but not on server.
Please Help.

kriss1897 picture kriss1897 on 30 Jan 2018

Same error here

catlabs picture catlabs on 30 Jan 2018

I managed to fix this to upgrading my PHP version to 7.1.0, before that I had v7.0.22.
This is caused by the new PHP feature "Nullable types" http://php.net/manual/en/migration71.new-features.php

ArnisLielturks picture ArnisLielturks on 30 Jan 2018
👍4

I have updated to PHP 7.1.13 on server and localhost but the problem still exists.

iturcanu picture iturcanu on 30 Jan 2018

I have php 7.1.6 and the problem is still there

catlabs picture catlabs on 30 Jan 2018

Yes. @ArnisLielturks is right. I also fixed it by upgrading it to 7.1.13.
@catlabs and @iturcanu If you've upgraded php then you should try removing earlier libapache2-mod-php7.0 or earlier and installing the libapache2-mod-php7.1.

kriss1897 picture kriss1897 on 30 Jan 2018
👍1

Thanks for the answer,

I actually made a mistake the php on command line is 7.1 but not on the website (5.6). I asked the guy in charge of the server to change it. I ll let you know when it's done :-)

catlabs picture catlabs on 31 Jan 2018
🎉1

For those who cannot update PHP version and want an fast and ugly 'patch' composer require "symfony/css-selector:3.4.4", it save when final customer not happy.
(But please don't do that and upgrade your PHP version)

Hugome picture Hugome on 1 Feb 2018
👍4

Hi,
I have PHP 7.2.2-3+ubuntu16.04.1+deb.sury.org+1
But still facing the same issue. Please share if anyone found the good solution for this.

bhattraideb picture bhattraideb on 25 Feb 2018

Try locking composer require "symfony/css-selector:3.4.4"

patrickbrouwers picture patrickbrouwers on 25 Feb 2018
👍2 ❤1

the problem was than i updated from 7.0 to 7.1.13, this upgrade, already have the following bug, the extension than already been on memory, point in to libapache2-mod-php7.0, if you remove this extension, remained on memory, so, you must remove 7.0, and reinstall 7.1.13 and work, cuz when yu reinstall 7.1.13 install and configured for default libapache2-mod-php7.1

fabpin picture fabpin on 27 Feb 2018
👍1
Was this page helpful?
0 / 5 - 0 ratings

Related issues

dr3ads picture dr3ads  路  3Comments
vandolphreyes picture vandolphreyes  路  3Comments
thearabbit picture thearabbit  路  3Comments
bahmanyaghoobi picture bahmanyaghoobi  路  3Comments
octoxan picture octoxan  路  3Comments