Laravel Excel Freeze Pane

This is how you freeze a column or a row when using Laravel Excel.

<?php
class User implements WithEvents
{
    public function registerEvents(): array
    {
        return [
            AfterSheet::class => function(AfterSheet $event) {
              $event->sheet->freezePane('B1');
            },
        ];
    }
}

See how to freeze pane from PhpSpreadsheet/Worksheet.php on GitHub.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.