《PHP教程：PHP實(shí)現(xiàn)導(dǎo)出excel數(shù)據(jù)的類庫用法示例》要點(diǎn)：
本文介紹了PHP教程：PHP實(shí)現(xiàn)導(dǎo)出excel數(shù)據(jù)的類庫用法示例，希望對您有用。如果有疑問，可以聯(lián)系我們。
本文實(shí)例講述了PHP實(shí)現(xiàn)導(dǎo)出excel數(shù)據(jù)的類庫用法.分享給大家供大家參考,具體如下：PHP學(xué)習(xí)
今天一個項(xiàng)目要做一個PHP導(dǎo)出數(shù)據(jù)用excel保存,在網(wǎng)上找到一個本來是想用phpexcel的,后來發(fā)現(xiàn)太難了,就換了一個但導(dǎo)出的歌聲是XMLPHP學(xué)習(xí)
類寫的很簡單,但很實(shí)用.只能簡單的導(dǎo)出字符串和數(shù)字二種格式.PHP學(xué)習(xí)
如果你有興趣,你可以拿去擴(kuò)充了,基本夠用.PHP學(xué)習(xí)
class Excel_XML
{
//定于私有變量,頂部標(biāo)簽
private $header = "<?xml version=\"1.0\" encoding=\"%s\"?\>\n<Workbook xmlns=\"urn:schemas-microsoft-com:
office:spreadsheet\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns:ss=\"urn:schemas-microsoft-com:
office:spreadsheet\" xmlns:html=\"http://www.w3.org/TR/REC-html40\">";
//底部標(biāo)簽
private $footer = "</Workbook>";
//定于行數(shù)組
private $lines = array();
//設(shè)置編碼
private $sEncoding;
//設(shè)置類型
private $bConvertTypes;
//設(shè)置sheet名稱
private $sWorksheetTitle;
//構(gòu)造函數(shù)
public function __construct(
$sEncoding = 'UTF-8',$bConvertTypes = false,$sWorksheetTitle = 'Table1')
{
$this->bConvertTypes = $bConvertTypes;
$this->setEncoding($sEncoding);
$this->setWorksheetTitle($sWorksheetTitle);
}
//設(shè)置編碼,在構(gòu)造函數(shù)里面默認(rèn)的事UTF-8格式
public function setEncoding($sEncoding)
{
$this->sEncoding = $sEncoding;
}
//設(shè)置excel的頭
public function setWorksheetTitle ($title)
{
$title = preg_replace ("/[\\\|:|\/|\?|\*|\[|\]]/", "", $title);
$title = substr ($title, 0, 31);
$this->sWorksheetTitle = $title;
}
//增加行函數(shù)(關(guān)鍵函數(shù))
private function addRow ($array)
{
$cells = ""; //設(shè)置每個單元為空
foreach ($array as $k => $v)
{
$type = 'String'; //默認(rèn)類型是字符串
if ($this->bConvertTypes === true && is_numeric($v)): //判斷類型
{ $type = 'Number'; }
$v = htmlentities($v, ENT_COMPAT, $this->sEncoding);
$cells .= "<Cell><Data ss:Type=\"$type\">" . $v . "</Data></Cell>\n";
}
$this->lines[] = "<Row>\n" . $cells . "</Row>\n"; //寫入數(shù)組
}
//增加數(shù)組
public function addArray ($array)
{
foreach ($array as $k => $v)
{$this->addRow ($v);}
}
//導(dǎo)出xml
public function generateXML ($filename = 'excel-export')
{
$filename = preg_replace('/[^aA-zZ0-9\_\-]/', '', $filename);
header("Content-Type: application/vnd.ms-excel; charset=" . $this->sEncoding);
header("Content-Disposition: inline; filename=\"" . $filename . ".xls\"");
echo stripslashes (sprintf($this->header, $this->sEncoding));
echo "\n<Worksheet ss:Name=\"" . $this->sWorksheetTitle . "\">\n<Table>\n";
foreach ($this->lines as $line)
echo $line;
echo "</Table>\n</Worksheet>\n";
echo $this->footer;
}
}
原理很簡單,就是把數(shù)據(jù)數(shù)組,讀出來,再用XML的標(biāo)簽封上,在用php自帶的header()函數(shù)告訴游覽器,就可以了.PHP學(xué)習(xí)
調(diào)用：PHP學(xué)習(xí)
public function import()
{
$data = array(
1 => array ('學(xué)校名稱',"隊(duì)伍名稱")
);
foreach($this->team as $key=>$value)
{
array_push($data,array($key, $value));
}
$xls = new Excel_XML('UTF-8', false, 'My Test Sheet'); //實(shí)例化函數(shù)
$xls->addArray($data);
$xls->generateXML('school'); //導(dǎo)出并設(shè)置名稱
}
上面是的寫一個導(dǎo)出方式.在游覽器運(yùn)行就已經(jīng)導(dǎo)出數(shù)組$this->team 里面的鍵和值了.PHP學(xué)習(xí)
更多關(guān)于PHP相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《php操作office文檔技巧總結(jié)(包括word,excel,access,ppt)》、《PHP數(shù)組(Array)操作技巧大全》、《php排序算法總結(jié)》、《PHP常用遍歷算法與技巧總結(jié)》、《PHP數(shù)據(jù)結(jié)構(gòu)與算法教程》、《php程序設(shè)計(jì)算法總結(jié)》、《PHP數(shù)學(xué)運(yùn)算技巧總結(jié)》、《php正則表達(dá)式用法總結(jié)》、《PHP運(yùn)算與運(yùn)算符用法總結(jié)》、《php字符串(string)用法總結(jié)》及《php常見數(shù)據(jù)庫操作技巧匯總》PHP學(xué)習(xí)
希望本文所述對大家PHP程序設(shè)計(jì)有所幫助.PHP學(xué)習(xí)
轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/3039.html
