1. 배경색, 글자색, 하이퍼링크, 셀타입
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("text")
->setLastModifiedBy("text")
->setTitle('text')
->setSubject('text')
->setDescription('text')
->setKeywords('text')
->setCategory('text');
$sheet = $objPHPExcel->setActiveSheetIndex(0);
$i=1;
$sheet->setCellValue('A'.$i, '번호')
->setCellValue('B'.$i, '설명')
->setCellValue('C'.$i, '가격')
->setCellValue('D'.$i, '상품명');
$sheet->getStyle('A1:D1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$sheet->getStyle('A1:D1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$sheet->getStyle('A1:D1')->getFill()->getStartColor()->setARGB('FF808080');
$sheet->getStyle('A1:D1')->getFont()->setBold(true);
$sheet->getStyle('A1:D1')->getFont()->getColor()->setARGB('FFFFFFFF');
//
$sheet->getColumnDimension('A')->setWidth(14);
$sheet->getColumnDimension('B')->setWidth(14);
$sheet->getColumnDimension('C')->setWidth(14);
$sheet->getColumnDimension('D')->setWidth(100);
$sheet->getStyle('A2:A'.(count($res['items'])+1))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
foreach ($items as $r) {
$i++;
$url = 'http://test.com/'.$r['no'];
$objRichText3 = new PHPExcel_RichText();
$objRichText3->createText("Hello ");
$sheet->setCellValue('A'.$i, $r['no'])
->setCellValue('B'.$i, $r['desc'])
->setCellValue('C'.$i, $r['amt'])
->setCellValue('D'.$i, $r['title']);
$a_text = new PHPExcel_RichText();
$a_text->createText($r['no']);
$a_text->createTextRun($r['no'])->getFont()->setUnderline(true);
$sheet->getCell('A'.$i)->setValue($a_text);
$sheet->getCell('A'.$i)->getHyperlink()->setUrl($url);
}
