Laravel-excel: Center all cells?

Created on 19 Aug 2015  路  2Comments  路  Source: Maatwebsite/Laravel-Excel

Is there a way to center the text in all cells? The number of rows will vary based on user interaction, as will the number of cells. So I need a way to set an overall alignment for the sheet.

picture opheliadesign

Most helpful comment

Hello, you can try to do this:

Excel::create('Filename', function($excel) {
    $excel->getDefaultStyle()
        ->getAlignment()
        ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER)
});
picture patrickbrouwers on 20 Aug 2015
👍4

All 2 comments

Hello, you can try to do this:

Excel::create('Filename', function($excel) {
    $excel->getDefaultStyle()
        ->getAlignment()
        ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER)
});
patrickbrouwers picture patrickbrouwers on 20 Aug 2015
👍4

Also to vertically center the text:

->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER)
topherseance picture topherseance on 24 Jun 2018
Was this page helpful?
0 / 5 - 0 ratings

Related issues

thearabbit picture thearabbit  路  3Comments
alejandri picture alejandri  路  3Comments
dr3ads picture dr3ads  路  3Comments
disto picture disto  路  3Comments
octoxan picture octoxan  路  3Comments