vakata/spreadsheet

Simple spreadsheet reader/writer supporting XLS (read-only), XLSX and CSV files

2.3.1 2024-11-11 09:45 UTC

This package is auto-updated.

Last update: 2024-11-11 09:47:50 UTC


README

Latest Version on Packagist Software License

Simple spreadsheet reader/writer supporting XLS (read-only), XLSX, XML and CSV files. The classes try not to load all the data at once so that fairly large files are supported using iterators.

Install

Via Composer

$ composer require vakata/spreadsheet

Usage

// you can also write to browser or to stream (additional options are available for each format)
foreach (\vakata\spreadsheet\Writer::toFile('test.xlsx')->fromArray([
    [1,"asdf","2022-02-10"],
    [2,"test","2010-11-10"]
]);
// you can also read from stream
foreach (\vakata\spreadsheet\Reader::fromFile('test.xlsx') as $k => $row) {
    var_dump($row);
}
// or
var_dump(\vakata\spreadsheet\Reader::fromFile('test.xlsx')->toArray());

// when writing XLSX files formatting options are available
$writer = \vakata\spreadsheet\Writer::toFile('test.xlsx', 'xlsx');
$driver = $writer->getDriver();
$driver->addSheet('Sheet name');
$driver->addHeaderRow(['', ['', null, 'LTBRD'], ['Names', null, null, null, 'c', null, 3], '', '', ''], false, false);
$driver->addHeaderRow(['', '', 'Given', 'Surname','Family', 'Year']);
$driver->addRow([['group 1', null, null, null, 'CM', '999999', 1, 3 ], 1, 'Leopold', 'Sarah', 'Johnson', 1981], 'b');
$driver->addRow(['', 2, 'Phil', 'Stuart', 'Davidson', 1984], '', 'LTBR', '009900');
$driver->addRow(['', 3, 'Anne', 'Marie', 'Gordon', [1992, 'biu', null, null, null, '00FF00']]);
$driver->addRow([['group 2', null, null, null, 'CM', '999999', 1, 2 ], 4, 'George', '', 'Black', 1978]);
$driver->addRow(['', 5, 'David', '', 'Green', 1989]);
$driver->close();

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email github@vakata.com instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.