Krajee

Excel Export Demo 2

Thankful to Krajee! BUY A COFFEEor to get more out of us.

Formatting each column (overrides the autoXlFormat setting). This example showing different formats for columns - i.e. scientific number format and different date or time formats.

Tip

Not seeing the updated content on this page! Hard refresh your browser to clean cache for this page (e.g. SHIFT-F5 on Windows Chrome)

Total 8 items.
Products
CodeNameBuy DateLaunch TimeQuantityPriceAmountCreated On
0218881Product 108-Apr-20034:22 PM2,12132.5569,038.5521-Jun-15 12:34:45
0218882Product 202-Nov-20012:04 AM281,582.3544,305.8001-Jan-15 04:22:12
0218883Product 329-Feb-20041:11 AM1,97253.19104,890.6811-Nov-12 02:02:03
0218884Product 403-Mar-200110:05 PM2,11228.4760,128.6401-Apr-04 00:34:15
0218885Product 501-Nov-20092:11 PM431,222.6652,574.3831-Mar-13 06:29:12
0218886Product 631-May-20149:21 AM122,232.1226,785.4421-Jun-15 12:34:45
0218887Product 708-Apr-200310:03 AM992293.19290,844.4801-Aug-05 11:32:12
0218888Product 808-Apr-20033:23 PM4532,232.221,011,195.6630-Sep-01 02:14:05
Total   7,7337,676.751,659,763.63 

echo GridView::widget([
    'dataProvider'=>$dataProvider,
    'autoXlFormat'=>true,
    'toggleDataContainer' => ['class' => 'btn-group mr-2 me-2'],
    'export'=>[
        'showConfirmAlert'=>false,
        'target'=>GridView::TARGET_BLANK
    ],
    'columns'=>[
        [
            'attribute'=>'code', 
            'format'=>'text', 
            'width'=>'100px', 
            'pageSummary'=>'Total'
        ],
        [
            'attribute'=>'name', 
            'format'=>'text', 
            'width'=>'120px'
        ],
        [
            'attribute'=>'buy_date', 
            'format'=>['date', 'php:d-M-Y'], 
            'xlFormat'=>'mmm\-dd\, yyyy',  // different date format
            'width'=>'100px'
        ],
        [
            'attribute'=>'launch_time', 
            'format'=>['time', 'php:g:i a'], 
            'hAlign'=>'center', 
            'xlFormat'=>'Long Time', // long time
            'width'=>'100px'
        ],
        [
            'attribute'=>'quantity', 
            'format'=>'integer', 
            'hAlign'=>'right', 
            'width'=>'100px', 
            'xlFormat'=>'0\.00E+00', // scientific
            'pageSummary'=>true
        ],
        [
            'attribute'=>'price', 
            'format'=>['decimal', 2], 
            'hAlign'=>'right', 
            'width'=>'100px', 
            'pageSummary'=>true
        ],
        [
            'class'=>'kartik\grid\FormulaColumn', 
            'label'=>'Amount', 
            'format' => ['decimal', 2],
            'value'=>function ($model, $key, $index, $widget) { 
                $p = compact('model', 'key', 'index');
                return $widget->col(4, $p) * $widget->col(5, $p) ;
            }, 
            'hAlign'=>'right', 
            'width'=>'120px', 
            'pageSummary'=>true
        ],
        [
            'attribute'=>'created_on', 
            'format'=>['datetime', 'php:d-M-y H:i:s'], 
            'width'=>'140px'
        ]
    ],
    'pjax'=>true,
    'showPageSummary'=>true,
    'panel'=>[
        'type'=>'primary',
        'heading'=>'Products'
    ]
]);

Note

You can now visit the Krajee Webtips Q & A forum for searching OR asking questions OR helping programmers with answers on these extensions and plugins. For asking a question click here. Select the appropriate question category (i.e. Krajee Plugins) and choose this current page plugin in the question related to field.

The comments and discussion section below are intended for generic discussions or feedback for this plugin. Developers may not be able to search or lookup here specific questions or tips on usage for this plugin.

 
visitors to Krajee Yii2 Demos since 22-May-2017