FromGenerator exports an empty file when it is queued

[alrisha]

Hi.. When i try to use queue with FromGenerator, i have a blank file with only headers...

Laravel Excel version: 3.1.48

Laravel version: 10.22.0

PHP version: 8.1

This is my class

class LeadArchiveExport implements FromGenerator ShouldAutoSize, WithColumnFormatting, WithColumnWidths, WithCustomQuerySize, WithHeadings, WithMapping, WithStyles
{
....

 public function generator(): Generator
    {
        for (Lead::all() as $lead) {
            yield $lead;
        }
    }

With this command

Excel::download(new LeadArchiveExport($fields), 'temp.xlsx');

The export works perfectly.

But if I try to use queue

 Excel::queue(new LeadArchiveExport($fields), $tempFileName, 'temp')
            ->chain(
                [
                    new CompleteExportJob(
                        $request->user(),
                        Arr::get($fields, 'export_email', ''),
                        $tempFileName
                    ),
                ]
            );

I have a empty file with only headers...

Maybe queue and FromGenerator are NOT compatible ?

PS: I should try to use FromGenerator because with FromQuery I have a memory error...

[setharell]

@alrisha did you ever figure out what the issue was with this? I have run into the same issue and can't figure out how to get FromGenerator to work with queues.

[Observer5]

the same problem

[IonBazan]

Yes, FromGenerator, FromArray and FromIterator are not supported by QueuedWriter. See: #4318. You should use FromQuery instead:

class LeadArchiveExport implements FromQuery ShouldAutoSize, WithColumnFormatting, WithColumnWidths, WithCustomQuerySize, WithHeadings, WithMapping, WithStyles
{
....

    public function query(): EloquentBuilder
    {
        return Lead::query();
    }

Since many users face similar issues, perhaps we could document this behaviour better and/or throw exception if an unsupported export is passed to a queued writer instead of silently exporting an empty file.