# Changelog

All notable changes to `simple-excel` will be documented in this file

## 3.8.1 - 2025-09-24

### 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

## 3.8.0 - 2025-07-17

### 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

## 3.7.3 - 2025-06-02

### 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

## 3.7.2 - 2025-02-14

### 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

## 3.7.1 - 2024-12-16

### 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

## 3.7.0 - 2024-09-23

### 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

## 3.6.0 - 2024-04-24

### 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

## 3.5.0 - 2024-04-03

### 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

## 3.4.0 - 2024-03-04

### 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

## 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
