$styleArray = [
'alignment' => [
'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT,
]
];
$spreadsheet->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
opacity: 0; на display:none, то где-то надо поменять opacity: 1; на display:block :)