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 vote127 views1 answer
This domain is not registered with Tiny Cloud. Please see the quickstart guide or create an account.
PHP
0 vote137 views1 answer
Laravel collection intersectKey
PHP
3 votes113 views1 answer
Php stric type
PHP
0 vote108 views1 answer
500 Internal Server Error mamp rest api PDO
PHP
79 votes123 views2 answers
Str_contains
PHP
0 vote121 views1 answer
Symfony\Component\HttpKernel\Exception\NotFoundHttpException: POST http://localhost/post
PHP
14 votes123 views6 answers
Install php 8 ubuntu
PHP
0 vote114 views1 answer
Red rose
PHP
7 votes126 views1 answer
Php autoload sem composer
PHP
4 votes145 views2 answers
Validate year laravel
PHP