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

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:

• Github
• Packageist

Author

Timothy Totten

License

MIT