phpspreadsheet error : Message: syntax error, unexpected '='

Question

I am getting error is :

Type: ParseError

Message: syntax error, unexpected '='

Filename: /volume1/web/dbms/dev/akshay/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php

Line Number: 2460    

my Code is :

    <?php  
    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

    class Mgs_to_dbms extends MY_Controller{
       public function transfer_pe(){
        $spreadsheet = new Spreadsheet(); 
        }
    }       

Answer 1

Which version of PHP are you using, I got the same error today, after switching to PHP 7.2 its gone.

Answer 2

Method #1 Update PHP to v7.1

Method #2 Install a previous version of PhpSpreadsheet

Adjust composer.json

  "require": {
    "php": ">=7.0",
    "phpoffice/phpspreadsheet": "*"
  }

And run

php composer.phar update phpoffice/phpspreadsheet