gri3li/yii2-grid-file

这个Yii2扩展提供了将数据从数据提供者导出为PhpSpreadsheet支持的格式的功能

维护者

详细信息

github.com/gri3li/yii2-grid-file

源代码

问题

安装次数: 819

依赖项: 0

建议者: 0

安全: 0

星星: 2

关注者: 1

分支: 1

开放性问题: 0

类型:yii2-extension

v1.3 2024-04-05 22:22 UTC

Requires

BSD-3-Clause 4b4c937f8b746ce80b3694d322e4eb2fbcdafbdc

  • Mikhail Gerasimov <migerasimoff.woop@gmail.com>

xlsxlsxcsvexportgridyii2ods

This package is auto-updated.

Last update: 2024-09-29 17:19:40 UTC

README

这个Yii2扩展提供了将数据从yii\data\DataProviderInterface实例导出为PhpSpreadsheet支持格式的功能

安装

通过Composer安装此包

composer require gri3li/yii2-grid-file

使用

$export = new \gri3li\yii2gridfile\GridFile([
   'dataProvider' => new \yii\data\ArrayDataProvider([
       'allModels' => [
           [
               'name' => 'some name',
               'date' => 1538571363,
           ],
           [
               'name' => 'name 2',
               'date' => 1538571363,
           ],
       ],
   ]),
   'columns' => [
       'name',
       'date:datetime',
   ],
   'headerCellStyle' => [
       'font' => ['bold' => true],
       'fill' => [
           'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
           'startColor' => ['rgb' => 'CCCCCC'],
       ],
   ],
]);
$export->saveAs(\PhpOffice\PhpSpreadsheet\Writer\Xls::class, '/path/to/file.xls');

// $export->saveAs(\PhpOffice\PhpSpreadsheet\Writer\Xlsx::class, '/path/to/file.xlsx');
// $export->saveAs(\PhpOffice\PhpSpreadsheet\Writer\Ods::class, '/path/to/file.ods');
// $export->saveAs(\PhpOffice\PhpSpreadsheet\Writer\Html::class, '/path/to/file.html');
// $export->saveAs(\PhpOffice\PhpSpreadsheet\Writer\Csv::class, '/path/to/file.csv');

有关phpspreadsheet样式的更多信息请参阅 https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#styles

用例 https://github.com/gri3li/yii2-grid-file/tree/master/example

为了运行用例

cd vendor/gri3li/yii2-grid-file/example/
php -S 127.0.0.1:8877

打开 http://127.0.0.1:8877