PHP ==> XLS

Contoh PHP ekspor ke format file XLS.
1. Buat Fungsi untuk XLS

fungsi xlsBOF () (
echo pack ("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0,
0x0);
kembali;
)
fungsi xlsEOF () (
echo pack ("ss", 0x0A, 0x00);
kembali;
)
fungsi xlsWriteNumber ($ Row, $ Col, $ Value) (
gema pack ("sssss", 0x203, 14, $ Row, $ Col,
0x0);
echo pack ("d", $ Value);
kembali;
)
fungsi xlsWriteLabel ($ Row, $ Col, $ Value) (
$ L = strlen ($ Value);
echo pack ("ssssss", 0x204, 8 + $ L, $ Row, $
Col, 0x0, $ L);
echo $ Value;
kembali;
)

2. Kirim Header ke Browser dalam format
download.

/ Query Database /
$ hasil = mysql_db_query ($ dbname, "select id,
prename, nama, sname, grade dari appdata
mana saja '$ courseid =' dan detik '$ bagian ='")
/ / Kirim Header
header ("pragma: umum");
header ("Berakhir: 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-Disposisi: lampiran; nama file =
$ courseid-$ sec.xls "); / / À ¹ ° ¥ à ¹ ‰ ° § ° ™ °
μà ¹ à ¹ ° ‡ ° S ° à ¹ · ° à ¹" ° ¸ ¥ à ya ¹ œ
header ("Content-Transfer-Encoding: binary");
/ / XLS Data Cell
xlsBOF ();
xlsWriteLabel (1, 0, "Student Register $ semester /
$ tahun");
xlsWriteLabel (2, 0, "COURSENO:");
xlsWriteLabel (2, 1, "$ courseid");
xlsWriteLabel (3, 0, "JUDUL:");
xlsWriteLabel (3, 1, "$ title");
xlsWriteLabel (4 0, "SETION:");
xlsWriteLabel (4, 1, "$ sec");
xlsWriteLabel (6, 0, "NO");
xlsWriteLabel (6, 1, "ID");
xlsWriteLabel (6, 2, "Gender");
xlsWriteLabel (6, 3, "Nama");
xlsWriteLabel (6, 4, "NamaBelakang");
$ XlsRow = 7;
sementara (daftar ($ id, $ prename, $ nama, $
sname, $ grade) = mysql_fetch_row ($ hasil)) (
+ + $ I;
xlsWriteNumber ($ xlsRow, 0, "$ i");
xlsWriteNumber ($ xlsRow, 1, "$ id");
xlsWriteLabel ($ xlsRow, 2, "$ prename");
xlsWriteLabel ($ xlsRow, 3, "$ nama");
xlsWriteLabel ($ xlsRow, 4, "$ sname");
xlsRow $ + +;
)
xlsEOF ();
exit ();