WP File Manager
Current Path:
/
home
/
argothem
/
www
/
organecyberpresse
/
plugins
/
auto
/
spip_bonux
/
v4.2.0
/
lib
/
php-export-data
/
Name
Action
..
.gitignore
Edit
LICENSE
Edit
README.md
Edit
composer.json
Edit
src
Editing: README.md
# php-export-data -- by Eli Dickinson Improved version by Nursit https://github.com/nursit/php-export-data * forked from https://github.com/diego3/php-export-data * forked from http://github.com/elidickinson/php-export-data Released under the permissive MIT License: http://www.opensource.org/licenses/mit-license.php A simple library for exporting tabular data to Excel-friendly XML, CSV, or TSV. It supports streaming exported data to a file or directly to the browser as a download so it is suitable for exporting large datasets (you won't run out of memory). Excel XML code is based on Excel_XML by Oliver Schwarz (http://github.com/oliverschwarz/php-excel) ## Composer Install ```shell composer require diego3/php-export-data ``` ## How to use it ```php // When executed in a browser, this script will prompt for download // of 'test.xls' which can then be opened by Excel or OpenOffice. use Export\ExportDataExcel; // 'browser' tells the library to stream the data directly to the browser. // other options are 'file' or 'string' // 'test.xls' is the filename that the browser will use when attempting to // save the download $exporter = new ExportDataExcel('browser', 'test.xls'); $exporter->initialize(); // starts streaming data to web browser // pass addRow() an array and it converts it to Excel XML format and sends // it to the browser $exporter->addRow(array("This", "is", "a", "test")); $exporter->addRow(array(1, 2, 3, "123-456-7890")); // doesn't care how many columns you give it $exporter->addRow(array("foo")); $exporter->finalize(); // writes the footer, flushes remaining data to browser. exit(); // all done ``` See the test/ directory for more examples. Some other options for creating Excel files from PHP are listed here: http://stackoverflow.com/questions/3930975/alternative-for-php-excel/3931142#3931142