use kartik\export\ExportMenu;
use kartik\grid\GridView;
use PhpOffice\PhpSpreadsheet\Cell\DataType;
use yii\data\ArrayDataProvider;

$dataProvider = new ArrayDataProvider(['allModels' => [
    ['id' => '10032460001', 'fruit' => 'Apples', 'quantity' => '100', 'value' => 213288.32],
    ['id' => '10032460002', 'fruit' => 'Oranges', 'quantity' => '60', 'value' => 84343.68],
    ['id' => '10032460003', 'fruit' => 'Bananas', 'quantity' => '160', 'value' => 49343.65],
    ['id' => '10032460004', 'fruit' => 'Pineapples', 'quantity' => '90', 'value' => 72631.02],
    ['id' => '10032460005', 'fruit' => 'Grapes', 'quantity' => '290', 'value' => 627653.65],
]]);
echo ExportMenu::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        [
            'class' => 'kartik\grid\SerialColumn'
        ],
        [
            'attribute' => 'id',
            'header' => 'Lot ID',
            'width' => '260px',
            'hAlign' => GridView::ALIGN_CENTER,
            'contentOptions' => ['cellFormat' => DataType::TYPE_STRING], // set an explicit format
            //'headerOptions' => ['cellFormat' => DataType::TYPE_STRING], // can set at header level
            //'footerOptions' => ['cellFormat' => DataType::TYPE_STRING], // can set at footer level
            //also can be set for each cell config within `contentBefore` and `contentAfter`
        ],
        'fruit',
        [
            'attribute'=>'quantity',
            'hAlign' => GridView::ALIGN_RIGHT,
            'width' => '160px',
            'format' => 'decimal',
            'contentOptions' => ['cellFormat' => DataType::TYPE_NUMERIC], // set an explicit format
        ],
        [
            'attribute'=>'value',
            'hAlign' => GridView::ALIGN_RIGHT,
            'width' => '160px',
            'format' => 'currency'
        ],
    ],
    'dropdownOptions' => [
        'label' => 'Export All',
        'class' => 'btn btn-outline-secondary btn-default'
    ]
]) . "<hr>\n".
GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        ['class' => 'kartik\grid\SerialColumn'],
        [
            'attribute' => 'id',
            'header' => 'Lot ID',
            'width' => '260px',
            'hAlign' => GridView::ALIGN_CENTER
        ],
        'fruit',
        [
            'attribute'=>'quantity',  
            'hAlign' => GridView::ALIGN_RIGHT,
            'width' => '160px',
            'format' => 'decimal'
        ],
        [
            'attribute'=>'value', 
            'hAlign' => GridView::ALIGN_RIGHT,
            'width' => '160px',
            'format' => 'currency'
        ],
    ],
]);

$gridColumns = [
    ['class' => 'kartik\grid\SerialColumn'],
    'id',
    'name',
    [
        'attribute'=>'author_id',
        'label'=>'Author',
        'vAlign'=>'middle',
        'width'=>'190px',
        'value'=>function ($model, $key, $index, $widget) { 
            return Html::a($model->author->name, '#', []);
        },
        'format'=>'raw'
    ],
    'color',
    'publish_date',
    'status',
    ['attribute'=>'buy_amount','format'=>['decimal',2], 'hAlign'=>'right', 'width'=>'110px'],
    ['attribute'=>'sell_amount','format'=>['decimal',2], 'hAlign'=>'right', 'width'=>'110px'],
    ['class' => 'kartik\grid\ActionColumn', 'urlCreator'=>function(){return '#';}]
];