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 vote169 views1 answer
Php interview questions for experience
PHP
0 vote154 views1 answer
Pass array from controller laravel with compact
PHP
0 vote189 views1 answer
Laravel collection all
PHP Laravel
1 vote149 views2 answers
Laravel check if id in collection
PHP Laravel
0 vote160 views1 answer
Php build query from array
PHP
0 vote191 views1 answer
How to update all row in laravel
PHP Laravel
8 votes184 views4 answers
How to add linear gradient to an image
PHP
7 votes158 views2 answers
Php undefined index meaNING
PHP
0 vote143 views1 answer
Laraverl add collect
PHP Laravel
1 vote217 views1 answer
Check if input file is set codeigniter
PHP CodeIgniter