xe萝卜基/ Excel报告器
创建Excel报告从未如此简单!
v1.0.0
2019-01-18 19:16 UTC
Requires
- phpoffice/phpspreadsheet: ^1.5
This package is auto-updated.
Last update: 2024-09-19 18:53:58 UTC
README
使用一行代码从任何数据结构(集合、数组、对象)创建Excel报告!
安装
composer require xerobase/excel-reporter
用法
创建Export类的实例
$exporter = new \Xerobase\ExcelReporter\Export();
你可以通过调用export方法简单地导出你的数据
// Your source can be an Eloquent Model $books = \App\Models\Book::all(); // Or an associative array $books = [ 'Title' => 'Foo', 'Author' => 'Bar' ]; // Or an stdClass object $books = new stdClass(); $books->title = 'Foo'; $books->author = 'Bar'; $exporter->export($books);
可能需要过滤一些不必要的字段
$exporter->filterColumns(['id', 'created_at', 'updated_at'])->export($books);
设置方向为RTL
$exporter->setRightToLeft()->export($books);
或将格式更改为CSV
$exporter->setFormat('csv')->export($books);