excel - ¿Cómo cambiar las propiedades de la hoja de exportación/documento en la exportación de la grilla Yura2 krajee?

yii2 excel

Question

Hemos utilizado la exportación de yii2 krajee para exportar datos de cuadrícula.
¿Cómo podemos modificar el título predeterminado, descripción, lastmodifiedby?

echo ExportMenu::widget([
    ''dataProvider'' => $dataProvider,
    ''columns'' => $gridColumns,
    ''target'' => ExportMenu::TARGET_SELF,
    ''exportConfig'' => [
        ExportMenu::FORMAT_PDF => false,
    ],
    ''filename'' => ''export-list_'' . date(''Y-m-d_H-i-s''),        
]);

Answer 1

Pruebe esto: Aquí hay un ejemplo de CSV. Puedes hacer lo mismo por otros también.

 use yii/helpers/Html;
    use kartik/grid/GridView;
    use kartik/export/ExportMenu;

    $gridColumns = [
            [''class'' => ''yii/grid/SerialColumn''],
            ''id'',
            ''name'',
            ''desc'',
            [''class'' => ''yii/grid/ActionColumn''],
        ];

        // Renders a export dropdown menu
        echo ExportMenu::widget([
            ''dataProvider'' => $dataProvider,
            ''columns'' => $gridColumns
        ]);

        GridView::widget([
            ''dataProvider'' => $dataProvider,
            ''filterModel'' => $searchModel,
            ''columns'' => $gridColumns,
            ''exportConfig''=> [
                GridView::CSV=>[
                    ''label'' => ''CSV'',
                    ''icon'' => '''',
                    ''iconOptions'' => '''',
                    ''showHeader'' => false,
                    ''showPageSummary'' => false,
                    ''showFooter'' => false,
                    ''showCaption'' => false,
                    ''filename'' => ''yii'',
                    ''alertMsg'' => ''created'',
                    ''options'' => [''title'' => ''Semicolon -  Separated Values''],
                    ''mime'' => ''application/csv'',
                    ''config'' => [
                        ''colDelimiter'' => ";",
                        ''rowDelimiter'' => "/r/n",
                    ], 
                ],
            ],
        ]);  

Answer 2

Lo que hice para hacer mi tarea-
Tengo en mi encabezado como-

use yii/helpers/Html;
use kartik/grid/GridView;

Luego en gridView -

    <?= GridView::widget([
            ''dataProvider'' => $dataProvider,
            ''filterModel'' => $searchModel,
            ''pjax''=>true,
            ''id'' => ''grid'',
            ''toolbar'' => [
                [''content''=>
                   Html::a(''<i class="glyphicon glyphicon-repeat"></i>'', [''ctrl-action''], [''data-pjax''=>false, ''class'' => ''btn btn-default'', ''title''=>''Reset Grid''])
                ],
                ''{export}'',
                ''{toggleData}''
              ],
              ''panel'' => [
                      ''heading''=>''<h3 class="panel-title"><i class="glyphicon glyphicon-cloud"></i> Output Daily Data </h3>'',
                      ''type''=>''primary'',
                      ''before''=>Html::a(''''),
                      ''after''=>Html::a(''''),
                      ''showFooter''=>false
                   ],
              ''columns'' => [
                 [''class'' => ''kartik/grid/SerialColumn''],

                 ''id'',
                 ''name''
                 [''class'' => ''yii/grid/ActionColumn''],
             ],

           ''responsive''=>true,
             ''hover''=>true,
             ''exportConfig'' => [
                   GridView::CSV => [''label'' => ''Export as CSV'', ''filename'' => ''File_Name-''.date(''d-M-Y'')],
                   GridView::HTML => [''label'' => ''Export as HTML'', ''filename'' => ''File_Name -''.date(''d-M-Y'')],
                   GridView::PDF => [''label'' => ''Export as PDF'', ''filename'' => ''File_Name -''.date(''d-M-Y'')],
                   GridView::EXCEL=> [''label'' => ''Export as EXCEL'', ''filename'' => ''File_Name -''.date(''d-M-Y'')],
                   GridView::TEXT=> [''label'' => ''Export as TEXT'', ''filename'' => ''File_Name -''.date(''d-M-Y'')],
                ],
                ''export'' => [
                   ''fontAwesome'' => true
                ],  
           ]); ?>

Eso funcionó para mí. solo realice cambios en ''exportConfig'' sección ''exportConfig'' para cambiar el nombre del archivo.