Daftar dan Belajar Sekarang!

Laravel - export excel laravel data tidak bertambah

foto rizki198
1 Kontribusi 0 Coto
3 bulan yang lalu
<?php

namespace App\Exports;
use App\ModelDataAsset2;
use App\Test;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Concerns\WithEvents;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;
use Maatwebsite\Excel\Events\AfterSheet;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;

class AssetExport implements FromView, ShouldAutoSize, WithEvents
{
    /**
    * @return \Illuminate\Support\Collection
    */

    public function view(): View
   {
       return view('exel_view', [
           'data' => ModelDataAsset2::all()
       ]);
   }


   public function registerEvents(): array
    {
        return [
            AfterSheet::class   => function(AfterSheet $event) {
                  $event->sheet->styleCells(
                       'A1:B1',[
                         //Set background Style
                              'fill' => [
                             'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                             'startColor' => [
                                 'rgb' => '92d050',
                              ]
                         ],
                      ]

                  );
                  $event->sheet->styleCells(
                       'C1:M1',[
                        //Set background Style
                             'fill' => [
                            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                            'startColor' => [
                                 'rgb' => 'ffff00',
                             ]
                        ],
                       ]

                  );
                  $event->sheet->styleCells(
                       'N1:AE1',[
                        //Set background Style
                             'fill' => [
                            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                            'startColor' => [
                                 'rgb' => 'ffc000',
                             ]
                        ],
                       ]

                  );
                  $event->sheet->styleCells(
                       'AF1:BA1',[
                        //Set background Style
                             'fill' => [
                            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                            'startColor' => [
                                 'rgb' => '00b0f0',
                             ]
                        ],
                       ]

                  );
                  $event->sheet->styleCells(
                       'BB1:BL1',[
                        //Set background Style
                             'fill' => [
                            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                            'startColor' => [
                                 'rgb' => '92d050',
                             ]
                        ],
                       ]

                  );
                  $event->sheet->styleCells(
                       'BM1:BS1',[
                        //Set background Style
                             'fill' => [
                            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                            'startColor' => [
                                 'rgb' => 'ff0000',
                             ]
                        ],
                       ]

                  );
                  $event->sheet->styleCells(
                       'BT1:CN1',[
                        //Set background Style
                             'fill' => [
                            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
                            'startColor' => [
                                 'rgb' => '929292',
                             ]
                        ],
                       ]

                  );
            },
        ];
    }




}
saya pake laravel Maatwebsite, saya mau export data dari database ke excel, pertama kali export berhasil tapi setelah saya tambahin data baru di database terus saya export lagi ternyata si data baru ini ga nambah.. Tolong bantu saya..
  • tolong codenya dipaste kan disini sesuai dengan kaidah forum :) - driyan


Login untuk diksusi di forum sekolah koding