Export Tabel Ke Xls

Tambahkan kode berikut pada page yg menampilkan tabel dibaris paling atas

<?php
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=Data Pegawai.xls");
?>

Contoh :

<?php
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=hasil export.xls");
?>

<table>
<tr><td>nama</td><td>umur</td></tr>
<tr><td>ani</td><td>1</td></tr>
<tr><td>budi</td><td>2</td></tr>
<tr><td>cika</td><td>3</td></tr>
</table>