Concern overview

Interface	Explanation	Documentation
Maatwebsite\Excel\Concerns\FromArray	Use an array to populate the export.	Data sources
Maatwebsite\Excel\Concerns\FromCollection	Use a Laravel Collection to populate the export.	Data sources
Maatwebsite\Excel\Concerns\FromGenerator	Use a generator to populate the export.	Data sources
Maatwebsite\Excel\Concerns\FromIterator	Use an iterator to populate the export.
Maatwebsite\Excel\Concerns\FromQuery	Use an Eloquent query to populate the export.	Data sources
Maatwebsite\Excel\Concerns\FromScout	Use a Laravel Scout query to populate the export.	Data sources
Maatwebsite\Excel\Concerns\FromView	Use a (Blade) view to populate the export.	Data sources
Maatwebsite\Excel\Concerns\HasReferencesToOtherSheets	Allows precalculated values where one sheet has references to another sheet.
Maatwebsite\Excel\Concerns\ShouldAutoSize	Auto-size the columns in the worksheet.	Presentation
Maatwebsite\Excel\Concerns\WithBackgroundColor	Set the default background fill colour for the worksheet.	Presentation
Maatwebsite\Excel\Concerns\WithCharts	Allows running one or multiple PhpSpreadsheet Chart instances.
Maatwebsite\Excel\Concerns\WithColumnFormatting	Format certain columns.
Maatwebsite\Excel\Concerns\WithColumns	Define typed columns for exports and imports.	Columns
Maatwebsite\Excel\Concerns\WithColumnWidths	Set column widths.	Presentation
Maatwebsite\Excel\Concerns\WithCustomChunkSize	Allows Exportables to define their chunk size.
Maatwebsite\Excel\Concerns\WithCustomCsvSettings	Allows running custom CSV settings for this specific exportable.	Settings
Maatwebsite\Excel\Concerns\WithCustomQuerySize	Allows Exportables that implement the FromQuery concern to provide their own custom query size.
Maatwebsite\Excel\Concerns\WithCustomStartCell	Allows specifying a custom start cell. Only supported for FromCollection exports.	Data sources
Maatwebsite\Excel\Concerns\WithCustomValueBinder	Allows specifying a custom value binder.	Custom Value Binder
Maatwebsite\Excel\Concerns\WithDrawings	Allows running one or multiple PhpSpreadsheet Drawing instances.
Maatwebsite\Excel\Concerns\WithEvents	Register events to hook into the PhpSpreadsheet process.
Maatwebsite\Excel\Concerns\WithHeadings	Prepend a heading row.	Presentation
Maatwebsite\Excel\Concerns\WithMapping	Format the row before it's written to the file.	Presentation
Maatwebsite\Excel\Concerns\WithMultipleSheets	Enable multi-sheet support. Each sheet can have its own concerns (except this one).
Maatwebsite\Excel\Concerns\WithPreCalculateFormulas	Forces PhpSpreadsheet to recalculate all formulae when saving.
Maatwebsite\Excel\Concerns\WithProperties	Allows setting document properties.	Settings
Maatwebsite\Excel\Concerns\WithStrictNullComparison	Uses strict comparisons when testing cells for null values.	Data sources
Maatwebsite\Excel\Concerns\WithStyles	Allows setting styles on worksheets.	Presentation
Maatwebsite\Excel\Concerns\WithExportTemplate	Base an export on an existing spreadsheet file, preserving its styles, formulas and extra sheets.	Export Templates
Maatwebsite\Excel\Concerns\WithTitle	Set the Workbook or Worksheet title.
Maatwebsite\Excel\Concerns\ShouldBatch	Dispatch queued exports or chunked imports as a job batch instead of a chain.	Performance
Maatwebsite\Excel\Concerns\ShouldQueueWithoutChain	Dispatch each import chunk independently rather than as a chain.	Queued imports

Traits

Trait	Explanation	Documentation
Maatwebsite\Excel\Concerns\Exportable	Add download/store abilities directly on the export class itself.	Exporting
Maatwebsite\Excel\Concerns\RegistersEventListeners	Auto-register the available event listeners.