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

2 votes110 views1 answer
Php time format am pm
PHP
0 vote153 views1 answer
Pht get header from request
PHP
4 votes159 views3 answers
Laravel get auth user in constructor
PHP Laravel
0 vote147 views1 answer
Wpmu create user
PHP
0 vote134 views1 answer
Laravel 8 date difference in days
PHP Laravel
8 votes149 views1 answer
Laravel symlink command
PHP
8 votes137 views6 answers
Command not found: laravel
PHP Laravel
0 vote118 views1 answer
Find only selected columns
PHP
2 votes135 views2 answers
Check if date between two dates laravel
PHP
0 vote131 views1 answer
Codeigniter 4 radio button isset
PHP