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

22 votes179 views6 answers
Php artisan make:auth laravel 8
PHP
0 vote148 views1 answer
Phpserver
PHP
0 vote254 views1 answer
Cloudinary laravel
PHP
0 vote240 views1 answer
Comment supprimer les onglets WooCommerce dans WordPress
PHP
0 vote227 views1 answer
Get if bowser supports webp php
PHP
0 vote210 views1 answer
Laravel creating event get data
PHP
0 vote214 views1 answer
Wordpress custom post type disable add new
PHP Wordpress
5 votes192 views1 answer
Laravel rate limit
PHP Laravel
0 vote185 views1 answer
Php interview questions for experience
PHP
1 vote205 views1 answer
Laravel get next record
PHP