php 生成excel文件 本文章收藏了三款php 生成excel文件代碼程序，第一款為比較全面的生成函數(shù)，后面二款很簡單，但是不如第一款好，好了現(xiàn)在來看看生成excel的原理吧。

php教程 生成excel文件
本文章收藏了三款php 生成excel文件代碼程序，第一款為比較全面的生成函數(shù)，后面二款很簡單，但是不如第一款好，好了現(xiàn)在來看看生成excel的原理吧。
*/

class excel{???
??
?
??? 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">";???

??? var $footer = "";
??? var $lines = array ();???
??? var $worksheet_title = "table1";???
???
??? function addrow ($array) {???
??
?
??????? $cells = "";???
???????????
?
??????? foreach ($array as $k => $v):???
???????????????
??????????? // 加個字符串與數(shù)字的判斷 避免生成的 excel 出現(xiàn)數(shù)字以字符串存儲的警告???
??????????? if(is_numeric($v)) {???
??????????????? // 防止首字母為 0 時生成 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";???
??
???? }???
?????
??? function addarray ($array) {???
??
??????? // run through the array and add them into rows???
??????? foreach ($array as $k => $v):???
??????????? $this->addrow ($v);???
??????? endforeach;???
??
???? }???
???
??? 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;???
??
???? }???
?
??? function generatexml ($filename) {???
??
?
???????? header("content-type: application/vnd.ms-excel; charset=utf-8");???
???????? header("content-disposition: inline; filename="" . $filename . ".xls"");???
?
??????? echo strips教程lashes ($this->header);???
??????? echo "nworksheet_title . "">n

n";???
??????? echo "n";???
??????? echo implode ("n", $this->lines);???
??????? echo "nn";???
??????? echo $this->footer;???
??
???? }???
??
}???
?
??
/**
*?? 非框架使用方法
*
*?? require_once('excel.php');
*?? $doc = array (
*??????? 0 => array ('中國', '中國人', '中國人民', '123456");
*?? );
*?? $xls = new excel;
*?? $xls->addarray ( $doc );
*?? $xls->generatexml ("mytest");
*/??

?>

方法二
其實在做真正的應(yīng)用的時候，大家可以將數(shù)據(jù)從數(shù)據(jù)庫教程中取出，然后按照每一列數(shù)據(jù)結(jié)束后加t,每一行數(shù)據(jù)結(jié)束后加n的方法echo出來，在php的開頭用header("content-type:application/vnd.ms-excel");表示輸出的是excel文件，用header("content-disposition:filename=test.xls");表示輸出的文件名為text.xls。這樣就ok了。

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

?????? header("content-disposition:filename=test.xls");

?????? echo "test1";

?????? echo "test2";

?????? echo "test1";

?????? echo "test2";

?????? echo "test1";

?????? echo "test2";

?????? echo "test1";

?????? echo "test2";

?????? echo "test1";

?????? echo "test2";

?????? echo "test1";

?????? echo "test2";

?>

方法三

? header("content-type:?? application/octet-stream");?
? header("accept-ranges:?? bytes");?
? header("content-type:application/vnd.ms-excel");???
? header("content-disposition:attachment;filename=export_excel_gshjsl.xls");???
??
? $tx='表頭';?
? echo?? $tx."nn";
? echo?? "編號"."t";?
? echo?? "姓名"."t";?
? echo?? "n";

?echo "="411481198507150666""."t";
?echo "="0123456""."t";
?echo "n";
??>