phpexcel导出excel的经典实例

php中文网

发布时间：2016-07-25 08:56:07

1081人浏览过

来源于php中文网

原创

/**
* phpexcel类库导出excel文件
* edit: bbs.it-home.org
*
*/
require 'php-excel.class.php';//引用谷歌的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);
}
/**

自学 PHP、MySQL和Apache
本书将PHP开发与MySQL应用相结合，分别对PHP和MySQL做了深入浅出的分析，不仅介绍PHP和MySQL的一般概念，而且对PHP和MySQL的Web应用做了较全面的阐述，并包括几个经典且实用的例子。本书是第4版，经过了全面的更新、重写和扩展，包括PHP5.3最新改进的特性（例如，更好的错误和异常处理），MySQL的存储过程和存储引擎，Ajax技术与Web2.0以及Web应用需要注意的安全

下载
* 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/n";
foreach ($this->lines as $line)
echo $line;
echo "

/n/n";
echo $this->footer;
}
}
?>