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 vote157 views3 answers
Square Images
PHP
2 votes146 views1 answer
Add id to route name in laravel blade
PHP Laravel
0 vote178 views1 answer
Laravel relation select fields
PHP Laravel
-1 vote138 views1 answer
How to get data in phpp
PHP
0 vote147 views1 answer
Cakephp extract array
PHP
48 votes186 views2 answers
Laravel check my laravel version
PHP Laravel
0 vote88 views0 answer
PHP
0 vote146 views1 answer
Wpdb->prepare
PHP
-1 vote129 views1 answer
Php include file from file included before
PHP
0 vote147 views1 answer
Php value to javascript variable laravel blade
PHP Laravel