PHPOffice/PHPExcel cell styling

phpoffice-phpexcel-styles.php

<?php

$excel = new \PHPExcel();

$sheet = $excel->getActiveSheet();
$sheet->getCell('A1')->setValue('test');
$style = new \PHPExcel_Style();
$style
    ->getFill()
    ->setStartColor(new \PHPExcel_Style_Color(\PHPExcel_Style_Color::COLOR_RED))
    ->setEndColor(new \PHPExcel_Style_Color(\PHPExcel_Style_Color::COLOR_RED))
    ->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)
;
$style
    ->getFont()
    ->setBold(true)
    ->setColor(new \PHPExcel_Style_Color(\PHPExcel_Style_Color::COLOR_YELLOW))
    ->setItalic(true)
    ->setUnderline(true)
    ->setSize(20);

$sheet->duplicateStyle($style, 'A1');

$writer = \PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
$writer->save('/tmp/test.xlsx');