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

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 compatability 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 ouput 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 exists 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.