欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

php 导出excel类

程序员文章站 2024-01-10 16:23:16
...
/**

* excel导出类

*

* 使用方法

$excel=new Excel();

* //设置编码:

*$excel->setEncode("utf-8","gb2312"); //如果不转码,参数写一样即可,例如$excel->setEncode("utf-8","utf-8");

* //设置标题栏

* $titlearr=array("a","b","c","d");

* //设置内容栏

* $contentarr=array(

* 1=>array("ab","ac","ad","ae"),

* 2=>array("abc","acc","adc","aec"),

* 3=>array("abd","acd","add","aed"),

* 4=>array("abe","ace","ade","aee"),

* );

* $excel->getExcel($titlearr,$contentarr,"abc");

*/

class Excel {

var $inEncode; //一般是页面编码


var $outEncode; //一般是Excel文件的编码


public function __construct(){


}

/**

*设置编码

*/

public function setEncode($incode,$outcode){

$this->inEncode=$incode;


$this->outEncode=$outcode;

}

/**

*设置Excel的标题栏

*/

public function setTitle($titlearr){

$title="";

foreach($titlearr as $v){

if($this->inEncode!=$this->outEncode){

$title.=iconv($this->inEncode,$this->outEncode,$v)."\t";

}

else{

$title.=$v."\t";

}

}

$title.="\n";

return $title;

}

/**

*设置Excel内容

*/

public function setRow($array){

$content="";

foreach($array as $k => $v){

foreach($v as $vs){

if($this->inEncode!=$this->outEncode){

$content.=iconv($this->inEncode,$this->outEncode,$vs)."\t";

}

else{

$content.=$vs."\t";

}

}

$content.="\n";

}

return $content;

}

/**

*生成并自动下载Excel

* $titlearr 标题栏数组

* $array 内容数组

* $filename 文件名称 (为空,已当前日期为名称)

*/

public function getExcel($titlearr,$array,$filename=''){

if($filename==''){

$filename=date("Y-m-d");

}

$title=$this->setTitle($titlearr);

$content=$this->setRow($array);

header("Content-type:application/vnd.ms-excel");

header("Content-Disposition:filename=".$filename.".xls");

echo $title;

echo $content;

}

}

相关标签: php 导出excel类