php excel 셀 스타일 메서드 정리

<?

// 텍스트 가운데 정렬
$this->excel->getActiveSheet()->getStyle("A1:K5")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

// 텍스트 세로 정렬
$this->excel->getActiveSheet()->getStyle('A2:K2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

// 테두리
$this->excel->getActiveSheet()->getStyle("A1:K5")->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

// 배경색
$this->excel->getActiveSheet()->getStyle("A1:K1")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB("FFD3D3D3");

// 배경색2
$this->excel->getActiveSheet()->getStyle("A2")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB("FFFFFF00");
$this->excel->getActiveSheet()->getStyle("C2:H2")->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB("FFFFFF00");

// 볼드체 변경
$this->excel->getActiveSheet()->getStyle('A2')->getFont()->setBold(true);
$this->excel->getActiveSheet()->getStyle('C2:H2')->getFont()->setBold(true);

// 개행처리
$this->excel->getActiveSheet()->getStyle('F2')->getAlignment()->setWrapText(true);

// 셀 병합
$this->excel->getActiveSheet()->mergeCells('A1:E1');

// 폰트 크기
$this->excel->getActiveSheet()->getStyle('A1')->getFont()->setSize(18);


?>