Excel Laravel Package

• 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](https://github.com/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

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.

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