Yii2, Custom css style for Kartik export

Question

I'm trying to apply custom css styles to exported files such as pdf.

For example how can applying custom css style in pdf export?

I changed some font styles in styleOptions but nothing happen.

        <?= ExportMenu::widget([
        'target' => ExportMenu::TARGET_SELF,
        'dataProvider' => $dataProvider,
        'columns' => $report_columns,
        'fontAwesome' => true,
        'dropdownOptions' => [
            'label' => Yii::t('app','Export All'),
            'class' => 'btn btn-default'
        ],
        'styleOptions' => [
            'font' => [
                'size' => '24px',
                'bold' => true,
                'color' => [
                    'argb' => 'FFFFFFFF',
                ],
            ],
            'fill' => [
                'type' => PHPExcel_Style_Fill::FILL_SOLID,
                'color' => [
                    'argb' => '00000000',
                ],
            ],          
        ],
        'exportConfig' => [

            ExportMenu::FORMAT_CSV => false,
            ExportMenu::FORMAT_EXCEL => false,
            ExportMenu::FORMAT_EXCEL_X => false,
            ExportMenu::FORMAT_TEXT => false,
            //ExportMenu::FORMAT_PDF => false,
            //ExportMenu::FORMAT_HTML => false
        ]
        ]) . "<hr>\n".
        GridView::widget([
            'dataProvider' => $dataProvider,
            'filterModel' => $searchModel,
            'columns' => $columns,
            'pjax' => true,
            'summary' => '',
            'options' => ['class' => 'xxx', 'style'=>'padding-right:10px']
        ]);
    ?>

score 1 · Answer 1 · answered Jun 01 '19 at 22:21

The styleOptions must be setup as an associative array, as it was updated in the documentation for export menu styleOptions settings: http://demos.krajee.com/export#option-styleOptions

'styleOptions' => [
    ExportMenu::FORMAT_EXCEL_X => [
        'font' => [
            'size' => '24px',
            'bold' => true,
            'color' => [
                'argb' => 'FFFFFFFF',
            ],
        ],
        'fill' => [
            'type' => PHPExcel_Style_Fill::FILL_SOLID,
            'color' => [
                'argb' => '00000000',
            ],
        ],
    ],
],

And ensure you are importing PHPExcel_Style_Fill correctly.

How do I import ```PHPExcel_Style_Fill``` correctly? Please show an example. — Scott Fleming, Apr 16 '21 at 16:59
You have to add line `use \PHPExcel_Style_Fill;` on the top of your php file. — Gaston Berenstein, Sep 06 '21 at 12:40

Yii2, Custom css style for Kartik export

1 Answers1