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 <oliver.schwarz@gmail.com>
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.
没有合适的资源?快使用搜索试试~ 我知道了~
PHP实例开发源码-php-excel 用于生成excel文档的php函数库.zip
共4个文件
txt:2个
zip:2个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 97 浏览量
2022-11-21
12:33:31
上传
评论
收藏 10KB ZIP 举报
温馨提示
PHP实例开发源码—php-excel 用于生成excel文档的php函数库.zip PHP实例开发源码—php-excel 用于生成excel文档的php函数库.zip PHP实例开发源码—php-excel 用于生成excel文档的php函数库.zip
资源推荐
资源详情
资源评论
收起资源包目录
PHP实例开发源码—php-excel 用于生成excel文档的php函数库.zip (4个子文件)
132699137342704659
php-excel-20070308.zip 3KB
php-excel-v1.1-20090910.zip 4KB
readme.txt 3KB
使用须知.txt 0B
共 4 条
- 1
资源评论
毕业_设计
- 粉丝: 1922
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功