Export Report as Excel & Doc

ExportReport.php

public function exportReport($report_id,$type){
        $reportData = $this->getReportById($report_id);
        $filename=preg_replace("/[^a-zA-Z]+/", "", $reportData['REPORT_TITLE']);
        include_once "report_helper.php";
        if($type =='word'){
            header('Content-Type: application/msword');
            header("Content-Disposition: attachment; filename=$filename.doc");
        }else{
            header("Content-Type:   application/vnd.ms-excel; charset=utf-8");
            header("Content-Disposition: attachment; filename=$filename.xls");
        }
        //File name extension was wrong
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Cache-Control: private",false);
        report_gen_exp($reportData['REPORT_DATA'],$reportData['REPORT_TITLE']);
        exit();

}
    
 public function report_gen_exp($data,$report_title){
    ?>
    <table border="1">
        <caption><h2><?php echo $report_title; ?></h2></caption>
        <?php if (count($data) > 0) { ?>
            <thead>
            <tr>
                <?php foreach ($data[0] as $key => $value) {echo '<th>' . $key . '</th>';} ?>
            </tr>
            </thead>
            <tbody>
            <?php foreach ($data as $row): ?>
                <tr>
                    <?php foreach ($row as $key=>$field_value):?>
                        <td><?php echo $field_value . '&nbsp;'; ?></td>
                    <?php endforeach;?>
                </tr>
            <?php endforeach; ?>
            </tbody>
        <?php
        } else {
            echo '<caption><h4>Data Not Found!</h4></caption>';
        }
        ?>
    </table>
<?php
}