webnuvola/excel-reader

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

v3.1.0 2024-03-01 18:04 UTC

Requires

• php: ^8.1
• cocur/slugify: ^4.5
• openspout/openspout: ^4.23

Requires (Dev)

• pestphp/pest: ^2.34

MIT

• Fabio Cagliero

• excel
• spreadsheet
• xls
• xlsx
• csv
• PHPExcel
• ods
• phpspreadsheet

README

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.