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