siopas-istw-website/app/Exports/TipePetiExport.php

<?php

namespace App\Exports;

use App\Models\Type_peti;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\FromCollection;

class TipePetiExport implements FromCollection, WithHeadings
{
    /**
     * @return \Illuminate\Support\Collection
     */
    public function collection()
    {
        $nomor = 1;
        // Ambil data dari model Peti
        $tipepetis = Type_peti::select(
            'id',
            'type',
            'size_peti',
            'description',
        )->get();

        // Modifikasi data dan tambahkan nomor
        $data = $tipepetis->map(function ($tipepeti) use (&$nomor) {
            return [
                'No' => $nomor++,
                'Tipe' => $tipepeti->type,
                'Ukuran Peti' => $tipepeti->size_peti,
                'Deskripsi' => $tipepeti->description,
            ];
        });

        return $data;
    }

    public function headings(): array
    {
        return [
            'No',
            'TIPE',
            'UKURAN PETI',
            'DESKRIPSI',
        ];
    }
}