# 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\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

# 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.