All notable changes to this project will be documented in this file.
- Add support for ignoring PHP auto_detect_line_endings INI directive
- Fix output of
WithFormatData
in combination withSkipsEmptyRows
(#3760)
- Cast empty headings to indexed integer (#3646)
- Adds
isEmptyWhen
to customize is row empty logic. (#3645)
- 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).
- 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
- Fix PHP8.1 return type for Failure class (#3588)
3.1.38 - 2022-03-24
- Adds concern
WithGroupedHeadingRow
to allow imported sheets to group the values of columns with the same header in an array
- Fix for
prepareForValidation
callback not being called when usingSkipsEmptyRows
3.1.37 - 2022-02-28
- 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
- Change default Csv Import to auto-detect the delimiter when not explicitly defined
3.1.36 - 2022-02-03
- Fix return type of
FromQuery::query()
- 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
- Removed cache flush for cell caching as this is already handled by PhpSpreadsheet
- Fix
SkipsEmptyRows
support with theWithColumnLimit
concern - Added range support to FormatColumn
3.1.34 - 2021-12-2
- Change default local_path configuration
- Fix queueImport function to be able to assert chained jobs
- Skipped failure no longer persists in
ToCollection
andToArray
. - Fix missing InteractsWithQueue trait in AppendToSheet jobs
- Add return types to
Row
'sArrayAccess
implementation
3.1.33 - 2021-08-12
- 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
- Add assertExportedInRaw assertion (#3255)
- Make commands detect model directory now (#3213)
3.1.31 - 2021-06-02
- Custom heading row formatter can use column index (#3166)
- Added WithFormatData concern (#3154)
- 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
- Octane compatibility
3.1.29 - 2021-03-16
- Fix AfterImport Event not being called (#3085)
3.1.28 - 2021-03-10
- Added WithUpsertColumns concern (#3046)
- Added ShouldQueueWithoutChain concern (#3072)
- 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 SkipsEmptyRows concern
- Added HasReferencesToOtherSheets concern to allow import of calculated
- Bump minimum PhpSpreadsheet version
- Progressbar NullOutput as fallback
3.1.26 - 2020-11-13
- PHP 8 support
3.1.25 - 2020-11-13
- 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 addfailed
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 inMaatwebsite\Excel\Validators\Failure
. - Added
$maxExceptions
support inMaatwebsite\Excel\Jobs\ReadChunk.php
. - Added support to upsert models by implementing the
WithUpserts
concern.
3.1.24 - 2020-10-28
- Added support for
prepareForValidation
onWithValidation
concern - Added support for
withValidator
onWithValidation
concern - Added
ArrayAccess
toRow
- Corrected SkipsErrors doc block
3.1.23 - 2020-09-29
- Added
ignore_empty
setting toconfig/excel.php
- Added
strict_null_comparison
setting toconfig/excel.php
3.1.22 - 2020-09-08
- Laravel 8 support
- Lumen improvements
3.1.21 - 2020-08-06
- Added WithProperties concern
- Added default spreadsheet properties config
- Added WithColumnWidths concern
- Added WithStyles concern.
- Config setting to configure cell caching
- Sheet titles longer than 31 chars get trimmed.
- Sheet titles with unsupported chars get cleaned.
- Fixed issue with using ShouldAutosize in combination with FromView column widths.
3.1.20 - 2020-07-22
- Re-sycing remote temporary file
- Remember row number
- Remember chunk offset
- WithColumnLimit concern
- WithReadFilter concern
- Publishing the stubs
- 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 test helper docblocks on the Excel facade.
- Fix for importing with a start row beyond the highest row.
- Fixed
BeforeSheet
andAfterSheet
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.