php 导出excel类

安哥网络

详细使用方法，请进入http://www.cnlamp.org/?p=14查看

1. <?php
   
2. class Excel {
   
3. var $inEncode; //一般是页面编码
   
4. var $outEncode; //一般是Excel文件的编码
   
5. public function __construct(){
   
6. }
   
7. public function setEncode($incode,$outcode){
   
8. $this->inEncode=$incode;
   
9. $this->outEncode=$outcode;
   
10. }
    
11. public function setTitle($titlearr){
    
12. $title="";
    
13. foreach($titlearr as $v){
    
14. if($this->inEncode!=$this->outEncode){
    
15. $title.=iconv($this->inEncode,$this->outEncode,$v)."\t";
    
16. }
    
17. else{
    
18. $title.=$v."\t";
    
19. }
    
20. }
    
21. $title.="\n";
    
22. return $title;
    
23. }
    
24. public function setRow($array){
    
25. $content="";
    
26. foreach($array as $k => $v){
    
27. foreach($v as $vs){
    
28. if($this->inEncode!=$this->outEncode){
    
29. $content.=iconv($this->inEncode,$this->outEncode,$vs)."\t";
    
30. }
    
31. else{
    
32. $content.=$vs."\t";
    
33. }
    
34. }
    
35. $content.="\n";
    
36. }
    
37. return $content;
    
38. }
    
39. public function getExcel($titlearr,$array,$filename=''){
    
40. if($filename==''){
    
41. $filename=date("Y-m-d");
    
42. }
    
43. $title=$this->setTitle($titlearr);
    
44. $content=$this->setRow($array);
    
45. header("Content-type:application/vnd.ms-excel");
    
46. header("Content-Disposition:filename=".$filename.".xls");
    
47. echo $title;
    
48. echo $content;
    
49. }
    
50. }
    
51. 
    

复制代码