# Changelog All notable changes to `simple-excel` will be documented in this file ## 3.3.0 - 2023-12-05 ### 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 ## 3.2.1 - 2023-11-09 ### 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 ## 3.2.0 - 2023-03-13 ### 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 ## 3.1.0 - 2023-01-20 ### 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 ## 3.0.1 - 2023-01-17 ### 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 ## 3.0.0 - 2022-12-09 ### 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 ## 2.5.0 - 2022-12-05 ### 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 ## 2.4.0 - 2022-11-09 ### 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 ## 2.3.0 - 2022-10-11 ### 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 ## 2.2.0 - 2022-09-02 ### 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 ## 2.1.0 - 2022-06-09 ### 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 ## 2.0.0 - 2022-06-06 - move from box/spout to openspout/openspout ## 1.15.1 - 2022-05-11 ## What's Changed - Update README.md by @vdvcoder in https://github.com/spatie/simple-excel/pull/80 - Typo by @saurabhsharma2u in https://github.com/spatie/simple-excel/pull/83 - Allow for selecting sheet by number by @dakira in https://github.com/spatie/simple-excel/pull/86 ## New Contributors - @vdvcoder made their first contribution in https://github.com/spatie/simple-excel/pull/80 - @saurabhsharma2u made their first contribution in https://github.com/spatie/simple-excel/pull/83 - @dakira made their first contribution in https://github.com/spatie/simple-excel/pull/86 **Full Changelog**: https://github.com/spatie/simple-excel/compare/1.15.0...1.15.1 ## 1.15.0 - 2022-01-12 - support Laravel 9 ## 1.14.1 - 2021-06-11 - Allow trimming empty header titles (#64) ## 1.14.0 - 2021-06-10 - Allow all forms of callables to format header (#63) - drop support for PHP 7 ## 1.13.1 - 2021-03-26 - make sure `getHeaders()` take delimiter in account (#57) ## 1.13.0 - 2020-01-18 - add `getHeaders()` (#52) ## 1.12.0 - 2020-12-30 - add `headersToSnakeCase` and `formatHeadersUsing` ## 1.11.0 - 2020-12-29 - enable disabling BOM on writer (#48) ## 1.10.2 - 2020-12-28 - use setHeaderStyle fluently (#47) ## 1.10.1 - 2020-12-27 - enable header row trimming (#46) ## 1.10.0 - 2020-12-08 - allow setting the writer/reader type manually (#43) ## 1.9.1 - 2020-11-30 - add support for PHP 8 ## 1.9.0 - 2020-10-30 - add Header Styling Method (#39) ## 1.8.1 - 2020-10-08 - fix `skip` method ## 1.8.0 - 2020-10-04 - add 'take' and 'skip' functions to reader (#35) ## 1.7.1 - 2020-09-08 - allow Laravel 8 ## 1.7.0 - 2020-08-19 - make `addRows` chainable ## 1.6.0 - 2020-07-16 - add `addRows` ## 1.5.0 - 2020-07-01 - wrong tag, please ignore ## 1.4.0 - 2020-04-15 - Add `useDelimiter` method for `SimpleExcelWriter` (#25) ## 1.3.1 - 2019-02-17 - Fix columns being returned in the wrong order ## 1.3.0 - 2019-01-02 - drop support for PHP 7.3 ## 1.2.2 - 2019-11-29 - make sure `streamDownload` does not create a file ## 1.2.0 - 2019-11-29 - add `streamDownload` and `toBrowser` ## 1.1.0 - 2019-10-27 - add `getPath` ## 1.0.0 - 2019-10-26 - initial release