2017 © Pedro Peláez
 

library seine

Seine - Write spreadsheets of various formats to a stream

image

seine/seine

Seine - Write spreadsheets of various formats to a stream

  • Thursday, July 10, 2014
  • by martinvium
  • Repository
  • 1 Watchers
  • 12 Stars
  • 36,641 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 4 Forks
  • 2 Open issues
  • 4 Versions
  • 4 % Grown

The README.md

Seine

Build Status, (*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);
?>

The Versions

10/07 2014

dev-master

9999999-dev https://github.com/martinvium/seine/

Seine - Write spreadsheets of various formats to a stream

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by Kim Hemsoe

csv excel xls spreadsheet xlsx stream odf calc

09/07 2014

v2.0.0beta1

2.0.0.0-beta1 https://github.com/martinvium/seine/

Seine - Write spreadsheets of various formats to a stream

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by Kim Hemsoe

csv excel xls spreadsheet xlsx stream odf calc

22/06 2012

dev-1-0-stable

dev-1-0-stable https://github.com/martinvium/seine/

Seine - Write spreadsheets of various formats to a stream

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by Kim Hemsoe

csv excel xls spreadsheet xlsx stream odf calc

22/06 2012

v1.0.0

1.0.0.0 https://github.com/martinvium/seine/

Seine - Write spreadsheets of various formats to a stream

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

by Kim Hemsoe

csv excel xls spreadsheet xlsx stream odf calc