eclipxe/xlsxexporter

PHP Office Open XML Spreadsheet (xlsx) exporter

Monday, June 26, 2017
by eclipxe
Repository
1 Watchers
1 Stars
56 Installations

PHP
0 Dependents
0 Suggesters
0 Forks
0 Open issues
18 Versions
2 % Grown

The README.md

`eclipxe/xlsxexporter`

![Source Code][badge-source] ![Latest Version][badge-release] [![Build Status][badge-build]][build] [![Maintainability][badge-maintainability]][maintainability] [![Violations][badge-violations]][violations] , _(*1)

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., _(*2)

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"., _(*3)

Projects that does something similar, and I use it as reference:, _(*4)

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:, _(*5)

composer require eclipxe/xlsxexporter

Basic usage example

<?php
use Eclipxe\XlsxExporter;
use Eclipxe\XlsxExporter\CellTypes;
use Eclipxe\XlsxExporter\Column;
use Eclipxe\XlsxExporter\Columns;
use Eclipxe\XlsxExporter\Providers\ProviderArray;
use Eclipxe\XlsxExporter\Style;
use Eclipxe\XlsxExporter\Styles\Format;
use Eclipxe\XlsxExporter\WorkBook;
use Eclipxe\XlsxExporter\WorkSheet;
use Eclipxe\XlsxExporter\WorkSheets;
use Eclipxe\XlsxExporter\Exceptions\XlsxException;

// create a simple array as example
$provider = new ProviderArray([
    ['first_name' => 'Charles', 'amount' => 1234.561, 'visit' => strtotime('2014-01-13 13:14:15'), 'check' => 1],
    ['first_name' => 'Foo', 'amount' => 6543.219, 'visit' => strtotime('2014-12-31 23:59:59'), 'check' => 0],
]);

// create some special formats
$formatNumber2Decimals = new Style(['format' => ['code' => Format::FORMAT_COMMA_2DECS]]);
$formatDateTime = new Style(['format' => ['code' => Format::FORMAT_DATE_YMDHM]]);
$formatYesNo = new Style(['format' => ['code' => Format::FORMAT_YESNO]]);

// create the workbook with all the information
$workbook = new WorkBook(
    new WorkSheets(
        new WorkSheet('sheet01', $provider, new Columns(
            new Column('first_name', 'Name'),
            new Column('amount', 'Amount', CellTypes::NUMBER, $formatNumber2Decimals),
            new Column('visit', 'Visit', CellTypes::DATETIME, $formatDateTime),
            new Column('check', 'Check', CellTypes::BOOLEAN, $formatYesNo),
        )),
    )
);

// call the write process
try{
    XlsxExporter::save($workbook, __DIR__ . '/result.xlsx');
} catch (XlsxException $exception) {
    echo 'Export error: ', $exception->getMessage(), PHP_EOL;
}

Contributing

Contributions are welcome! Please read CONTRIBUTING for details and don't forget to take a look the TODO and CHANGELOG files., _(*6)

License

The Versions

26/06 2017

dev-master

9999999-dev https://github.com/eclipxe13/XLSXExporter

PHP Office Open XML Spreadsheet (xlsx) exporter

library xlsxexporter

PHP Office Open XML Spreadsheet (xlsx) exporter