Laravel-excel: set column width on view blade.

[thearabbit]

I export excel by blade view.
could i set column width on it?

[MaatwebsiteSupport]

See docs: http://www.maatwebsite.nl/laravel-excel/docs/export#sizing

[thearabbit]

I am difficult to set any styling at 2 places (excel and view).
If i am base on view, it should be can set only view.

[MaatwebsiteSupport]

Will be something for future release.

[bbrdaric]

Hello @Maatwebsite, I am trying to set column width but without success. Is that even possible when exporting from Blade view?

I have something like this

        Excel::create($filename, function($excel) use ($sheet_data) {
            $excel->sheet('Worksheet', function($sheet) use ($sheet_data) {
                $sheet->loadView('excel_template', $sheet_data);

                // Set width
                $sheet->setWidth('A', 100);
                $sheet->setWidth('B', 200);
                $sheet->setWidth('C', 300);

                // Set column format
                $sheet->setColumnFormat(array(
                    'D' => '#,##0.00'
                ));
            });

        })->download('xls');

Setting column width has no effect, but column format works as expected.

[MaatwebsiteSupport]

That should work. I will have a look at it.

[MaatwebsiteSupport]

Fixed

[riksnelders]

What version is it fixed on?
Using 2.1 and cant set width's in either blade or excel.

[abdulbasitnawab]

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