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 vote282 views1 answer
Launch new tab and refresh original page codeigniter
PHP
0 vote337 views1 answer
Laravel simplexmlelement not found
PHP Laravel
0 vote351 views2 answers
Wordpress wp_logout_url redirect
PHP Wordpress
4 votes325 views3 answers
Ubuntu where are laravel logs stored
PHP Laravel
0 vote272 views1 answer
Category title in post
PHP
3 votes409 views6 answers
Email verification laravel
PHP Laravel
4 votes268 views2 answers
Php slice last arrat
PHP
0 vote343 views1 answer
Laravel migration type to store html
PHP Laravel
1 vote334 views1 answer
Laravel createmany example
PHP Laravel
3 votes281 views2 answers
Php foreach json object
PHP