phpからExcel形式ファイルをエクスポートする例

function xlsBOF() {
echo Pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
return;
}
function xlsEOF() {
echo Pack ("ss", 0x0A, 0x00);
return;
}
function xlsWriteNumber($Row, $Col, $Value) {
echo Pack("sssss", 0x203, 14, $Row, $Col, 0x0);
echo Pack("d", $Value);
return;
}
function xlsWriteLabel($Row, $Col, $Value ) {
$L = strlen($Value);
echo Pack("ssssss", 0x204 , 8 + $L, $Row, $Col, 0x0, $L);
echo $Value;
return;
}

2，向浏览器送信ヘッダー，下載xls文件

// クエリデータベース
$result=mysql_db_query($dbname,"select id,prename,name,sname,grade from appdata where course='$courseid' and sec='$section '")
// ヘッダーを送信
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=$courseid-$sec.xls ");
header("Content-Transfer-Encoding: binary ");
// XLS Data Cell
xlsBOF();
xlsWriteLabel(1,0,"Student Register $semester/$year");
xlsWriteLabel(2,0, "コース : ");
xlsWriteLabel(2,1,"$コースid");
xlsWriteLabel(3,0,"TITLE : ");
xlsWriteLabel(3,1,"$title");
xlsWriteLabel(4, 0,"SETION : ");
xlsWriteLabel(4,1,"$sec");
xlsWriteLabel(6,0,"NO");
xlsWriteLabel(6,1,"ID");
xlsWriteLabel(6, 2,"性別");
xlsWriteLabel(6,3,"名前");
xlsWriteLabel(6,4,"姓");
$xlsRow = 7;
while(list($id,$prename,$name) ,$sname,$grade)=mysql_fetch_row($result)) {
++$i;
xlsWriteNumber($xlsRow,0,"$i");
xlsWriteNumber($xlsRow,1,"$id");
 xlsWriteLabel($xlsRow,2,"$prename");
xlsWriteLabel($xlsRow,3,"$name");
xlsWriteLabel($xlsRow,4,"$sname");
$xlsRow++;
}
xlsEOF( );
exit();