August 2015 ~ mumunotes

Assalamualaikum Wr. Wb. Hello everybody. For along times i dont publish article. And now i will share to you all about export data table to excel file without extension.
Okay, lets go.
the first, add menu with url to /site/export in main.php.
Second, open SiteController file and change this code to it.

public function actionExport(){
    $model = Mahasiswa::find()->All();
    $filename = 'Data-'.Date('YmdGis').'-Mahasiswa.xls';
    header("Content-type: application/vnd-ms-excel");
    header("Content-Disposition: attachment; filename=".$filename);
    echo '<table border="1" width="100%">
        <thead>
            <tr>
                <th>Mim</th>
                <th>Nama</th>
                <th>Jurusan</th>
                <th>Angkatan</th>
                <th>Alamat</th>
                <th>Foto</th>
            </tr>
        </thead>';
        foreach($model as $data){
            echo '
                <tr>
                    <td>'.$data['nim'].'</td>
                    <td>'.$data['nama'].'</td>
                    <td>'.$data['jurusan'].'</td>
                    <td>'.$data['angkatan'].'</td>
                    <td>'.$data['alamat'].'</td>
                    <td><img src="'.Yii::$app->request->baseUrl.'/uploads/'.$data['foto'].'" width="100px"></td>
                </tr>
            ';
        }
    echo '</table>';

}