spatie/simple-excel

What's Changed

• Add trimValues() and formatValuesUsing() to the reader by @mhodge in #195

New Contributors

• @mhodge made their first contribution in #195

Full Changelog: 3.9.0...3.10.0

What's Changed

• Add trimValues() and formatValuesUsing() to the reader by @mhodge in https://github.com/spatie/simple-excel/pull/195

New Contributors

• @mhodge made their first contribution in https://github.com/spatie/simple-excel/pull/195

Full Changelog: https://github.com/spatie/simple-excel/compare/3.9.0...3.10.0

• Add Laravel 13 support
• Add PHP 8.5 to test matrix
• Remove deprecated PHPUnit attributes
• Update test dependencies

• Add Laravel 13 support
• Add PHP 8.5 to test matrix
• Remove deprecated PHPUnit attributes
• Update test dependencies

What's Changed

• Update issue template by @AlexVanderbist in #191
• Added getSheets function to get a list of avilabel sheet names. by @amit-roy1999 in #192

New Contributors

• @AlexVanderbist made their first contribution in #191
• @amit-roy1999 made their first contribution in #192

Full Changelog: 3.8.0...3.8.1

What's Changed

• Update issue template by @AlexVanderbist in https://github.com/spatie/simple-excel/pull/191
• Added getSheets function to get a list of avilabel sheet names. by @amit-roy1999 in https://github.com/spatie/simple-excel/pull/192

New Contributors

• @AlexVanderbist made their first contribution in https://github.com/spatie/simple-excel/pull/191
• @amit-roy1999 made their first contribution in https://github.com/spatie/simple-excel/pull/192

Full Changelog: https://github.com/spatie/simple-excel/compare/3.8.0...3.8.1

What's Changed

• fix package name from box to openspout by @nyanlynnhtut in #187
• Bump openspout/openspout to v4.30.1 by @pjkellar in #190

New Contributors

• @nyanlynnhtut made their first contribution in #187
• @pjkellar made their first contribution in #190

Full Changelog: 3.7.3...3.8.0

What's Changed

• fix package name from box to openspout by @nyanlynnhtut in https://github.com/spatie/simple-excel/pull/187
• Bump openspout/openspout to v4.30.1 by @pjkellar in https://github.com/spatie/simple-excel/pull/190

New Contributors

• @nyanlynnhtut made their first contribution in https://github.com/spatie/simple-excel/pull/187
• @pjkellar made their first contribution in https://github.com/spatie/simple-excel/pull/190

Full Changelog: https://github.com/spatie/simple-excel/compare/3.7.3...3.8.0

What's Changed

• Rewind iterator after use by @dododedodonl in #186

New Contributors

• @dododedodonl made their first contribution in #186

Full Changelog: 3.7.2...3.7.3

What's Changed

• Rewind iterator after use by @dododedodonl in https://github.com/spatie/simple-excel/pull/186

New Contributors

• @dododedodonl made their first contribution in https://github.com/spatie/simple-excel/pull/186

Full Changelog: https://github.com/spatie/simple-excel/compare/3.7.2...3.7.3

What's Changed

• Laravel 12.x Compatibility by @laravel-shift in #182

Full Changelog: 3.7.1...3.7.2

What's Changed

• Laravel 12.x Compatibility by @laravel-shift in https://github.com/spatie/simple-excel/pull/182

Full Changelog: https://github.com/spatie/simple-excel/compare/3.7.1...3.7.2

What's Changed

• Update documentation on how to use custom delimiter by @pikant in #179
• Fix deprecation warning for PHP 8.4 implicit nullable parameter by @hmazter in #180

New Contributors

• @pikant made their first contribution in #179

Full Changelog: 3.7.0...3.7.1

What's Changed

• Update documentation on how to use custom delimiter by @pikant in https://github.com/spatie/simple-excel/pull/179
• Fix deprecation warning for PHP 8.4 implicit nullable parameter by @hmazter in https://github.com/spatie/simple-excel/pull/180

New Contributors

• @pikant made their first contribution in https://github.com/spatie/simple-excel/pull/179

Full Changelog: https://github.com/spatie/simple-excel/compare/3.7.0...3.7.1

What's Changed

• Improve the wording and fix a typo about automatically detecting headers. by @timmch in #174
• Fix README sheetExists() should be hasSheet() by @damonzocp in #175
• Add XLSX option helpers to SimpleExcelReader by @brodos in #178

New Contributors

• @timmch made their first contribution in #174
• @damonzocp made their first contribution in #175
• @brodos made their first contribution in #178

Full Changelog: 3.6.0...3.7.0

What's Changed

• Improve the wording and fix a typo about automatically detecting headers. by @timmch in https://github.com/spatie/simple-excel/pull/174
• Fix README sheetExists() should be hasSheet() by @damonzocp in https://github.com/spatie/simple-excel/pull/175
• Add XLSX option helpers to SimpleExcelReader by @brodos in https://github.com/spatie/simple-excel/pull/178

New Contributors

• @timmch made their first contribution in https://github.com/spatie/simple-excel/pull/174
• @damonzocp made their first contribution in https://github.com/spatie/simple-excel/pull/175
• @brodos made their first contribution in https://github.com/spatie/simple-excel/pull/178

Full Changelog: https://github.com/spatie/simple-excel/compare/3.6.0...3.7.0

What's Changed

• CSV stream callback fixed by @rakibhoossain in #170

New Contributors

• @rakibhoossain made their first contribution in #170

Full Changelog: 3.5.0...3.6.0

What's Changed

• CSV stream callback fixed by @rakibhoossain in https://github.com/spatie/simple-excel/pull/170

New Contributors

• @rakibhoossain made their first contribution in https://github.com/spatie/simple-excel/pull/170

Full Changelog: https://github.com/spatie/simple-excel/compare/3.5.0...3.6.0

What's Changed

• Add useEncoding to SimpleExcelReader by @aminevg in #167

New Contributors

• @aminevg made their first contribution in #167

Full Changelog: 3.4.0...3.5.0

What's Changed

• Add useEncoding to SimpleExcelReader by @aminevg in https://github.com/spatie/simple-excel/pull/167

New Contributors

• @aminevg made their first contribution in https://github.com/spatie/simple-excel/pull/167

Full Changelog: https://github.com/spatie/simple-excel/compare/3.4.0...3.5.0

What's Changed

• Laravel 11.x Compatibility by @laravel-shift in https://github.com/spatie/simple-excel/pull/164

New Contributors

• @laravel-shift made their first contribution in https://github.com/spatie/simple-excel/pull/164

Full Changelog: https://github.com/spatie/simple-excel/compare/3.3.0...3.4.0

What's Changed

• Add the option to check if a sheet exists by name by @pascallieverse in https://github.com/spatie/simple-excel/pull/158

New Contributors

• @pascallieverse made their first contribution in https://github.com/spatie/simple-excel/pull/158

Full Changelog: https://github.com/spatie/simple-excel/compare/3.2.1...3.3.0

What's Changed

• Add some documentation to explain how to change column widths by @dakira in https://github.com/spatie/simple-excel/pull/146
• Update README.md by @EkoGit-777 in https://github.com/spatie/simple-excel/pull/148
• Add documentation for closing the file manually when necessary by @RayDabbah in https://github.com/spatie/simple-excel/pull/155
• Fix openspout backwards compatibility change that stops parsing formulas by @dakira in https://github.com/spatie/simple-excel/pull/156

New Contributors

• @EkoGit-777 made their first contribution in https://github.com/spatie/simple-excel/pull/148
• @RayDabbah made their first contribution in https://github.com/spatie/simple-excel/pull/155

Full Changelog: https://github.com/spatie/simple-excel/compare/3.2.0...3.2.1

What's Changed

• Fix workflow badge in README by @nelson6e65 in https://github.com/spatie/simple-excel/pull/135
• Allow shouldAddBom in streamDownload by @mariomka in https://github.com/spatie/simple-excel/pull/141

New Contributors

• @nelson6e65 made their first contribution in https://github.com/spatie/simple-excel/pull/135
• @mariomka made their first contribution in https://github.com/spatie/simple-excel/pull/141

Full Changelog: https://github.com/spatie/simple-excel/compare/3.1.0...3.2.0

What's Changed

• Updated Upgrade.md. For replace StyleBuilder to Style since its been … by @GekkeGlennDev in https://github.com/spatie/simple-excel/pull/134
• Allow delimiter in streamDownload() by @lukasleitsch in https://github.com/spatie/simple-excel/pull/132

New Contributors

• @GekkeGlennDev made their first contribution in https://github.com/spatie/simple-excel/pull/134
• @lukasleitsch made their first contribution in https://github.com/spatie/simple-excel/pull/132

Full Changelog: https://github.com/spatie/simple-excel/compare/3.0.1...3.1.0

What's Changed

• Doc Correction : adding-layout by @jeremysalmon in https://github.com/spatie/simple-excel/pull/129
• Doc Update : OpenSpout Doc Link from 3.x to 4.x and How to make border by @jeremysalmon in https://github.com/spatie/simple-excel/pull/130
• add support for laravel 10 by @ankurk91 in https://github.com/spatie/simple-excel/pull/131

New Contributors

• @jeremysalmon made their first contribution in https://github.com/spatie/simple-excel/pull/129
• @ankurk91 made their first contribution in https://github.com/spatie/simple-excel/pull/131

Full Changelog: https://github.com/spatie/simple-excel/compare/3.0.0...3.0.1

What's Changed

• V3 with PHP 8.2 support by @Nielsvanpach in https://github.com/spatie/simple-excel/pull/128

Most notable changes

1. Add support for openspout/openspout v4
2. Drop support for openspout/openspout v3
3. Add type hinting
4. Removed useDelimiter on SimpleExcelWriter
5. Removed headerRowFormatter on SimpleExcelReader

New Contributors

• @Nielsvanpach made their first contribution in https://github.com/spatie/simple-excel/pull/128

Full Changelog: https://github.com/spatie/simple-excel/compare/2.5.0...3.0.0

What's Changed

• Added addHeaderFromArray method to the SimpleWriter by @bedus-creation in https://github.com/spatie/simple-excel/pull/125

New Contributors

• @bedus-creation made their first contribution in https://github.com/spatie/simple-excel/pull/125

Full Changelog: https://github.com/spatie/simple-excel/compare/2.4.0...2.5.0

What's Changed

• Refactor tests to Pest by @alexmanase in https://github.com/spatie/simple-excel/pull/123
• Add optional styling when adding multiple rows to xslx by @chrisdicarlo in https://github.com/spatie/simple-excel/pull/122
• Add new sheet to XLSX with Header-Row by @red-freak in https://github.com/spatie/simple-excel/pull/124

New Contributors

• @alexmanase made their first contribution in https://github.com/spatie/simple-excel/pull/123
• @chrisdicarlo made their first contribution in https://github.com/spatie/simple-excel/pull/122
• @red-freak made their first contribution in https://github.com/spatie/simple-excel/pull/124

Full Changelog: https://github.com/spatie/simple-excel/compare/2.3.0...2.4.0

What's Changed

• Use field delimiter only for csv reader by @dehbka in https://github.com/spatie/simple-excel/pull/111
• Add function fromSheetName to read on specific spreadsheet name by @SpyBott in https://github.com/spatie/simple-excel/pull/117

New Contributors

• @dehbka made their first contribution in https://github.com/spatie/simple-excel/pull/111
• @SpyBott made their first contribution in https://github.com/spatie/simple-excel/pull/117

Full Changelog: https://github.com/spatie/simple-excel/compare/2.2.0...2.3.0

What's Changed

• Documentation for fromSheet and headerOnRow by @dakira in https://github.com/spatie/simple-excel/pull/102
• Ability to set custom headers (whether or not headers exist in the file) by @kitbs in https://github.com/spatie/simple-excel/pull/103

New Contributors

• @kitbs made their first contribution in https://github.com/spatie/simple-excel/pull/103

Full Changelog: https://github.com/spatie/simple-excel/compare/2.1.0...2.2.0

What's Changed

• Implement headerOnRow method by @ArondeParon in https://github.com/spatie/simple-excel/pull/89

New Contributors

• @ArondeParon made their first contribution in https://github.com/spatie/simple-excel/pull/89

Full Changelog: https://github.com/spatie/simple-excel/compare/2.0.0...2.1.0

• move from box/spout to openspout/openspout

• support Laravel 9

• Allow trimming empty header titles (#64)

• Allow all forms of callables to format header (#63)
• drop support for PHP 7

• make sure getHeaders() take delimiter in account (#57)

• add getHeaders() (#52)

• add headersToSnakeCase and formatHeadersUsing

• enable disabling BOM on writer (#48)

• use setHeaderStyle fluently (#47)

• enable header row trimming (#46)

• allow setting the writer/reader type manually (#43)

• add support for PHP 8

• add Header Styling Method (#39)

• fix skip method

• add 'take' and 'skip' functions to reader (#35)

• allow Laravel 8

• make addRows chainable

• add addRows

• wrong tag, please ignore

• Add useDelimiter method for SimpleExcelWriter (#25)

• Fix columns being returned in the wrong order

• drop support for PHP 7.3

• make sure streamDownload does not create a file

• add streamDownload and toBrowser

• add getPath

• initial release