public function setStyle($cellRange, $fontFamily = 'Arial', $fontSize = 10, $colorRGB = '00000000', $bold = false, $italic = false, $underline = false) { require_once \GO::config()->root_path . 'go/vendor/PHPExcel/PHPExcel/Style.php'; require_once \GO::config()->root_path . 'go/vendor/PHPExcel/PHPExcel/Style/Font.php'; require_once \GO::config()->root_path . 'go/vendor/PHPExcel/PHPExcel/Style/Color.php'; $colorObj = new \PHPExcel_Style_Color(); $colorObj->setRGB($colorRGB); $fontObj = new \PHPExcel_Style_Font(); $fontObj->setName($fontFamily); $fontObj->setSize($fontSize); $fontObj->setColor($colorObj); $fontObj->setBold($bold); $fontObj->setItalic($italic); $fontObj->setUnderline($underline); $styleObj = new \PHPExcel_Style(); $styleObj->setFont($fontObj); $this->getActiveSheet()->setSharedStyle($styleObj, $cellRange); }