phpexcel匯出excel的經典執行個體

/** * phpexcel類庫匯出excel檔案 * edit: bbs.it-home.org * */ require 'php-excel.class.php';//引用Google的phpexcel 類 $result = mysql_query("SELECT * FROM dingdan"); //查詢一個資料表，並返回記錄集 $data = array( 1 => array ('訂單編號', '線路名稱'),); while($row = mysql_fetch_array($result)){//把查詢的結果迴圈輸出到EXCEL中 array_push($data,array($row["dd_bh"], $row["dd_xianlu_name"])); } // generate file (constructor parameters are optional) $xls = new Excel_XML('GB2312', false, '財務報表'); $xls->addArray($data); $xls->generateXML('2011010320'); ?> 複製代碼 附，phpexcel 類 php-excel.class.php 檔案代碼。 class Excel_XML { /** * Header (of document) * @var string */ private $header = "/n"; /** * Footer (of document) * @var string */ private $footer = ""; /** * Lines to output in the excel document * @var array */ private $lines = array(); /** * Used encoding * @var string */ private $sEncoding; /** * Convert variable types * @var boolean */ private $bConvertTypes; /** * Worksheet title * @var string */ private $sWorksheetTitle; /** * Constructor * * The constructor allows the setting of some additional * parameters so that the library may be configured to * one's needs. * * On converting types: * When set to true, the library tries to identify the type of * the variable value and set the field specification for Excel * accordingly. Be careful with article numbers or postcodes * starting with a '0' (zero)! * * @param string $sEncoding Encoding to be used (defaults to GBK) * @param boolean $bConvertTypes Convert variables to field specification * @param string $sWorksheetTitle Title for the worksheet */ public function __construct($sEncoding = 'UTF-8', $bConvertTypes = false, $sWorksheetTitle = 'Table1') { $this->bConvertTypes = $bConvertTypes; $this->setEncoding($sEncoding); $this->setWorksheetTitle($sWorksheetTitle); } /** * Set encoding * @param string Encoding type to set */ public function setEncoding($sEncoding) { $this->sEncoding = $sEncoding; } /** * Set worksheet title * * Strips out not allowed characters and trims the * title to a maximum length of 31. * * @param string $title Title for worksheet */ public function setWorksheetTitle ($title) { $title = preg_replace ("/[///|:|//|/?|/*|/[|/]]/", "", $title); $title = substr ($title, 0, 31); $this->sWorksheetTitle = $title; } /** * Add row * * Adds a single row to the document. If set to true, self::bConvertTypes * checks the type of variable and returns the specific field settings * for the cell. * * @param array $array One-dimensional array with row content */ private function addRow ($array) { $cells = ""; foreach ($array as $k => $v): $type = 'String'; if ($this->bConvertTypes === true && is_numeric($v)): $type = 'Number'; endif; $v = htmlentities($v, ENT_COMPAT, $this->sEncoding); $cells .= "" . $v . "/n"; endforeach; $this->lines[] = "/n" . $cells . "/n"; } /** * Add an array to the document * @param array 2-dimensional array */ public function addArray ($array) { foreach ($array as $k => $v) $this->addRow ($v); } /** * Generate the excel file * @param string $filename Name of excel file to generate (...xls) */ public function generateXML ($filename = 'excel-export') { // correct/validate filename $filename = preg_replace('/[^aA-zZ0-9/_/-]/', '', $filename); // deliver header (as recommended in php manual) header("Content-Type: application/vnd.ms-excel; charset=" . $this->sEncoding); header("Content-Disposition: inline; filename=/"" . $filename . ".xls/""); // print out document to the browser // need to use stripslashes for the damn ">" echo stripslashes (sprintf($this->header, $this->sEncoding)); echo "/nsWorksheetTitle . "/">/n foreach ($this->lines as $line) /n"; echo $line; echo " /n/n"; echo $this->footer; } } ?> 複製代碼

