php生成excel文件源代碼

php教程生成excel文件源代碼

class excel{

??? /**
???? *頭的excel文件（前綴的行）
???? *
???? *從excel復(fù)制的xml規(guī)格。
???? *
???? * @訪問(wèn)私有
???? * @無(wú)功串
???? */
??? var $header = "
?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">";

??? /**
???? *頁(yè)腳的excel文件（附加到行）
???? *
???? *從excel復(fù)制的xml規(guī)格。
???? *
???? * @訪問(wèn)私有
???? * @無(wú)功串
???? */
??? var $footer = "";

??? /**
???? * document lines (rows in an array)
???? *
???? * @access private
???? * @var array
???? */
??? var $lines = array ();

??? /**
???? 工作表名稱
???? *
???? *包含一個(gè)單一的工作表名稱
???? *
???? * @訪問(wèn)私有
???? * @無(wú)功串
???? */
??? var $worksheet_title = "table1";

??? /**
? 添加一個(gè)單行的文檔字符串$
???? *
???? * @訪問(wèn)私有
???? * @帕拉姆庫(kù)馬拉陣列一維陣列
???? * @待辦事項(xiàng)行創(chuàng)造應(yīng)做減本-> addarray
???? */
??? function addrow ($array) {

??????? // initialize all cells for this row
??????? $cells = "";
???????
??????? // foreach key -> write value into cells
??????? foreach ($array as $k => $v):
???
??????? ?// 加個(gè)字符串與數(shù)字的判斷 避免生成的 excel 出現(xiàn)數(shù)字以字符串存儲(chǔ)的警告
??????? ?if(is_numeric($v)) {
??????? ??// 防止首字母為 0 時(shí)生成 excel 后 0 丟失
??????? ??if(substr($v, 0, 1) == 0) {
??????? ???$cells .= "" . $v . "n";
??????? ??} else {
??????? ???$cells .= "" . $v . "n";
??????? ??}
??????? ?} else {
??????????? ?$cells .= "" . $v . "n";
??????? ?}

??????? endforeach;

??????? // transform $cells content into one row
??????? $this->lines[] = "n" . $cells . "n";

??? }

??? /**
??? *添加一個(gè)數(shù)組到文檔
???? *
???? *這應(yīng)該是唯一的方法需要生成一個(gè)excel
???? *文件。
???? *
???? * @訪問(wèn)公開(kāi)
???? * @帕拉姆庫(kù)馬拉數(shù)組二維數(shù)組
???? * @待辦事項(xiàng)可以轉(zhuǎn)移到__construct（）稍后
???? */
??? function addarray ($array) {

??????? // run through the array and add them into rows
??????? foreach ($array as $k => $v):
??????????? $this->addrow ($v);
??????? endforeach;

??? }

??? /**
??? 設(shè)置工作表名稱
???? *
???? *檢查的字符串不允許字符（： /?*),
???? *削減它的最大31個(gè)字符，并設(shè)置標(biāo)題。該死
???? *為何未允許字符無(wú)處可尋？視窗
???? *幫助沒(méi)有幫助...
???? *
???? * @訪問(wèn)公開(kāi)
???? * @帕拉姆庫(kù)馬拉字符串$標(biāo)題設(shè)計(jì)標(biāo)題
???? */
??? function setworksheettitle ($title) {

??????? // strip out special chars first
??????? $title = preg_replace ("/[\|:|/|?|*|[|]]/", "", $title);

??????? // now cut it to the allowed length
??????? $title = substr ($title, 0, 31);

??????? // set title
??????? $this->worksheet_title = $title;

??? }

?? /**
???? *生成excel文件
???? *
???? *最后生成的excel文件，并使用header（）函數(shù)
???? *提供給瀏覽器。
???? *
???? * @訪問(wèn)公開(kāi)
???? * @帕拉姆庫(kù)馬拉字符串$文件名名稱的excel文件來(lái)生成（... xls）中
???? */
??? function generatexml ($filename) {

??????? // deliver header (as recommended in php manual)
??????? header("content-type: application/vnd.ms-excel; charset=utf-8");
??????? header("content-disposition: inline; filename="" . $filename . ".xls"");

??????? // print out document to the browser
??????? // need to use strips教程lashes for the damn ">"
??????? echo stripslashes ($this->header);
??????? echo "nworksheet_title . "">n

n";
??????? echo "n";
??????? echo implode ("n", $this->lines);
??????? echo "nn";
??????? echo $this->footer;

??? }

}

/**
?*? cakephp中使用方法
?*? 注意 ** cakephp 配置文件 define('debug', 0);
?*
?*? vendor ('excel');
?*? $doc = array (
?*?????? 0 => array ('中國(guó)', '中國(guó)人', '中國(guó)人民', '123456');
?*? );
?*? $xls = new excel;
?*? $xls->addarray ( $doc );
?*? $xls->generatexml ("mytest");
?*/

/**
?*? 非框架使用方法
?*
?*? require_once('excel.php');
?*? $doc = array (
?*?????? 0 => array ('中國(guó)', '中國(guó)人', '中國(guó)人民', '123456');
?*? );
?*? $xls = new excel;
?*? $xls->addarray ( $doc );
?*? $xls->generatexml ("mytest");
?*/