maatwebsite/excel

What's Changed

• [4.x] Add Time/Enum column types and sheet-level export concerns by @IonBazan in #4417
• [4.x] Configuration from environment by @finagin in #4418
• Update upgrade guide with WithMultipleSheets by @IonBazan in #4421
• Adjust phpdoc types/generics to add defaults by @billypoke in #4422

New Contributors

• @finagin made their first contribution in #4418

Full Changelog: 4.0.0...4.0.1

What's Changed

• [4.x] Upgrade PHPOffice to v5 by @IonBazan in #4302
• Bump PhpSpreadsheet to 5.3 by @GNfsys in #4333
• Fix 8.5 deprecation by @amooij in #4334
• Allow queue jobs with batches by @dazza-dev in #4341
• Sync latest changes from 3.1 to 4.x by @AJenbo in #4343
• Add additional tests explicitly for latest phpspreadsheet version by @billypoke in #4347
• Sync 3.x to 4.x by @billypoke in #4351
• 4.x: Bump required PHP and Laravel versions by @AJenbo in #4361
• 4.x: Initialize rector, apply targeted rule sets up to minimum currently supported php version (8.3) by @billypoke in #4360
• 4.x: Replace StyleCI wtih Pint by @AJenbo in #4362
• Docs: warn that FromQuery requires a unique ORDER BY by @stllmtbrt in #4369
• 4.x: Specify supported PHPUnit versions and modernize phpunit.xml.dist by @billypoke in #4364
• 4.x: Address most issues found by PHPStan at level 0 by @AJenbo in #4359
• Modernise (PHP 8.3) using PHP-cs-fixer by @AJenbo in #4370
• Apply native types by @AJenbo in #4371
• Revert typed CacheInterface methods on deprecated cache drivers by @RenautMestdagh in #4372
• 4.x: Resolve PHPStan level 2 by @AJenbo in #4374
• Test lowest dependencies in CI and improve DX by @AJenbo in #4376
• PHPStan level 3 by @AJenbo in #4378
• chore: remove ext-json dependency from composer.json and normalize it by @maks-oleksyuk in #4383
• V4: Support the #[Queue] and #[Connection] attributes on imports by @markwalet in #4382
• [4.0] Improve Tests by @IonBazan in #4392
• Solve PHPStan level 4 issues by @AJenbo in #4386
• [4.0] Fix WithProgressBar regression by @IonBazan in #4391
• [4.0] Add FromScout interface by @IonBazan in #4390
• 4.x: Merge 3.1 by @AJenbo in #4398
• feat: add Laravel Boost skill configuration and documentation by @eramitgupta in #4399
• Resolve PHPStan level 5 issues by @AJenbo in #4396
• Resolve PHPStan level 6 by @AJenbo in #4397
• chore: update composer dependencies, export-ignore entries and CI by @maks-oleksyuk in #4384
• Apply Rector with curated rule set and scoped skips by @billypoke in #4377
• Prepare 4.0.0 release by @AJenbo in #4400
• Rector Import Names and Type Declaration Docblocks adoption by @billypoke in #4395
• [4.x] Add WithExportTemplate concern by @allanmcarvalho in #4406
• [4.x] [RFC] Introduce Export and Import interfaces by @IonBazan in #4403
• [4.x] Fix closing already closed resource regression by @IonBazan in #4402
• [BUG] : Queued exports drop root-level concerns by @imhayatunnabi in #4329
• Fix type issues by @AJenbo in #4408
• Fix/append query after chunk timing regression by @AJenbo in #4409
• [4.x] Fix remaining missing types, use readonly by @IonBazan in #4410
• [4.x] Fix: FromScout does not close the sheet by @IonBazan in #4413
• [4.x] Make OnEachRow extend Import by @IonBazan in #4412
• [4.x] extensible export source handler registry by @IonBazan in #4414
• [4.x] Add column definitions for exports and imports by @patrickbrouwers in #4416

New Contributors

• @IonBazan made their first contribution in #4302
• @GNfsys made their first contribution in #4333
• @amooij made their first contribution in #4334
• @dazza-dev made their first contribution in #4341
• @AJenbo made their first contribution in #4343
• @billypoke made their first contribution in #4347
• @stllmtbrt made their first contribution in #4369
• @RenautMestdagh made their first contribution in #4372
• @maks-oleksyuk made their first contribution in #4383
• @markwalet made their first contribution in #4382
• @eramitgupta made their first contribution in #4399
• @allanmcarvalho made their first contribution in #4406

Full Changelog: 3.1.70...4.0.0

See UPGRADE-4.x.md for the full upgrade guide.

Added

• WithColumns concern, describing a sheet as a list of typed column objects rather than raw arrays. Ships Text, Number, Decimal, Percentage, Price, Date, DateTime, Boolean, Formula, RichText, Hyperlink, Image and EmptyCell, each handling its own data type, number format, styling, sizing, filtering and comments on write, and its own casting on read
• FromScout export concern, replacing Scout builder support in FromQuery (#4390)
• ShouldBatch marker interface to dispatch queued exports and chunked queued imports as job batches (#4341)
• Support for Laravel's #[Queue] and #[Connection] attributes on imports (#4382)

Changed

• Requires PHP 8.3+ and Laravel 12+ (#4361)
• Upgraded phpoffice/phpspreadsheet from ^1.30 to ^5.3 (#4302, #4333)
• Native parameter and return types across the entire code base; static analysis at PHPStan level 6 (#4371 and others)

Removed

• Support for PHP below 8.3 and Laravel below 12 (#4361)
• Scout Builder support in FromQuery, use FromScout instead (#4390)
• ext-json requirement (#4383)

What's Changed

• Upgrade GitHub Actions versions in run-tests.yml by @Daniel-H123 in #4363
• Handle concurrent temporary directory creation by @cosmastech in #4368
• fix comment indentation in Cell Middleware config being 1 space off by @andrempiva in #4380
• Update composer.json - Patch for CVE-2026-34084 by @marventhieme in #4387
• fix: change the laravel version in the docs by @JoaoJesus1337 in #4394

New Contributors

• @Daniel-H123 made their first contribution in #4363
• @andrempiva made their first contribution in #4380
• @marventhieme made their first contribution in #4387
• @JoaoJesus1337 made their first contribution in #4394

Full Changelog: 3.1.69...3.1.70

What's Changed

• Update minimum phpspreadsheet version to 1.30.4 (CVE-2026-40296) by @gabrielrbarbosa in #4355

New Contributors

• @gabrielrbarbosa made their first contribution in #4355

Full Changelog: 3.1.68...3.1.69

What's Changed

• Fix: correct Laravel version range from 11.x to 12.x in compatibility by @ZakAmirou in #4325
• chore: edited the Run tests badge by @Olexandr88 in #4321
• docs: edited the MIT license link by @Olexandr88 in #4327
• Add PHP 8.5 to test matrix in CI workflow by @alexbowers in #4332
• Fix TSV processing, queued export crashes, and interface parameter consistency by @imhayatunnabi in #4330
• feat: Update composer.json for Laravel 13 support by @chinmaypurav in #4348

New Contributors

• @ZakAmirou made their first contribution in #4325
• @Olexandr88 made their first contribution in #4321
• @imhayatunnabi made their first contribution in #4330
• @chinmaypurav made their first contribution in #4348

Full Changelog: 3.1.67...3.1.68

Phpspreadsheet 1.30 update

Full Changelog: 3.1.66...3.1.67

What's Changed

• fix: missing InteractsWithQueue trait in QueueExport class by @KhoaDuongUQ in #4314
• Bugfix stream_copy_to_stream() by @jobjen02 in #4306
• fix: preserve RemoteTemporaryFile type when working with remote storage by @hschimpf in #4290

New Contributors

• @KhoaDuongUQ made their first contribution in #4314
• @jobjen02 made their first contribution in #4306
• @hschimpf made their first contribution in #4290

Full Changelog: 3.1.65...3.1.66

What's Changed

• Include end row in LimitFilter by @jivanf in #4278
• Support SkipsOnError with OnEachRow by @stevebauman in #4303

New Contributors

• @stevebauman made their first contribution in #4303

Full Changelog: 3.1.64...3.1.65

What's Changed

• Revert "Exclude heading row when limiting imported rows" by @patrickbrouwers in #4272

Full Changelog: 3.1.63...3.1.64

What's Changed

• Update phpspreadsheet to 1.29.8 to tackle CVE issue by @brdv in #4264
• Support for Laravel 12 by @pascalbaljet in #4269
• Avoid calling query() twice by adding a local var, fixes #4133 and #4140 by @Synchro in #4221
• Exclude heading row when limiting imported rows by @jivanf in #4217
• Format rule for required_without by @rust17 in #4196

New Contributors

• @brdv made their first contribution in #4264
• @pascalbaljet made their first contribution in #4269
• @Synchro made their first contribution in #4221
• @jivanf made their first contribution in #4217
• @rust17 made their first contribution in #4196

Full Changelog: 3.1.62...3.1.63

• Support Laravel 10

Fixed

• Fix Bug Multiple drawings change the behavior of the startCell (#3865).
• Allow configuring read data only in chunks as well.

• Support Laravel 10

Added

• Add support for ignoring PHP auto_detect_line_endings INI directive

Fixed

• Fix the PSR simple cache dependency mess to maintain backwards compatibility and support 3.0 of the interface.

Fixed

• Fix output of WithFormatData in combination with SkipsEmptyRows (#3760)

Changed

• Cast empty headings to indexed integer (#3646)
• Adds isEmptyWhen to customize is row empty logic. (#3645)

Fixed

• Fix temporary local files not being cleaned up when setting force_resync_remote config to true (#3623)
• Fix testing for multiple stored files by regex matching (#3631).
• Allow required_unless rule (#3660)

• Fix testing for multiple stored files by regex matching (#3631).

Changed

• Adds WithDefaultStyles concern to allow configuring the workbook default styles.
• Adds WithBackgroundColor concern to allow configuring the workbook default background color.
• Expose the ability to set custom response headers when exporting collections via Exportable

Fixed

• Fix PHP8.1 return type for Failure class (#3588)

Changed

• Adds concern WithGroupedHeadingRow to allow imported sheets to group the values of columns with the same header in an array

Fixed

• Fix for prepareForValidation callback not being called when using SkipsEmptyRows

Fixed

• Add @mixin docblock to all macroable classes to allow for IDE autocompletion of delegate classes
• Fix issue with Excel::toArray not allowing nullable reader types for uploaded files

Changed

• Change default Csv Import to auto-detect the delimiter when not explicitly defined

Fixed

• Fix return type of FromQuery::query()

Changed

• Support Laravel 9
• Added a config setting to specify DB connection
• Added a config setting to specify CSV output encoding
• Added an ability to specify CSV output encoding through csvSettings

Fixed

• Removed cache flush for cell caching as this is already handled by PhpSpreadsheet
• Fix SkipsEmptyRows support with the WithColumnLimit concern
• Added range support to FormatColumn

Changed

• Change default local_path configuration
• Fix queueImport function to be able to assert chained jobs
• Skipped failure no longer persists in ToCollection and ToArray.
• Fix missing InteractsWithQueue trait in AppendToSheet jobs
• Add return types to Row's ArrayAccess implementation

Fixed

• Make TransactionManager a singleton (#3270)
• Fix Exportable disk options (#3296)
• Delete temporary file after exception in import class (#3312)

Added

• Add assertExportedInRaw assertion (#3255)

Fixed

• Make commands detect model directory now (#3213)

Added

• Custom heading row formatter can use column index (#3166)
• Added WithFormatData concern (#3154)

Fixed

• Create failures of rows than didn't exist but where requested in row validation
• Fix Bug Formulas are not calculated when import implements WithCalculatedFormulas with SkipsEmptyRows #3127
• PhpSpreadsheet 1.18 support

Added

• Octane compatibility

Fixed

• Fix AfterImport Event not being called (#3085)

Added

• Added WithUpsertColumns concern (#3046)
• Added ShouldQueueWithoutChain concern (#3072)

Fixed

• Limit Phpspreadsheet version to 1.16 until bugfix release
• Fixed issue with not autosizing columns (#3055)
• Fix selecting worksheets by name with chunk reading (#3052)

Added

• Added SkipsEmptyRows concern
• Added HasReferencesToOtherSheets concern to allow import of calculated

Changed

• Bump minimum PhpSpreadsheet version
• Progressbar NullOutput as fallback

Added

• PHP 8 support

Added

• Added an ability to prepare rows before appending rows to sheet. Just add prepareRows method for your export class if needed.
• Added an ability to catch exceptions from QueueExport job. Just add failed method for your export class if needed.
• Added an ability to set locale for queued export. Just implement Illuminate\Contracts\Translation\HasLocalePreference for your export.
• Added JsonSerializable support in Maatwebsite\Excel\Validators\Failure.
• Added $maxExceptions support in Maatwebsite\Excel\Jobs\ReadChunk.php.
• Added support to upsert models by implementing the WithUpserts concern.

Added

• Added support for prepareForValidation on WithValidation concern
• Added support for withValidator on WithValidation concern
• Added ArrayAccess to Row

Fixed

• Corrected SkipsErrors doc block

Added

• Added ignore_empty setting to config/excel.php
• Added strict_null_comparison setting to config/excel.php

• Laravel 8 support
• Lumen improvements

Added

• Added WithProperties concern
• Added default spreadsheet properties config
• Added WithColumnWidths concern
• Added WithStyles concern.
• Config setting to configure cell caching

Changed

• Sheet titles longer than 31 chars get trimmed.
• Sheet titles with unsupported chars get cleaned.

Fixed

• Fixed issue with using ShouldAutosize in combination with FromView column widths.

Added

• Re-sycing remote temporary file
• Remember row number
• Remember chunk offset
• WithColumnLimit concern
• WithReadFilter concern
• Publishing the stubs

Changed

• Interacting with queued jobs
• Retry until and middleware on queued imports
• Using WithValidation with FromCollection & FromArray
• Read filters for WithLimit and HeadingRowImport
• Bump of minimum version PhpSpreadsheet

Fixed

• Fixed test helper docblocks on the Excel facade.
• Fix for importing with a start row beyond the highest row.
• Fixed BeforeSheet and AfterSheet events receiving exportable instance instead of importable when calling on an Import.
• Fix for value binders not working in queued exports.
• Fix when using WithLimit concern when having less rows than the limit.
• Fix AfterImport job being fired twice if not using queueing.
• Raw() method now also available on Exportable.
• Fix for breaking changes in PhpSpreadsheet with empty enclosures.

Older release notes can be found in Github releases.