waxwink / report
Producing excel tables out of laravel collections
0.1.0
2019-03-12 07:28 UTC
Requires
- ext-bcmath: *
- illuminate/support: ^5.3
- phpoffice/phpspreadsheet: ^1.6
This package is auto-updated.
Last update: 2024-10-12 20:44:15 UTC
README
this package wraps around the php office spreadsheet to produce excel tables out of laravel collections.
Getting Started
Install the package with composer :
$ composer require waxwink/report
Instruction
Here is an examples to use the package :
use Illuminate\Support\Collection; use Waxwink\Report\Excel; require __DIR__."/vendor/autoload.php"; $keys = [ 'id'=> 'Product ID', 'name'=> 'Name', 'price'=> 'Price', ]; $collection = new Collection([ [ 'id'=> '1574', 'name'=> 'Phone', 'price'=> '100',], [ 'id'=> '6541', 'name'=> 'Printer', 'price'=> '150', ], [ 'id'=> '9652', 'name'=> 'Laptop', 'price'=> '350', ], [ 'id'=> '6971', 'name'=> 'Mouse', 'price'=> '30', ] ]); $xl = new Excel($collection, $keys); //this would save the file in the root folder : table.xlsx $xl->export('table');
you can also send the file to the client to download. :
// (works only if you're using laravel) return response()->download($xl->update());