<?php namespace App\Exports; use App\User; use Illuminate\Contracts\View\View; use Maatwebsite\Excel\Concerns\FromView; use Maatwebsite\Excel\Concerns\WithColumnFormatting; use Maatwebsite\Excel\Concerns\WithColumnWidths; use DB; class GrnExport implements FromView, WithColumnFormatting, WithColumnWidths { public $grns; function __construct($grns = null) { $this->grns = $grns; } public function columnFormats(): array { return [ 'O' => '@', ]; } public function columnWidths(): array { return [ 'O' => 40, ]; } public function view(): View { return view('exports.grns', [ 'grns' => $this->grns, 'grn_no'=> '' ]); } }