<?php namespace App\Exports; use App\User; use Illuminate\Contracts\View\View; use Maatwebsite\Excel\Concerns\FromView; use DB; use PhpOffice\PhpSpreadsheet\Style\NumberFormat; use Maatwebsite\Excel\Concerns\WithColumnFormatting; class StockviewExport implements FromView, WithColumnFormatting { public $stocks; function __construct($stocks = null) { $this->stocks = $stocks; } public function columnFormats(): array { return [ 'B' => '0', ]; } public function view(): View { return view('exports.stock-view', [ 'stocks' => $this->stocks ]); } }