PHP实现导出Excel文件通用方法

1. /**
2. * 导出数据为excel表格
3. *@param $data 一个二维数组,结构如同从数据库查出来的数组
4. *@param $title excel的第一行标题,一个数组,如果为空则没有标题
5. *@param $filename 下载的文件名
6. *@examlpe
7. $stu = M ('User');
8. $arr = $stu -> select();
9. exportexcel($arr,array('id','账户','密码','昵称'),'文件名!');
10. */
11. function exportexcel($data=array(),$title=array(),$filename='report'){
12. header("Content-type:application/octet-stream");
13. header("Accept-Ranges:bytes");
14. header("Content-type:application/vnd.ms-excel");
15. header("Content-Disposition:attachment;filename=".$filename.".xls");
16. header("Pragma: no-cache");
17. header("Expires: 0");
18. //导出xls 开始
19. if (!empty($title)){
20. foreach ($title as $k => $v) {
21. $title[$k]=iconv("UTF-8", "GB2312",$v);
22. }
23. $title= implode("\t", $title);
24. echo "$title\n";
25. }
26. if (!empty($data)){
27. foreach($data as $key=>$val){
28. foreach ($val as $ck => $cv) {
29. $data[$key][$ck]=iconv("UTF-8", "GB2312", $cv);
30. }
31. $data[$key]=implode("\t", $data[$key]);
33. }
34. echo implode("\n",$data);
35. }
36. }

复制代码

PHP, Excel