lum/lum-spreadsheet

Spreadsheet helper library

Maintainers

Package info

github.com/supernovus/lum.spreadsheet.php

pkg:composer/lum/lum-spreadsheet

Statistics

Installs: 9

Dependents: 0

Suggesters: 0

Stars: 0

Open Issues: 0

v3.1.1 2026-05-05 19:48 UTC

This package is auto-updated.

Last update: 2026-05-05 19:50:46 UTC


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() with setCellValue().
  • Fixed some bugs with bad variable names and missing return statements.
  • Removed an empty else block.
  • Added docblocks with type declarations that help Intelephense work better.

Plans

v4.x

  • Move Lum\Worksheet to Lum\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

License

MIT