Laravel Excel vertical align center

php laravel maatwebsite-excel
Furya picture Furya · Aug 17, 2018 · Viewed 10.4k times · Source

How can I verticaly align center cells with laravel Excel ?

My code :

$sheet->cells('A1:'.$column_end.$i, function ($cells) {
                $cells->setBackground('#d8d8d8');
                $cells->setFontWeight('bold');
                $cells->setValignment('middle');
            });

But it doesn't work, most of my cells are vertically align bottom.

Maybe it's not middle !

I tried 'center' but it didn't work neither. When I tried 'top' or 'bottom' it worked.

So why 'middle' or 'center' didn't ?

Thank for your help.

Answer

Rafael picture Rafael · Aug 17, 2018

According to Laravel Excel Documentation, it should be:

$cells->setValignment('center');

Like you mentioned...

Try as a test, the setAlignment('center'), according to it, the behavior should be the same but for horizontal. If this one works, then the other one should for sure.

Related questions

Call to undefined method Maatwebsite\Excel\Excel::load()

I'm trying to import excel file (.xlsx) using maatwebsite 3.0. How to fix This error Call to undefined method Maatwebsite\Excel\Excel::load() My controller public function importsave(Request $request) { if($request->hasFile('excel')) { $path = $request->file('excel')-&…

Read More
Reading excel file in Laravel

I'm using Maatwebsite's library for reading and creating excel file. The creating was easy and somehow intuitive, but when it comes to reading one, I simply can't figure it out. This is how my excel file looks like: I figured …

Read More
Laravel excel maatwebsite 3.1 import, date column in excel cell returns as unknown format number. How to solve this?

By using Maatwebsite/Laravel-Excel version 3.1 to import excel sheet, here I faced an issue date time column of the excel sheet returns unknown number. How to solve this? Example : Consider Cell value "29/07/1989" and returns as "32178" when import.

Read More