All notable changes to this project will be documented in this file.
- formatColumn added range support
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.