CHANGELOG.md

Changelog

All notable changes to this project will be documented in this file.

Please view https://github.com/SpartnerNL/Laravel-Excel/releases for the most recent changelog

[4.0.0] - Unreleased

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)

3.1.47 - 2023-02-16

• Support Laravel 10

Fixed

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

3.1.46 - 2023-01-27

• Support Laravel 10

3.1.45 - 2023-01-02

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.

3.1.44 - 2022-10-14

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)

3.1.40 - 2022-05-02

• 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

3.1.39 - 2022-04-23

Fixed

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

3.1.38 - 2022-03-24

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

3.1.37 - 2022-02-28

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

3.1.36 - 2022-02-03

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

3.1.35 - 2022-01-04

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

3.1.34 - 2021-12-2

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

3.1.33 - 2021-08-12

Fixed

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

3.1.32 - 2021-07-08

Added

• Add assertExportedInRaw assertion (#3255)

Fixed

• Make commands detect model directory now (#3213)

3.1.31 - 2021-06-02

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

3.1.30 - 2021-04-06

Added

• Octane compatibility

3.1.29 - 2021-03-16

Fixed

• Fix AfterImport Event not being called (#3085)

3.1.28 - 2021-03-10

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)

3.1.27 - 2021-02-22

Added

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

Changed

• Bump minimum PhpSpreadsheet version
• Progressbar NullOutput as fallback

3.1.26 - 2020-11-13

Added

• PHP 8 support

3.1.25 - 2020-11-13

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.

3.1.24 - 2020-10-28

Added

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

Fixed

• Corrected SkipsErrors doc block

3.1.23 - 2020-09-29

Added

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

3.1.22 - 2020-09-08

• Laravel 8 support
• Lumen improvements

3.1.21 - 2020-08-06

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.

3.1.20 - 2020-07-22

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.