php-excel
所属分类:WEB开发
开发工具:PHP
文件大小:4KB
下载次数:18
上传日期:2011-09-07 11:43:29
上 传 者:
dizzy401
说明: 通过php实现将数据以excel格式导出,内有小例子,希望能帮助大家!
(Achieved through the php to export data to excel format, there are a small example, hope to help you!)
文件列表:
php-excel-v1[1].1-20090910\license.txt (1101, 2009-09-10)
php-excel-v1[1].1-20090910\php-excel.class.php (5659, 2009-09-10)
php-excel-v1[1].1-20090910\test.php (411, 2009-09-10)
php-excel-v1[1].1-20090910 (0, 2010-01-06)
PHP-Excel
=========
This is a small library written in PHP to generate an Excel
file (in MicrosoftXML format) out of a two-dimensional array.
It is NOT a full-grown solution to handle some serious data
interchange between databases <> PHP <> Excel, but a small
and simple way of throwing out an XML natively readable by
Excel to the browser.
Author: Oliver Schwarz
Project: http://code.google.com/p/php-excel/
Issues: http://code.google.com/p/php-excel/issues/list
Version: 1.1
Version 1.1
-----------
After revitalizing the project this version now addresses
several issues in the bugtracker. On my way to version 2
I wanted to publish an intermediate version to fix some
stupid errors I did in the first run.
Version 2 now allows:
* The setting of an encoding (default: UTF-8)
* The automagic type identification for strings/numbers
It fixes:
* An issue (#3) with large arrays and implode
* An issue (#7) with other charsets than iso-8859-1
* An issue (#9) with XML entity encoding (still not 100%)
Version 1
---------
This was the first version, released on March, 8th 2007. It
was usable for many people using the ISO-8859-1 charset and
for small arrays. However, it had some serious flaws using
other charsets or using larger data containers.
License
-------
Please see the included license.txt for details (it's MIT
license) or visit:
http://www.opensource.org/licenses/mit-license.php
...for more details.
Tutorial
--------
To get the export running, first create a two-dimensional
array (please stick to 2 dimensions, the library does not
work with complex arrays):
$a = array();
for($i=0;$i<10;$i++)
$a[] = array('Cell' . $i);
Instanciate the library and give the array as input:
$xls = new Excel_XML();
$xls->addArray($a);
Generate the XML/Excel file. This method should trigger
the browsers "Save as..." dialog:
$xls->generateXML('test');
Optional values
---------------
1) You may set your own charset in the constructor of
the class:
$xls = new Excel_XML('UTF-8');
2) You may activate/deactivate type identification for
table cells (strings/numbers):
$xls = new Excel_XML('UTF-8', true);
Whereas the values are: 'true' = type identification
active, 'false' (default) = type identification inactive.
3) You may set the worksheet title directly in the
constructor:
$xls = new Excel_XML('UTF-8', true, 'Testsheet');
Problems, Errors, Help
----------------------
If problems or error occur I unfortunately can not provide
any support. However, please visit the projects website and
post an issue to the comments or bugtracker. Thanks.
近期下载者:
相关文件:
收藏者: