Answers for "laravel excel avoid scientific notation for long numbers"

laravel excel avoid scientific notation for long numbers

// in database		: 1277192403076020
// in exported excel: 1,27719E+15

// how do i prevent that?
// here example:

<?php

namespace App\Exports\Pages;

use App\Models\YourModel;
use Maatwebsite\Excel\Concerns\FromCollection;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;

class PicsExport implements FromCollection, WithColumnFormatting
{
  	public function collection(){
    	// ...
    }
  
	public function columnFormats(): array{
        return [
            'A' => NumberFormat::FORMAT_NUMBER, // add this
        ];
	}
  
}