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 vote148 views1 answer
Wp retrieve acf by category name
PHP Wordpress
0 vote135 views1 answer
How check the checkbox is check php
PHP
1 vote155 views2 answers
Get the value without setter method laravel
PHP Laravel
0 vote127 views1 answer
How to pass variable to an event listener laravel
PHP
6 votes187 views3 answers
Laravel ide-helper
PHP Laravel
1 vote140 views2 answers
Wordpress get option value
PHP Wordpress
20 votes195 views5 answers
Php artisan cache all
PHP
2 votes141 views2 answers
Laravel run controller from command line
PHP
0 vote157 views1 answer
Multi theme laravel
PHP Laravel
15 votes147 views3 answers
Laravel date set timezone
PHP Laravel