Huff.. akhirnya ketemu juga artikel yang ngebahas gimana caranya ngirim data dari PHP to EXCEL. Kalo ngga ada project yang sedikit memaksa buat mikir ini mungkin sampe kapanpun nggak akan kepikiran..
Kali ini aku ngutip dari Sini , jadi kalo ngga jalan jangan salahin siapa2 yagh, kali aja komputernya lagi sakit, hihihi….
sebelumnya buat dulu Database pake nama TUTORIAL, buat table dengan name NAME_LIST ( id(auto_increment), name(varchar, 50)) dan sisipkan records sekitar 20 – 30 ke table tersebut. trus 1 file excel (*.xls) , kasih nama ORDERLIST.xls, Sedangkan nama file yang kita buat alias skrip PHP disimpan di dalam file EXPORT_EXCEL.php
<?php
// Connect database.
mysql_connect(“localhost”,”",”");
mysql_select_db(“tutorial”);
// Get data records from table.
$result=mysql_query(“select * from name_list order by id asc”);
// Functions for export to excel.
function xlsBOF() {
echo pack(“ssssss”, 0×809, 0×8, 0×0, 0×10, 0×0, 0×0);
return;
}
function xlsEOF() {
echo pack(“ss”, 0×0A, 0×00);
return;
}
function xlsWriteNumber($Row, $Col, $Value) {
echo pack(“sssss”, 0×203, 14, $Row, $Col, 0×0);
echo pack(“d”, $Value);
return;
}
function xlsWriteLabel($Row, $Col, $Value ) {
$L = strlen($Value);
echo pack(“ssssss”, 0×204, 8 + $L, $Row, $Col, 0×0, $L);
echo $Value;
return;
}
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=orderlist.xls “);
header(“Content-Transfer-Encoding: binary “);
xlsBOF();
/*
Make a top line on your excel sheet at line 1 (starting at 0).
The first number is the row number and the second number is the column, both are start at ‘0′
*/
xlsWriteLabel(0,0,”List of car company.”);
// Make column labels. (at line 3)
xlsWriteLabel(2,0,”No.”);
xlsWriteLabel(2,1,”Company”);
$xlsRow = 3;
// Put data records from mysql by while loop.
while($row=mysql_fetch_array($result)){
xlsWriteNumber($xlsRow,0,$row['id']);
xlsWriteLabel($xlsRow,1,$row['name']);
$xlsRow++;
}
xlsEOF();
exit();
?>
