Excel Export autofit column width for header, registerEvent() is not working
I want to implement Header column width autofit as per the header content size, i had applied registerEvent() but it is not working.
I also applied dd() and Log but nothing is printed in log file, if i add Log in constructor , it prints ( so no issue on log configuration )
My project tech stacks are : Laravel v11.x, filament v3.2 , livewire v3.0, maatwebsite/excel v3.1
My export file resides in : app/Filament/Exports/UserExporter.php
=============================================UserExporter.php==================================
class UserExporter extends Exporter implements WithEvents
{
protected static ?string $model = User::class;
public static function getColumns(): array
{
return [
ExportColumn::make('id')->label('User ID'),
ExportColumn::make('team.name')->label('Team Name'),
];
}
public static function getCompletedNotificationBody(Export $export): string
{
$body = 'Your case export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
if ($failedRowsCount = $export->getFailedRowsCount()) {
$body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
}
return $body;
}
public function registerEvents(): array
{
Log::debug('method is called');
Log::info('AfterSheet event triggered!');
return [
AfterSheet::class => function (AfterSheet $event) {
Log::info('AfterSheet event triggered!');
foreach (range('A', 'Z') as $columnID) {
Log::info('Resizing column ' . $columnID);
$event->sheet->getDelegate()->getColumnDimension($columnID)->setAutoSize(true);
}
},
];
}
I have already removed a cache, also tested in incognito window...
I also applied dd() and Log but nothing is printed in log file, if i add Log in constructor , it prints ( so no issue on log configuration )
My project tech stacks are : Laravel v11.x, filament v3.2 , livewire v3.0, maatwebsite/excel v3.1
My export file resides in : app/Filament/Exports/UserExporter.php
=============================================UserExporter.php==================================
class UserExporter extends Exporter implements WithEvents
{
protected static ?string $model = User::class;
public static function getColumns(): array
{
return [
ExportColumn::make('id')->label('User ID'),
ExportColumn::make('team.name')->label('Team Name'),
];
}
public static function getCompletedNotificationBody(Export $export): string
{
$body = 'Your case export has completed and ' . number_format($export->successful_rows) . ' ' . str('row')->plural($export->successful_rows) . ' exported.';
if ($failedRowsCount = $export->getFailedRowsCount()) {
$body .= ' ' . number_format($failedRowsCount) . ' ' . str('row')->plural($failedRowsCount) . ' failed to export.';
}
return $body;
}
public function registerEvents(): array
{
Log::debug('method is called');
Log::info('AfterSheet event triggered!');
return [
AfterSheet::class => function (AfterSheet $event) {
Log::info('AfterSheet event triggered!');
foreach (range('A', 'Z') as $columnID) {
Log::info('Resizing column ' . $columnID);
$event->sheet->getDelegate()->getColumnDimension($columnID)->setAutoSize(true);
}
},
];
}
I have already removed a cache, also tested in incognito window...
