php 導(dǎo)出excel類
2018-07-20 來(lái)源：open-open
/**
* excel導(dǎo)出類
*
* 使用方法
$excel=new Excel();
* //設(shè)置編碼：
*$excel->setEncode("utf-8","gb2312"); //如果不轉(zhuǎn)碼，參數(shù)寫一樣即可，例如$excel->setEncode("utf-8","utf-8");
* //設(shè)置標(biāo)題欄
* $titlearr=array("a","b","c","d");
* //設(shè)置內(nèi)容欄
* $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; //一般是頁(yè)面編碼
var $outEncode; //一般是Excel文件的編碼
public function __construct(){
}
/**
*設(shè)置編碼
*/
public function setEncode($incode,$outcode){
$this->inEncode=$incode;
$this->outEncode=$outcode;
}
/**
*設(shè)置Excel的標(biāo)題欄
*/
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;
}
/**
*設(shè)置Excel內(nèi)容
*/
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;
}
/**
*生成并自動(dòng)下載Excel
* $titlearr 標(biāo)題欄數(shù)組
* $array 內(nèi)容數(shù)組
* $filename 文件名稱 (為空，已當(dāng)前日期為名稱)
*/
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;
}
}
標(biāo)簽： isp
版權(quán)申明：本站文章部分自網(wǎng)絡(luò)，如有侵權(quán)，請(qǐng)聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點(diǎn)！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請(qǐng)與原作者聯(lián)系。
最新資訊
熱門推薦