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

0 vote190 views1 answer
Text or description laravel database column type
PHP Laravel
-2 votes155 views1 answer
Find largest element of an array in php
PHP
1 vote176 views4 answers
Create laravel project specific version
PHP Laravel
18 votes195 views1 answer
Schema::default string laravel
PHP Laravel
1 vote146 views1 answer
Forelse in laravel
PHP Laravel
0 vote187 views1 answer
Dump die laravel
PHP Laravel
5 votes182 views2 answers
Laravel group by with where clause
PHP Laravel
0 vote142 views1 answer
En php comment convertir une date en français stackoverflow
PHP
0 vote161 views1 answer
Wordpress translate specific text php
PHP Wordpress
0 vote191 views2 answers
Laravel allow all fillable
PHP Laravel