php导出excel格式文件的例子

2. function xlsBOF() {
3. echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
4. return;
5. }
6. function xlsEOF() {
7. echo pack("ss", 0x0A, 0x00);
8. return;
9. }
10. function xlsWriteNumber($Row, $Col, $Value) {
11. echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
12. echo pack("d", $Value);
13. return;
14. }
15. function xlsWriteLabel($Row, $Col, $Value ) {
16. $L = strlen($Value);
17. echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
18. echo $Value;
19. return;
20. }

复制代码

2，向浏览器发送header，下载xls文件

2. // Query Database
3. $result=mysql_db_query($dbname,"select id,prename,name,sname,grade from appdata where course='$courseid' and sec='$section'")
4. // Send Header
5. header("Pragma: public");
6. header("Expires: 0");
7. header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
8. header("Content-Type: application/force-download");
9. header("Content-Type: application/octet-stream");
10. header("Content-Type: application/download");;
11. header("Content-Disposition: attachment;filename=$courseid-$sec.xls ");
12. header("Content-Transfer-Encoding: binary ");
13. // XLS Data Cell
14. xlsBOF();
15. xlsWriteLabel(1,0,"Student Register $semester/$year");
16. xlsWriteLabel(2,0,"COURSENO : ");
17. xlsWriteLabel(2,1,"$courseid");
18. xlsWriteLabel(3,0,"TITLE : ");
19. xlsWriteLabel(3,1,"$title");
20. xlsWriteLabel(4,0,"SETION : ");
21. xlsWriteLabel(4,1,"$sec");
22. xlsWriteLabel(6,0,"NO");
23. xlsWriteLabel(6,1,"ID");
24. xlsWriteLabel(6,2,"Gender");
25. xlsWriteLabel(6,3,"Name");
26. xlsWriteLabel(6,4,"Lastname");
27. $xlsRow = 7;
28. while(list($id,$prename,$name,$sname,$grade)=mysql_fetch_row($result)) {
29. ++$i;
30. xlsWriteNumber($xlsRow,0,"$i");
31. xlsWriteNumber($xlsRow,1,"$id");
32. xlsWriteLabel($xlsRow,2,"$prename");
33. xlsWriteLabel($xlsRow,3,"$name");
34. xlsWriteLabel($xlsRow,4,"$sname");
35. $xlsRow++;
36. }
37. xlsEOF();
38. exit();

复制代码