lum / lum-spreadsheet
Spreadsheet helper library
v3.1.1
2026-05-05 19:48 UTC
Requires
- ext-zip: *
- lum/lum-compat: ^2.0
- lum/lum-file: ^2.0
- lum/lum-text: ^2.0
- phpoffice/phpspreadsheet: ^1.30.4
README
Summary
A library for working with Spreadsheet files using PhpSpreadsheet.
Originally designed to make building spreadsheets simpler, but now also provides functionality for loading existing spreadsheets.
In addition to the usual import/export formats supported by PhpSpreadsheet, this library provides one more: zipped CSV files. This is used by default if a spreadsheet has multiple worksheets and you save to the 'Csv' format.
It saves each worksheet as an individual CSV file, along with a metadata file in JSON format. All of these are then added to a zip file.
Classes
| Class | Description |
|---|---|
| Lum\Spreadsheet | A wrapper around PhpOffice/PhpSpreadsheet. |
| Lum\Worksheet | Internal child class of Spreadsheet. |
Changes
v3.1.1
- Bumped minimum PhpSpreadsheet to v1.30.4, the most recent 1.x release.
- Replaced deprecated
setCellValueByColumnAndRow()withsetCellValue(). - Fixed some bugs with bad variable names and missing return statements.
- Removed an empty
elseblock. - Added docblocks with type declarations that help Intelephense work better.
Plans
v4.x
- Move
Lum\WorksheettoLum\Spreadsheet\Worksheet; a better namespace for a semi-internal child class. - Bump PhpSpreadsheet from v1.x to v5.x; this should be fairly smooth, but still will need to do a bunch of testing to be sure!
???
- Add tests!
Official URLs
This library can be found in two places:
Author
Timothy Totten