Yii2 Export

Implementation guide for exporting server/db data in various formats (e.g. excel, html, pdf, csv etc.) using the PHPExcel library. Installation The preferred way to install this extension is through composer. Either run $ php composer.phar require kartik-v/yii2-export "@dev" or add "kartik-v/yii2-export": "@dev" to the require section of your composer.json file. Configuration For yii2 advanced template edit frontend/config/main.php add ‘modules’ => [ ‘gridview’ => [ ‘class’ => ‘kartikgridModule’, ], ], Controller 3) Controller : action example public function actionIndex() { $searchModel = new CampaignsSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $campaigns = Campaigns::find() ->joinwith(‘campaignUser’) ->orderBy(‘CampaignAddedOn DESC’) ->all(); return $this->render(‘index’, [ ‘campaigns’ => $campaigns, ‘dataProvider’ => $dataProvider, ‘searchModel’=>$searchModel, ]); } View file : use kartik\export\ExportMenu; $gridColumns = [ [‘class’ => ‘yii\grid\SerialColumn’], ‘CampaignName’, // columns from table ‘CampaignNetAmount’, // columns from table [‘class’ => ‘yii\grid\ActionColumn’], ]; // Renders a export dropdown menu echo ExportMenu::widget([ ‘dataProvider’ => $dataProvider, ‘columns’ => $gridColumns ]); Export widget will be available in the view file.