php导出excel表格综合示例
php中文网
发布时间：2016-07-25 08:55:07
|
1339人浏览过
|
来源于php中文网
原创
-
-
include("config.php"); - // load library
- require 'php-excel.class.php';
- // create a simple 2-dimensional array
- //@mysql_query("set character set gb2312");
- $strsql="select * from booklist";
- $result=mysql_query($strsql);
//print_r($result); $data = array( - 1 => array ('id', "书名"),//标题使用中文则到表格里面值为空，待解决
- );
- while($row=mysql_fetch_array($result))
- {
- array_push($data,array($row['bookid'], $row['bookname']));
- }
- // generate file (constructor parameters are optional)
- $xls = new Excel_XML('UTF-8', false, 'My Test Sheet');
- $xls->addArray($data);
- $xls->generateXML('my-test');
- ?>
-
/**
- * Simple excel generating from PHP5
- *
- * @version 1.0
- */
/**
Groq
GroqChat是一个全新的AI聊天机器人平台，支持多种大模型语言，可以免费在线使用。
下载
- * Generating excel documents on-the-fly from PHP5
- *
- * Uses the excel XML-specification to generate a native
- * XML document, readable/processable by excel.
- *
- * @package Utilities
- * @version 1.1
- *
- * @todo Issue #4: Internet Explorer 7 does not work well with the given header
- * @todo Add option to give out first line as header (bold text)
- * @todo Add option to give out last line as footer (bold text)
- * @todo Add option to write to file
- */
- class Excel_XML
- {
立即学习“PHP免费学习笔记（深入）”；
/** - * 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 UTF-8)
- * @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
\n";- foreach ($this->lines as $line)
- echo $line;
echo " \n\n";
- echo $this->footer;
- }
- }
- ?>
-
|
本站声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
