Download the PHP package eclipxe/xlsxexporter without Composer
On this page you can find all versions of the php package eclipxe/xlsxexporter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download eclipxe/xlsxexporter
More information about eclipxe/xlsxexporter
Files in eclipxe/xlsxexporter
Package xlsxexporter
Short Description PHP Office Open XML Spreadsheet (xlsx) exporter
License MIT
Homepage https://github.com/eclipxe13/XlsxExporter
Informations about the package xlsxexporter
eclipxe/xlsxexporter
PHP Office Open XML Spreadsheet (xlsx) Exporter is a project to write xlsx files using PHP. I recommend you to check out the project PHPExcel that has an excellent support for this kind of files.
I create this project because PHPExcel does not fit my needs. Specifically, I use this tool to export big amount of data to spreadsheets files to be exported and processed by the end user. Using PHPExcel consume a lot of memory and raising the "memory exhausted error".
Projects that does something similar, and I use it as reference:
How it works
- Your main object is a workbook.
- A workbook contains at least 1 spreadsheet.
- Every spreadsheet (worksheet) has a collection of columns and a DataProvider object.
- When the structure information (workbook, worksheets, columns and providers) has been set you can write the xlsx file.
- Every time a worksheet will be created, the headers are written first, then every row of data is written. The data is extracted using the Provider. In this way, you don't need all your data stored on memory, you can use a PDO reader implementing the Provider interface.
- The data is written to a temporary files (including the final zip), so no large amount of data is being used.
Installation
Use composer, run:
Basic usage example
Contributing
Contributions are welcome! Please read CONTRIBUTING for details and don't forget to take a look the TODO and CHANGELOG files.
License
The eclipxe/xlsxexporter
library is copyright © Carlos C Soto
and licensed for use under the MIT License (MIT). Please see LICENSE for more information.
All versions of xlsxexporter with dependencies
ext-zip Version *
ext-simplexml Version *
eclipxe/engineworks-progress-status Version ^2.0.1