muncul sebagai excel

<?php
error_reporting(0);
mysql_connect("localhost","root","root");
mysql_select_db("pln2");
$qry_data=mysql_query("SELECT c.TGL, a.NM_ENTRY, b.NM, b.ALAMAT, c.ID_PEL, c.NO_METER, c.DY_BR, c.GARDU, c.TIANG, b.KET FROM t_tim a, tm_plg b, td_plg c, t_token d, t_kasir e, t_material f WHERE a.C_TIM=b.C_TIM and b.NO_MAT=f.NO_MAT and b.NO_KSR=e.NO_KSR and c.NO_TOKEN=d.NO_TOKEN and a.C_TIM=d.C_TIM and a.C_TIM=e.C_TIM and a.C_TIM=f.C_TIM and b.KTP=c.KTP");

/*
BANYAK AMAT... padahal cuma 2 cukup
// Mendeklarasikan file hasil laporan
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Disposition: attachment;filename=nilai.xls");
header("Content-Transfer-Encoding: binary ");
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition:attachment;filename=datapelanggan.xls");
header("Content-Transfer-Encoding: binary ");*/

header('Content-type: application/vnd.ms-excel');
/*
line ke 2 lebih baik dipake biar ada perintah downloadnya
kalau ngak butuh.. hapus aja yg dibawah ini
*/
header('Content-Disposition: attachment;'.
    ' filename="read_'.date('Ymd').'.xls');

xlsBOF();
// Membuat Header dan nama kolom tabel
xlsBuatLabel(0,0,"DAFTAR DATA PELANGGAN");

$s=xlsBuatLabel( "Nama");
$s.=xlsBuatLabel( "Alamat");
$s.=xlsBuatLabel( "No. Pelanggan");
$s.=xlsBuatLabel "No. Meter");
$s.=xlsBuatLabel( "Daya");
$s.=xlsBuatLabel( "Gardu");
$s.=xlsBuatLabel( "Tiang");
$s.=xlsBuatLabel( "Penyetor");
xlsBuatList($s);$s='';
$xlsRow = 3;
// Menampilkan data secara berulang
while($data=mysql_fetch_array($qry_data)){
    $s.=xlsBuatBaris( "Tanggal       :".$data['TGL']);
    $s.=xlsBuatBaris( "Petugas Entry :".$data['NM_ENTRY']);
    $s.=xlsBuatBaris( $data['NM']);
    $s.=xlsBuatBaris( $data['ALAMAT']);
    $s.=xlsBuatBaris( $data['ID_PEL']);
    $s.=xlsBuatBaris( $data['NO_METER']);
    $s.=xlsBuatBaris($data['DY_BR']);
    $s.=xlsBuatBaris( $data['GARDU']);
    $s.=xlsBuatBaris( $data['TIANG']);
    $s.=xlsBuatBaris( $data['KET']);
    $xlsRow++;
    $s=xlsBuatList($s);$s='';
}
xlsEOF();
exit();


/*
Dengan menyesal fungsi kamu terpaksa saya hapus
*/

// Fungsi saat data kosong
function xlsBOF() {
    echo "<table>";

}
// Fungsi saat data berakhir
function xlsEOF() {
    echo "</table>"

}
// Fungsi membuat baris data
function xlsBuatBaris( $Value) {

    return "<td>$Value&nbsp;</td>";
}
// Fungsi menuliskan data bentuk label
function xlsBuatLabel( $Value ) {
    $L = strlen($Value);
    return "<th>$L&nbsp;</th>";

}

function xlsBuatList($v)
{
    return "\n\t<tr>$v</tr>";
}
?>