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

11 votes240 views4 answers
Laravel validator make custom message
PHP
1 vote233 views1 answer
Js change h1 value
PHP
1 vote253 views1 answer
Unless blade laravel
PHP Laravel
0 vote250 views1 answer
Determining if input is present in Laravel
PHP Laravel
1 vote220 views2 answers
Laravel return response with headers
PHP
0 vote333 views1 answer
Augmenter la dimension des fichiers WP
PHP Wordpress
0 vote281 views1 answer
How to run database Query in WordPress?
PHP Wordpress
3 votes238 views1 answer
Laravel check if array is empty
PHP
0 vote232 views1 answer
Advanced Custom Fields get sub field image
PHP
1 vote246 views1 answer
Laravel validateexception no error description
PHP