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 vote134 views1 answer
Laravel faker boolean
PHP
0 vote135 views1 answer
Allow shortocde the_excerept
PHP
1 vote158 views1 answer
Vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
PHP
0 vote133 views1 answer
Put multiple string in one echo in php
PHP
0 vote143 views1 answer
7 reasons why Lee is an idiot
PHP
0 vote144 views1 answer
@lang laravel blade
PHP
0 vote127 views3 answers
Php convert link to embed youtube
PHP
15 votes239 views4 answers
Wordpress thumbnail url
PHP Wordpress
0 vote155 views1 answer
'laravel'
PHP Laravel
12 votes147 views5 answers
Php get first 10 elements of array
PHP