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:-
My expected output like below:-
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.