PHPackages                             xiaomlove/grid-exporter - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. xiaomlove/grid-exporter

ActiveLibrary[PDF & Document Generation](/categories/documents)

xiaomlove/grid-exporter
=======================

export grid data for laravel-admin

v0.1.0(7y ago)116.3k↓100%4MITPHPPHP >=7.0.0

Since Apr 16Pushed 7y ago1 watchersCompare

[ Source](https://github.com/xiaomlove/grid-exporter)[ Packagist](https://packagist.org/packages/xiaomlove/grid-exporter)[ Docs](https://github.com/xiaomlove/grid-exporter)[ RSS](/packages/xiaomlove-grid-exporter/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (1)Dependencies (3)Versions (2)Used By (0)

export grid data for laravel-admin
==================================

[](#export-grid-data-for-laravel-admin)

Installation
------------

[](#installation)

```
$ composer require xiaomlove/grid-exporter -vvv

```

Configuration
-------------

[](#configuration)

`grid-exporter` supports 1 configuration, open `config/admin.php` find `extensions`:

```
    'extensions' => [

        'grid-exporter' => [

            // Set this to false if you want to disable this extension
            'enable' => true,

        ]
    ]
```

Usage
-----

[](#usage)

if this extension is enabled, it will register as the default exporter (replace `Encore\Admin\Grid\Exporters\CsvExporter`)
if you want to format specified column, use it manually. In your controller

```
use Chenyulingxi\LaravelAdmin\GridExporter\Exporter;
use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Events\BeforeExport;

...

protected function grid()
{
    $grid = new Grid(new Test);

    $grid->id('Id');
    $grid->name('Name');
    $grid->created_at('Created at');
    $grid->updated_at('Updated at');

    $exporter = new Exporter();

    //format the name column
    $exporter->format('name', function ($value) {
        //In the format callback closure, $this bindTo the eloquent model
        return strtolower($value);
    });

    // replace the grid table header
    $exporter->withHeadings([
        'id' => '编号',
        'name' => '姓名',
        'created_at' => '创建时间',
        'updated_at' => '更新时间',
    ]);

    //change output file (xlsx) style
    $exporter->setEvents([
        BeforeExport::class  => function(BeforeExport $event) {
            $event->writer->getDelegate()->getProperties()->setCreator('xiaomlove');
        },
        AfterSheet::class => function ($event) {
            $sheet = $event->sheet;
            $highestColumn = $sheet->getHighestColumn();
            $highestRow = $sheet->getHighestRow();
            $styles = [
                'font' => [
                    'bold' => true,
                ],
                'fill' => [
                    'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_GRADIENT_LINEAR,
                    'rotation' => 90,
                    'startColor' => [
                        'argb' => 'FFA0A0A0',
                    ],
                    'endColor' => [
                        'argb' => 'FFFFFFFF',
                    ],
                ]
            ];
            $sheet->getStyle("A{$highestRow}:{$highestColumn}{$highestRow}")->applyFromArray($styles);
        }
    ]);

    // set write type, default xlsx
    $exporter->setWriteType(\Maatwebsite\Excel\Excel::CSV);

    // set the file name
    $exporter->setFileName('test-export');

    $grid->exporter($exporter);

    return $grid;
}

...
```

if you want more control over the output file, you can create a class that extents from `Chenyulingxi\LaravelAdmin\GridExporter\DataSource`, then inject it's instance to the exporter like this:

```
$exporter->setDataSource(new TestDataSource());
```

more information reference to [Laravel Excel](https://docs.laravel-excel.com/3.1/exports/extending.html) and [PhpSpreadsheet](https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#styles)

License
-------

[](#license)

Licensed under [The MIT License (MIT)](LICENSE).

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity28

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity44

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

2584d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/0668228c4e2bc50cfd87bb2125b0fecb3e5b77a3ff4cdc52428e07aaaeb4625e?d=identicon)[xiaomlove](/maintainers/xiaomlove)

---

Tags

excelexporterlaravel-adminexportextensionlaravel-admin

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/xiaomlove-grid-exporter/health.svg)

```
[![Health](https://phpackages.com/badges/xiaomlove-grid-exporter/health.svg)](https://phpackages.com/packages/xiaomlove-grid-exporter)
```

###  Alternatives

[kartik-v/yii2-export

A library to export server/db data in various formats (e.g. excel, html, pdf, csv etc.)

1623.1M35](/packages/kartik-v-yii2-export)[moonlandsoft/yii2-phpexcel

Exporting PHP to Excel or Importing Excel to PHP

1491.1M16](/packages/moonlandsoft-yii2-phpexcel)[georgringer/redirect-generator

Generate redirect entries from a given set of URLs and export all to CSV

1645.5k](/packages/georgringer-redirect-generator)[phpnt/yii2-export

Yii2 It saves data in xls, csv, word, html, pdf files.

158.9k](/packages/phpnt-yii2-export)[3x1io/filament-excel

Excel Export for Resources

224.2k1](/packages/3x1io-filament-excel)[zhusaidong/laravel-admin-grid-exporter

laravel-admin grid-exporter

113.0k](/packages/zhusaidong-laravel-admin-grid-exporter)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)