Export

[anishsarkar]

Hi,

I am looking for export feature of my resource. I am using Spatie\SimpleExcel. So far I have been able to write the csv file (I am happy with csv, no need for excel, but I guess once that csv works, excel would also work).

Here is my code

### ListUsers.php 


protected function getTableBulkActions(): array
{
    return [
        BulkAction::make('export')
            ->action( fn (Collection $records) => 
                SimpleExcelWriter::create( storage_path('app/export.csv'))
                    ->addRows($records->toArray())
            )->deselectRecordsAfterCompletion()
    ];
}

This seems to work. The file is written in the disk with appropriate data. But I am trying to stream the file to the browser. So I am trying the suggested streamDownload and toBrowser in the documentation of SimpleExcel. Here is the code (this does not work)

protected function getTableBulkActions(): array
{
    return [
        BulkAction::make('export')
            ->action( fn (Collection $records) => 
                $writer = SimpleExcelWriter::streamDownload('export.csv')
                    ->addRows($records->toArray())
                    ->toBrowser()
            )->deselectRecordsAfterCompletion()
    ];
}

But this neither showing in browser or asking the browser to download it. Thanks in advance for any help to overcome this.