soluble / php_excel_dev
LibXL - php_excel development stubs
Installs: 5 818
Dependents: 1
Suggesters: 0
Security: 0
Stars: 1
Watchers: 3
Forks: 1
Open Issues: 0
Requires
- php: ^7.1
Requires (Dev)
- captainhook/plugin-composer: ^4.0
- friendsofphp/php-cs-fixer: ^2.15
- phpoffice/phpspreadsheet: ^1.9
- phpstan/phpstan: ^0.11.15
- phpstan/phpstan-phpunit: ^0.11
- phpstan/phpstan-strict-rules: ^0.11
- phpunit/phpunit: ^7.4 || ^8.0
Conflicts
This package is auto-updated.
Last update: 2024-10-21 15:17:02 UTC
README
Installation tips, stubs and checker for LibXL / iliaal/php_excel php extension.
Stubs
Useful to enable autocompletion in your project composer require soluble/php_excel_dev --dev
Stubs should be installed as a
--dev
dependency.
LibXL install
In order to compile the iliaal/php_excel you must have libXL installed and the php development packages installed (phpize, phpconfig).
On Ubuntu, ensure you have the php-dev
package installed.
sudo apt-get install php-dev
Alternatively suffix with the php version if you're using the ondrej/php ppa:
sudo apt-get install php7.3-dev
Automated installation scripts
You can either use one of the bash scripts below :
Be sure the extension is loaded (in your php.ini) or type
phpenmod excel
.
Manual installation
LibXL
The libxl static binaries can easily be installed:
sudo mkdir /opt/libxl-3.8.2; wget -qO- http://www.libxl.com/download/libxl-lin-3.8.2.tar.gz | sudo tar zxvf - --strip 1 --directory /opt/libxl-3.8.2
PHP extension
Download and unzip the php_excel/php7 branch:
wget -qO- https://github.com/iliaal/php_excel/archive/php7.tar.gz | tar zxvf - --directory /tmp
Build the extension;
cd /tmp/php_excel-php7; ./configure --with-php-config=`which php-config` \ --with-libxl-incdir=/opt/libxl-3.8.2/include_c/ \ --with-libxl-libdir=/opt/libxl-3.8.2/lib64/ \ --with-excel=/opt/libxl-3.8.2 && \ make && \ make install
In case you're using multiple php versions, you can generally suffix the phpize and phpconfig commands like
phpize-7.3
,php-config-7.3
...
Then register the extension in your php.ini:
extension=excel.so
For ondrej/php ppa
echo "extension=excel.so" > /tmp/excel.ini; sudo cp /tmp/excel.ini /etc/php/php7.3/mods-available/excel.ini; sudo phpenmod -v 7.3 excel;
Checks
A convenience script to check installation can be run from composer
$ composer check:libxl -- <license name> <license key>
or directly from php
$ ./bin/check_phpexcel_install.sh <license name> <license key>
It checks for correctly loaded extension and valid license.