xe萝卜基/Excel报告器

创建Excel报告从未如此简单!

v1.0.0 2019-01-18 19:16 UTC

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);