php excel의 메서드가 필요할 경우 아래 링크로 이동하길 바람
https://c-uncle-full-stack.tistory.com/168
php excel 셀 스타일 메서드 정리
excel->getActiveSheet()->getStyle("A1:K5")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);// 텍스트 세로 정렬$this->excel->getActiveSheet()->getStyle('A2:K2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTIC
blog.chanyongyang.com
<?
# 너비조절
$spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(20);
# 셀 배경색상 변경
$spreadsheet->getActiveSheet()->getStyle('A1:L1')->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('e9e9e9');
# 셀 배경색상 변경 - A1부터 L12까지 배경색상 변경
$spreadsheet->getActiveSheet()->getStyle('A1:L12')->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('e9e9e9');
# 셀 정렬 -> 가로정렬
# 가로정렬 -> 가운데 정렬
$spreadsheet->getActiveSheet()->getStyle("A1:H1")->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
# 가로정렬 -> 좌측 정렬
$spreadsheet->getActiveSheet()->getStyle("B2:B2")->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT);
# 가로정렬 -> 우측 정렬
$spreadsheet->getActiveSheet()->getStyle("F2:H2")->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT);
# 가로정렬 -> 양쪽 정렬
$spreadsheet->getActiveSheet()->getStyle("F2:H2")->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_JUSTIFY);
# 가로정렬 -> 병합된 셀 가운데 정렬
$spreadsheet->getActiveSheet()->getStyle("F2:H2")->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER_CONTINUOUS);
# 가로정렬 -> 균등 정렬
$spreadsheet->getActiveSheet()->getStyle("F2:H2")->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_DISTRIBUTED);
# 세로 정렬 -> 상단 정렬
$spreadsheet->getActiveSheet()->getStyle("A1:H1")->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP);
# 세로 정렬 -> 하단 정렬
$spreadsheet->getActiveSheet()->getStyle("A1:H1")->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_BOTTOM);
# 세로 정렬 -> 가운데 정렬
$spreadsheet->getActiveSheet()->getStyle("A1:H1")->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
# 세로 정렬 -> 양쪽 정렬
$spreadsheet->getActiveSheet()->getStyle("A1:H1")->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_JUSTIFY);
# 세로 정렬 -> 균등 정렬
$spreadsheet->getActiveSheet()->getStyle("A1:H1")->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_DISTRIBUTED);
//윤곽선
$spreadsheet->getActiveSheet()->getStyle('A1:L'.$i)->getBorders()->getAllBorders()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
귀찮으니 여기까지만... 나중에 생각나면 더 적겠음