Stefan H
Stefan H

Reputation: 1063

laravel maatwebsite-excel package: setting the column width does not work

I use version 3 of laravel maatwebsite-excel. I try to set the width of a column, to do that I use the PhpSpreadsheet native method in a AfterSheet event like this:

public function registerEvents(): array
{
    return [

        AfterSheet::class    => function(AfterSheet $event) {

            $event->sheet->getColumnDimension('D')->setWidth(32);
        }
    ]
 }

When i use: $event->sheet->getColumnDimension('D')->setVisible(false); it works, but setting the width doesn't have any effect.

Upvotes: 1

Views: 12080

Answers (2)

AbdulBasit
AbdulBasit

Reputation: 1409

If you are exporting form view you can directly use

style="word-wrap:break-word"

Just make sure your Export class is not implementing ShouldAutoSize

Upvotes: 0

Stefan H
Stefan H

Reputation: 1063

Need to set column autosize to false

$event->sheet->getColumnDimension('D')->setAutoSize(false);

Upvotes: 4

Related Questions