NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Packagist
Packagist, #1312 most downloaded on Packagist
PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way
Latest stable
v3.3.0
Last release 6 years ago
no release in 18 months
Release timing varies
gaps range from 2 weeks to 1.7 years
Nearly every release is documented
notes for 34 of 36 stable releases
Nothing withdrawn
no release was ever pulled
12 years old
36 releases · first in 2015
Drag across the ruler to compare, or tap a release to open it.
[ODS/XLSX] Big performance improvement, mostly related to how Styling is done (thanks @alamirault !)
[ALL] Support for PHP 7.1 was removed. 7.2 is the oldest version supported now.
Your coding agent can read these notes before it upgrades. Set up the MCP server →
[XLSX] Added support for writing cell formats
<text:span>This version fixes the reading of 1904 dates option.
This version fixes the reading of 1904 dates option.
Spout v3 is finally out! 🎉🎉🎉🎉🎉🎉
Spout v3 is finally out!
🎉🎉🎉🎉🎉🎉
You can check out what changed in the Upgrade guide.
Exposed API to get the last active sheet
Improvements:
Bug fixes:
CSV Reader can now read lines of any length and is not limited to 32768 bytes per line
Improvements:
Bug fixes:
close() when a writer is already closed no longer causes an errorRemove control characters to avoid breaking ODS files
New option to preserve empty rows when reading
Major Enhancements:
Minor Enhancements:
Refactoring:
New features included in this new version:
New features included in this new version:
Fixes:
shouldFormatDate optionThis new version contains several fixes/improvements:
This new version contains several fixes/improvements:
Consistent behavior among all readers when reading cells with leading/ending spaces.
Fixed an issue when writing boolean values to XLSX files - #175
Added support for variable EOL in CSV files
Added support for variable EOL in CSV files
Added support for XLSX files that have sheets not defined in order of appearance
empty cells are not written, saving space
Multiple optimizations:
The created files' mime type is now correctly detected. Support for dates beyond 2037.
This release includes a few improvements:
This release includes a few improvements:
prevent infinite loop for multi-lines CSV when all lines are empty
This release contains 2 fixes:
Spout now supports a new document format: ODS! Through the same interface, it is now possible to read CSV, XLSX and ODS files.
Spout now supports a new document format: ODS! Through the same interface, it is now possible to read CSV, XLSX and ODS files.
Other improvements:
Fixed bug preventing a XLSX file to be read in iOS and Numbers. Added detection of invalid sheet names (which resulted in an error message when the fi
Fixed bug preventing a XLSX file to be read in iOS and Numbers. Added detection of invalid sheet names (which resulted in an error message when the file was opened in Excel) Added font color support
Spout now supports styling! It also forces Excel to display multi-line strings correctly, wrapping the text in the cell and breaking it as expected.
Spout now supports styling! It also forces Excel to display multi-line strings correctly, wrapping the text in the cell and breaking it as expected.
Prevented infinite loop when trying to read a CSV file ending with an empty line
Prevented infinite loop when trying to read a CSV file ending with an empty line
This version introduces a new way to iterate over the files, moving away from the hasNext() / getNext() method to use PHP iterators and the standard f
This version introduces a new way to iterate over the files, moving away from the hasNext() / getNext() method to use PHP iterators and the standard foreach loop. It also unifies the way CSV and XLSX files are read.
This change required a major version bump, as it is not backwards compatible.
Version 2.0.0 also brings a few nice additions:
Introduced new caching strategy when extracting shared strings for reading. This should really speed up Spout for small files!
Introduced new caching strategy when extracting shared strings for reading. This should really speed up Spout for small files!
Fixed XLSX writer on Windows Improved support for cell value types Added code coverage integration through coveralls.io
Fixed XLSX writer on Windows Improved support for cell value types Added code coverage integration through coveralls.io
Added proper support for all cell types Fixed issue with cells that don't have values Removed version from composer.json
Added proper support for all cell types Fixed issue with cells that don't have values Removed version from composer.json
Added support for files without a sharedStrings.xml file Added support for files containing formulas Updated README
Added support for files without a sharedStrings.xml file Added support for files containing formulas Updated README
Fixed issue with ZipArchive and directory separators on Windows
Fixed issue with ZipArchive and directory separators on Windows
Improved code coverage Unified interface between Reader and Writer
Improved code coverage Unified interface between Reader and Writer
Improvements around sheets name:
Improvements around sheets name:
Fixed incorrect start index for array filling Added bunch of tests Added code coverage Added HHVM and PHP nightly as supported environment for Travis
Fixed incorrect start index for array filling Added bunch of tests Added code coverage Added HHVM and PHP nightly as supported environment for Travis
Nothing published for this version
Fixed bug in XLSX writer when some specific values were passed in (0, "0", "10.3", ...) Added .editorconfig
Fixed bug in XLSX writer when some specific values were passed in (0, "0", "10.3", ...) Added .editorconfig
Added support for multi-line strings Fixed an issue preventing usage of Spout on Windows Empty data rows are now skipped, preventing creating corrupte
Added support for multi-line strings Fixed an issue preventing usage of Spout on Windows Empty data rows are now skipped, preventing creating corrupted XLSX files
Added support for empty worksheets
Added support for empty worksheets
Nothing published for this version
One column per quarter.