phpexcel 예제

<?

include_once($_SERVER[DOCUMENT_ROOT]."/new/inc/common.php");

include_once($_SERVER[DOCUMENT_ROOT]."/new/inc/PHPEXCEL/Classes/PHPExcel.php");

 

$objPHPExcel = new PHPExcel();

 

// 엑셀파일 타이틀 지정

$objPHPExcel->setActiveSheetIndex(0)

            ->setCellValue("A1", "ID")

            ->setCellValue("B1", "wr_subject")

            ->setCellValue("C1", "wr_content")

            ->setCellValue("D1", "wr_name")

            ->setCellValue("E1", "wr_email")

            ->setCellValue("F1", "wr_1")

            ->setCellValue("G1", "wr_2")

            ->setCellValue("H1", "wr_3");

 

$sql = "SELECT * FROM cp_employe";

$result = mysql_query($sql);

 

$i = 1;

while ($row = mysql_fetch_array($result)){

$i++;

$objPHPExcel->setActiveSheetIndex(0)

->setCellValue("A$i", $row[em_id]);

}

 

// Set active sheet index to the first sheet, so Excel opens this as the first sheet

$objPHPExcel->setActiveSheetIndex(0);

 

// 파일의 저장형식이 utf-8일 경우 한글파일 이름은 깨지므로 euc-kr로 변환해준다.

$filename = iconv("UTF-8", "EUC-KR", "Test");

 

header('Content-Type: application/vnd.ms-excel');

header('Content-Disposition: attachment;filename="' . $filename . '.xls"');

header('Cache-Control: max-age=0');

header("Content-Transfer-Encoding:binary");

header("Content-charset:euc-kr");

 

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('php://output');

?>