/ Excel

PHP生成Excel,支持多个Sheet

此版本为本人演绎版本,原版本地址http://code.google.com/p/php-excel/

开源协议MIT

php-excel.class.php:

setWorksheetTitle($sWorksheetTitle); } public function setWorksheetTitle ($title) { $title = preg_replace ("/[\\\¦:¦\/¦\?¦\*¦\[¦\]]/", "", $title); $title = substr ($title, 0, 31); $this->sWorksheetTitle = $title; } public function addRow ($array) { $cells = ""; foreach ($array as $k => $v){ $type = 'String'; $v = htmlentities($v, ENT_COMPAT, "UTF-8"); $cells .= "" . $v . "\n"; } $this->lines[] = "\n" . $cells . "\n"; } public function printline() { foreach ($this->lines as $line) { echo $line; } } } class Excel { public $worksheets = array(); public function __construct($sWorksheetTitle) { $this->addsheet($sWorksheetTitle); } public function addsheet($title) { $this->worksheets[$title] = new WorkSheet($title); } public function generate ($filename = 'excel-export') { $filename = preg_replace('/[^aA-zZ0-9\_\-]/', '', $filename); header("Content-Type: application/vnd.ms-excel; charset=UTF-8"); header("Content-Disposition: inline; filename=\"" . $filename . ".xls\""); echo stripslashes("\n"); foreach ($this->worksheets as $worksheet) { echo "\nsWorksheetTitle . "\">\n\n"; $worksheet->printline(); echo "
\n
\n"; } echo "
"; } } ?>

使用方法:

worksheets['Sheet']->addRow(array("1","2","3")); //添加一行,数据为1,2,3 $xls->addsheet('Test');//新建一个sheet,参数为sheet名称 $xls->worksheets['Test']->addRow(array("3","2","3"));//在第二个sheet添加一行 $xls->generate('my-test');//下载excel,参数为文件名 ?>
PHP生成Excel,支持多个Sheet
Share this