dph19153 2019-03-13 11:54
浏览 1888
已采纳

如何在PHPSpreadsheet中对齐单元格值

i am trying for few days i don't know why its not working. I want to make cell value at middle. My output is coming like below:-

enter image description here

My expected output like below:-

enter image description here

I want every column must be i center i have tried below code:-

$styleArray = [
        'font' => [
            'bold' => true,
        ],
        'alignment' => [
            'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
        ],
        'fill' => [
            'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,
            'startColor' => [
                'argb' => '0070C0',
            ],
            'endColor' => [
                'argb' => '0070C0',
            ],
        ],
    ];
    $spreadsheet->getDefaultStyle()->getFont()->setSize(10);
    }

i Have tried all other attributes like HORIZONTAL_CENTER,RIGHT,LEFT,JUSTIFY..etc.Please help me how can i do this.

  • 写回答

1条回答 默认 最新

  • duandang9434 2019-03-13 11:57
    关注

    You're setting the wrong (and one too few) key(s) for the alignment setting. What you're attempting to achieve is the vertical and horizontal alignment of the text.

    'alignment' => [
        'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
    ],
    

    PhpSpreadsheet docs

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?