PHP에서 PHPExcel를 이용한 엑셀 다운로드 하기

<?php
    include "./PHPExcel-1.8/Classes/PHPExcel.php";

    $servername = "localhost";
    $username = "akibatv";
    $password = "akibatv";
    $dbname = "akibatv";

    // 데이터베이스 생성
    $conn = new mysqli($servername, $username, $password, $dbname);

    // 데이터베이스 접속
    if ($conn->connect_error) {
        die("데이터베이스 접속 실패 : " . $conn->connect_error);
    }

    $phpExcel = new PHPExcel();

    $phpExcel->setActiveSheetIndex(0);
    $phpExcel->getActiveSheet()
    ->setCellValue("A1", "NO.")
    ->setCellValue("B1", "이름")
    ->setCellValue("C1", "나이")
    ->setCellValue("D1", "생년월일")
    ->setCellValue("E1", "사이트URL");

    $sql = " SELECT * FROM test2 ";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $no = 1;
        $line = 2;
        while($row = $result->fetch_assoc()) {
            $phpExcel->setActiveSheetIndex(0)
            ->setCellValue("A".$line, $no)
            ->setCellValue("B".$line, $row['name'])
            ->setCellValue("C".$line, $row['age'])
            ->setCellValue("D".$line, $row['birthday'])
            ->setCellValue("E".$line, $row['site_url']);
            $no++;
            $line++;
        }
    }

    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="AkibaTV.xls"');
    header('Cache-Control: max-age=0');

    $objWriter = PHPExcel_IOFactory::createWriter($phpExcel, 'Excel5');
    $objWriter->save('php://output');

    $conn->close();
?>
Excel Download