yii2 Exportable Gridview

Gridview with full data export

This works as normal gridview, but adds a button to export the data loaded into it. It exports all records found on the active record query. Works with the same data as the gridview does. Uses phpspreadsheet to generate export file.

How does it work

Following the same behavior that pjax widget, this widget act as a normal gridview until a request is made with the url query parameters export-grid and export-container. The latter should contain the id of gridview without the hashtag. When both parameters are received, response is cleared and then spreadsheet generation begins. This allow to generate a file with absolutely all records found on the gridview.

This project is currently under development. Any contribution is welcome.

Installation

composer require eseperio/yii2-exportable-gridview @dev

Usage

This widget extends from yii2-gridview but add functionality to export all the rows queried by the DataProvider.

use eseperio\gridview\ExportableGridview as GridView;
<?= GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],
            'id',
            'title',
            'description',
            'author',
        ],
    ]);
    ?>

Additional configuration

Name	Type	default	Description
layout	string	{summary} {items} {export} {pager}	In addition to default layout this gridview has {export} section. This is the place for export button.
fileName	string	exported.xls	Name to use on the generated filename. If writerType value is not set then the writer will be guessed from the extension.
writerType	string	null	The writer to be used when generating file. See Spreadsheet writer. Accepts Xls, Xlsx, Ods, Csv, Html, Tcpdf, Dompdf, Mpdf
exportable	boolean	true	Whether to enable export for this gridview
exportLinkOptions	array	['class'=> 'btn btn-default', 'target'=>'_blank']	Options for the export link. It also accepts label and encode
exportColumns	array	empty	Property to define a different column combination for export only. If empty default columns of gridview will be used

Constants available

All writers identifiers are available through constants.

Constant name	Value
WRITER_XLS	Xls
WRITER_XLSX	Xlsx
WRITER_ODS	Ods
WRITER_CSV	Csv
WRITER_HTML	Html
WRITER_TCPDF	Tcpdf
WRITER_DOMPDF	Dompdf
WRITER_MPDF	Mpdf

Notes

All html tags are removed when exporting.

Todo

• Add option to exclude certain columns like ActionColumn.
• Add batch data processing.
• Add custom PDF export method.
• Add tests