| Install | |
|---|---|
composer require lightshire/laravel-phpexcel-wrapper |
Require package via composer.json
lightshire/laravel-phpexcel-wrapper
Run composer update
$ composer update
Open app/config/app.php and add ServiceProvider to 'providers' array
'Lightshire\PHPExcel\ServiceProvider',
Optionally add to aliases
'Excel' => 'Lightshire\PHPExcel\Facade',
Create Excel xls file from array
Excel::fromArray( array(
array('1', '2', '3'),
array('X', 'Y', 'Z')
) )->save( base_path() . '/sample.xls' );
Create Excel xlsx file from array
Excel::fromArray( array(
array('Hello', 'World', '!!!'),
array('X', 'Y', 'Z')
) )->save( base_path() . '/sample.xlsx' );
Create array from Excel file
Excel::excel2Array( base_path() . '/sample.xls' );