snazzware/xlsx-streamer

A simple class for streaming data to .xlsx files.

XlsxStreamer

Simple class to "stream" data to a .xlsx file., _(*1)

The .xlsx file is created on disk, except for the dictionary. This allows far less memory consumption than using a solution such as (the excellent) PHPExcel library., _(*2)

I plan to add more capabilities to this streamer in the future, such as basic formatting, support for embedded hyperlinks, etc., _(*3)

Basic Usage

<?php

require __DIR__.'/vendor/autoload.php';

$streamer = new \Snazzware\XlsxStreamer();

$streamer->open('test.xlsx');
$streamer->write([
    'This is A1',
    'This is B1',
]);
$streamer->write([
    'This is A2',
    'This is B2',
]);
$streamer->close();

Blog posts

http://blog.snazzware.com/2016/01/05/streaming-large-data-sets-to-excel-xlsx-targets-part-1/, _(*4)

http://blog.snazzware.com/2016/01/09/streaming-large-data-sets-to-excel-xlsx-targets-part-2/, _(*5)