Excel Reader

Read spreadsheet files (CSV, XLSX and ODS) using openspout/openspout and return data in array format.

Installation

You can install the package via composer:

composer require webnuvola/excel-reader

Usage

$excel = \Webnuvola\ExcelReader\ExcelReader::createFromPath(__DIR__.'/excel-file.xlsx')
    ->read();

$excel = \Webnuvola\ExcelReader\ExcelReader::createFromString($content, 'xlsx')
    ->read();

Testing

composer test

Upgrade Guide

From v2 to v3

This version drops support for php 7.4 and adds support for php 8.2.

The openspout/openspout library is updated to ^4.9.

From v1 to v2

Library box/spout is replaced with openspout/openspout, there are no breaking changes.

If you are using box/spout outside this library, please refer to openspout/openspout upgrade guide.

Changelog

Please see CHANGELOG for more information on what has changed recently.

Credits

• Fabio Cagliero

License

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