collei/exceller

A simple wrapper for the PHPOffice/PHPSpreadsheet package. Read excel files with ease.

v0.4.0 2024-02-08 00:00 UTC

Requires

• php: >=7.2
• collei/conf: ^0.1.0
• collei/lowcache: ^0.1.0
• phpoffice/phpspreadsheet: ^1.17

Requires (Dev)

• phpunit/phpunit: ^9.6

MIT

• Alarido Su

• excel
• spreadsheet
• xls
• xlsx
• csv

README

Just a wrapper for the PHPOffice/PHPSpreadsheet package. Read excel files with ease.

Requirements

• PHP 7.2 or newer
• PHPOffice/PHPSpreadsheet 1.17.0 or newer

Current Features

• Reads excel sheets into arrays;
• Imports excel sheets with user-defined importer classes;
• Multiple sheet imports with support for skip missing sheets, conditional importing, grouped rows;
• Localized event handling on importers themselves;
• Shorthand helpers for importing;

To be added

• Built-in integrated cache system (requires [collei/lowcache])

Testing

1. Unpack the test.zip at the project's base folder;
2. Navigate into the test folder.

Unit Tests

• Run test-unit.cmd (for Windows) or test-unit.sh (Linux distros) and see the results.

Find them all under test/unit, with the .xlsx and config files in the files subfolder.

Integrated

• Run serve-integrated.cmd (for Windows) or serve-integrated.sh (Linux distros), then go http://localhost:8080 in your browser.

Find them all under test/integrated in subfolders named 01, 02 etc., with the .xlsx files in the files subfolder.