gegiben / php-excel Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/php-excel
License: MIT License
Automatically exported from code.google.com/p/php-excel
License: MIT License
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 <[email protected]> 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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.