seine/seine

Seine - Write spreadsheets of various formats to a stream

Seine

, _(*1)

Write spreadsheets of various formats to a stream, _(*2)

Low memory, high performance library for writing large spreadsheets in various standard formats. Only a small subset of features are included, which means row level styling and right now, no formulas either., _(*3)

Memory: Everything is written to disk (stream), so memory overhead is pretty much zero. Speed: It's pretty damn fast! However because of the memory constraint, it's not mindblowing., _(*4)

Stability

This library is ALPHA/BETA quality., _(*5)

Dependencies

• PHP 5.3
• ZipArchive (only OOXML and you can create your own zip compressor, if you prefer another solution)

Writers

• Office Open XML Spreadsheet (.xlsx)
• Microsoft Excel 2003 XML (.xml)
• CSV (.csv)

Examples

Create a new document and close it after you done., _(*6)

 'ooxml2007'));
$doc = $seine->newDocument('example.xlsx');

// add rows and styles...

$doc->close();
?>

Create a new document using an existing stream, _(*7)

<?php
$fp = fopen('filename.csv', 'w');
$doc = $seine->newDocumentFromStream($fp);
$doc->close();
fclose($fp);
?>

Add 100.000 rows with 25 columns in ~25 seconds., _(*8)

<?php
$sheet = $doc->newSheet();
for($i = 0; $i < 100000; $i++) {
    $sheet->addRow(range(0, 25));
}
?>

Add styling to a row., _(*9)

<?php
$style = $doc->newStyle()
             ->setFontBold(true)
             ->setFontFamily('Aria')
             ->setFontSize('14');
$row = $seine->getRow(array('cell1', 'cell2'));
$row->addStyle($style);
?>