Composer Maatwebsite Excel Installation Problem

[itsdeo]

Prerequisites

• Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [] Able to reproduce the behaviour outside of your code, the problem is isolated to Laravel Excel.
• Checked that your issue isn't already filed.
• Checked if no PR was submitted that fixes this problem.
• Filled in the entire issue template

Versions

• PHP version:7.3.15
• Laravel version:5.6.39
• Package version: 3.1

Description

I am using maatwebsite excel laravel package for export data. I've gone through your documentation and installed it on the local system and it is working fine. But it is throwing error on the live while installing maatwebsite/excel composer. On the server composer is updating and installing using CircleCI. I used like this into composer.json
"require": {
"maatwebsite/excel": "^3.1"
}

Steps to Reproduce

While run composer it throw error:

​Your requirements could not be resolved to an installable set of packages.

Problem 1
- The requested package maatwebsite/excel could not be found in any version, there may be a typo in the package name.

Potential causes:

• A typo in the package name
• The package is not available in a stable-enough version according to your minimum-stability setting
  see https://getcomposer.org/doc/04-schema.md#minimum-stability for more details.
• It's a private package and you forgot to add a custom repository to find it

Expected behavir:
As Maatwebsite/excel is installed on the Local, same way it should be installed on the live.

Actual behavior:
It thrown error like this
You can see the error in the below. Also, I attached a screenshot.

​Your requirements could not be resolved to an installable set of packages.

Problem 1
- The requested package maatwebsite/excel could not be found in any version, there may be a typo in the package name.

Potential causes:

• A typo in the package name
• The package is not available in a stable-enough version according to your minimum-stability setting
  see https://getcomposer.org/doc/04-schema.md#minimum-stability for more details.
• It's a private package and you forgot to add a custom repository to find it

Additional Information

Any additional information, configuration or data that might be necessary to reproduce the issue.

[patrickbrouwers]

The output shows that your lock file is not up to date with your composer file. It's best practise to run composer update locally and commit the composer.lock file and run composer install on the live server.

[itsdeo]

Thanks for your prompt response. I did the same as mentioned by you. Now I am getting the following error.

Your requirements could not be resolved to an installable set of packages.

Problem 1
- Installation request for phpoffice/phpspreadsheet 1.14.1 -> satisfiable by phpoffice/phpspreadsheet[1.14.1].
- phpoffice/phpspreadsheet 1.14.1 requires ext-gd * -> the requested PHP extension gd is missing from your system.
Problem 2
- phpoffice/phpspreadsheet 1.14.1 requires ext-gd * -> the requested PHP extension gd is missing from your system.
- maatwebsite/excel 3.1.21 requires phpoffice/phpspreadsheet ^1.14 -> satisfiable by phpoffice/phpspreadsheet[1.14.1].
- Installation request for maatwebsite/excel 3.1.21 -> satisfiable by maatwebsite/excel[3.1.21].

To enable extensions, verify that they are enabled in your .ini files:
-
- /usr/local/etc/php/conf.d/docker-php-ext-intl.ini
- /usr/local/etc/php/conf.d/docker-php-ext-sodium.ini
- /usr/local/etc/php/conf.d/docker-php-ext-xdebug.ini
- /usr/local/etc/php/conf.d/docker-php-ext-zip.ini
You can also run php --ini inside terminal to see which files are used by PHP in CLI mode.

I checked and found gd extention is already enabled on the server, but still getting above error. Can you please help me on this?

[patrickbrouwers]

It seems the PHP that runs composer install doesn't have gd enabled. I would recommend asking for help on Stackoverflow or Laracasts. It's a bit too specific (and maybe related to CircleCI) for this issue tracker.

[itsdeo]

I checked and found gd extention is already enabled on the server, but still getting above error. Can you please help me on this?

[patrickbrouwers]

As mentioned before, I suggest you post this question on Stackoverflow or Laracasts as it's related to CircleCI/PHP and PhpSpreadsheet, not specifically this package.

[itsdeo]

Okay, Thank you!

[greyzundapp]

You can tray this in Laravel 8 to Install composer require maatwebsite/excel

: composer require maatwebsite/excel --ignore-platform-reqs

[jpsvcv]

Thank you @greyzundapp this solved my problem

[tqnguyen19it3]

Thanks for your answer @greyzundapp

[fernanj2323]

@greyzundapp this worked for me

[Jordan-18]

Thanks @greyzundapp it solved my problem

[norbertkomba]

You can tray this in Laravel 8 to Install composer require maatwebsite/excel

: composer require maatwebsite/excel --ignore-platform-reqs

Its work for me thanks

[shaktijaiswal]

[greyzundapp] thanks alot

[robindierckx]

You can tray this in Laravel 8 to Install composer require maatwebsite/excel

: composer require maatwebsite/excel --ignore-platform-reqs

This hack works, but now a simple command like composer install or composer update is broken (same error as itsdeo above). I need to add --ignore-platform-reqs to all my commands to develop locally and in my deployment scripts:

composer install --ignore-platform-req=ext-gd
composer update --ignore-platform-req=ext-gd

Is there any clean solution ? IMHO this is related to dependency management of this package so issue should be reopened.

[patrickbrouwers]

Is there any clean solution

Yes, installing the gd PHP extension.

IMHO this is related to dependency management of this package so issue should be reopened.

gd is a dependency of PhpSpreadsheet. There is nothing we can do about that in this package.