xerobase/excel-reporter

Creating excel reports never been easier!

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

Requires

• phpoffice/phpspreadsheet: ^1.5

MIT

• Armin Abbasi

• excel
• report
• laravel
• php excel
• xerobase
• armin
• abbasi
• excel reporter

README

Create excel reports, from any data structure (collection, array, objects) with a line of code!

Installation

composer require xerobase/excel-reporter

Usage

Create an instance of Export class

$exporter = new \Xerobase\ExcelReporter\Export();

You can simply export your data by calling export method :

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

Maybe want to filter some of unnecessary fields :

$exporter->filterColumns(['id', 'created_at', 'updated_at'])->export($books);

Set direction to RTL :

$exporter->setRightToLeft()->export($books);

Or change format to CSV :

$exporter->setFormat('csv')->export($books);