PHPOffice/HPExcel設定セル色、行幅、太字

シーン

.    php            
.               

解決する

.   

$excel_php = new \PHPExcel();
$obj_color = ($product['diff_count'] > 0) ? \PHPExcel_Style_Color::COLOR_BLUE : \PHPExcel_Style_Color::COLOR_RED;
$excel_php->setActiveSheetIndex(0)->getStyle('H' . $row)->getFont()->getColor()->setARGB($obj_color);

.   

            //       
            $item_cell = 'A';
            $excel_php->setActiveSheetIndex(0)
                ->getColumnDimension($item_cell)
                ->setAutoSize(true);

.   
    1.      

             $item_cell = 'A';
            $excel_php->setActiveSheetIndex(0)->getStyle($item_cell . 1)->applyFromArray(
                [
                    'font' => ['bold' => true],
                    'alignment' => ['horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER]
                ]
            );

    2.      

$excel_php->setActiveSheetIndex(0)->getStyle("A2:A19")->getFont()->setBold(true);

.   
    1.     

     $excel_php->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $excel_php->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);