phpexcel format cell text color code example

Example: phpexcel set font color

$this->PhpExcel->createSheet($page);
$this->PhpExcel->setActiveSheetIndex($page);
$sheet = $this->PhpExcel->getActiveSheet();

$sheet->getStyle("A8:C8")->getFont()->setBold(true)
->setName('Arial')
->setSize(14)
->getColor()
->setRGB('FFFFFF');
$sheet->getStyle("A8:C8")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

Tags:

Php Example

Related