export to excel

<?php include "koneksi.php"; ?>


<?php $isi ='
    <table align="center">
    <tr>
    <th colspan="8" ><font size="5" weight="bold">CETAK DATA ANGGOTA</font></th>
    </tr>
    <tr>
    <td>&nbsp;</td>
    </tr>
    </table>
    ';?>
    <?php $isi .="\n";?>
<?php $isi .='
    <table border="0" width="100%">
    <tr>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">No</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">NAP</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">No.KTP</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">Nama Anggota</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">Tempat tanggal lahir</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">Jenis Kelamin</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">Kecamatan</font></th>
    <th bgcolor="#BCBCBC" border="0" align="center"><font size="2">Alamat</font></th>
</tr>
';?>
<?php
$query=mysql_query("select * from data_anggota order by id asc");
$no=0;
while($row=mysql_fetch_array($query)){
   $no++;
   if($no%2==0){
    $bgcolor = "bgcolor=\"#c3ffb1\"";
    }
    else{
    $bgcolor = "bgcolor=\"#f5fbb7\"";
    }
    ?>
<?php $isi .='
    <tr>
        <td '.$bgcolor.'><font size="2">'.$no.'</font></td>
        <td '.$bgcolor.'><font size="2">'.$row['reg_nap'].'.'.sprintf('%07s',$row['id']).'</font></td>
        <td '.$bgcolor.'><font size="2">'.$row['nomor_ktp'].'</font></td>
        <td '.$bgcolor.'><font size="2">'.$row['nama_lengkap'].'</td>
        <td '.$bgcolor.'><font size="2">'.$row['tempat_lahir'].','.$row['tanggal_lahir'].'</font></td>
        <td '.$bgcolor.'><font size="2">'.$row['kelamin'].'</font></td>
        <td '.$bgcolor.'><font size="2">'.$row['kecamatan'].'</font></td>
        <td '.$bgcolor.'><font size="2">'.$row['alamat'].'</font></td>
    </tr>';?>
    <?php
}
?>
<?php $isi .='</table>';?>
<?php
if(isset($_GET['act'])&&$_GET['act']==true){
header("Content-type: application/xls");
header("Content-Disposition: attachment;Filename=namafile.xls");
echo $isi;
return;
}else{
    echo $isi;
}
?>
<a href="exp2.php?act=true" ><img src="excel-icon.jpeg" width="18" height="18" border="0"   );"></a>