Php spreadsheet styles

$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID);
$spreadsheet->getActiveSheet()->getStyle('B2')
    ->getFill()->getStartColor()->setARGB('FFFF0000');

Source: phpspreadsheet.readthedocs.io

Similar codes

1 vote206 views1 answer
Php quotations within quotations
PHP
0 vote183 views1 answer
Bagisto package generator
PHP
43 votes219 views2 answers
Php can't upload gif
PHP
0 vote180 views1 answer
Wp create menu location
PHP
0 vote178 views1 answer
Laravel migrate error default character 199 boot
PHP Laravel
0 vote172 views3 answers
Laravel how to fetch user from user model based on id from post
PHP
4 votes198 views4 answers
Laravel carbon today date format
PHP Laravel
4 votes205 views4 answers
Wordpress get theme uri
PHP Wordpress
2 votes166 views2 answers
Shuffle php function
PHP
0 vote164 views1 answer
Woocommerce remove payment method when totla is 0
PHP