Download file in Livewire

[gid-m]

Any leads on how to download the generated file on Laravel Livewire. I have followed the documentation as follows:
$writer = SimpleExcelWriter::streamDownload('some-name.csv');

$row = WriterEntityFactory::createRowFromArray(['Hello', 'World']);

$writer->addRow($row);

$writer->toBrowser();

but nothing happens when on click of a button, I call a function containing this code.

[freekmurze]

I haven't had to do this myself yet. If you find out, let us know, and I'll put it in the readme.

[Ceepster14]

Hi,

I think it's definitely worth adding something in the readme about this as I just hit the same problem by using this package within a Livewire component and this answer saved me a lot of head scratching as otherwise the attempted download just fails silently which makes it tough to identify the cause.

[gauravgargcs]

hello can you help me in this, i am stuck also

[gid-m]

After tinkering with it, I ended up having to do this to start the download:

$writer->addRow($row);

return response()->streamDownload(function () use ($writer) {
            $writer->close();
        },  $fileName);

Hence omitting $writer->toBrowser();

[gauravgargcs]

hello, i have same issue and i can not resolve, can you please tell me what is wrong i am doing-
$rows = [];
User::query()
->where('role', 'like', '%' . $this->search . '%')
->where('name', 'like', '%' . $this->search_name . '%')
->lazyById(2000, 'id')
->each(function ($user) use (&$rows) {
$rows[] = $user->toArray();
});
$fileName='users.csv';
$writer= SimpleExcelWriter::streamDownload($fileName);
$writer->addRows($rows);
return response()->streamDownload(function () use ($writer) {
$writer->close();
}, $fileName);

[shokanshi]

If you are calling your code from another class, you will need to return the method call from the component too.

e.g.

class A {
  public function data() {
    // do something here
    return response()->streamDownload(function () use ($writer) {
        $writer->close();
    }, $fileName);
  }
}

class LiveWireComponent extends Component
{
    public function download() {
        return app(A::class)->data();
    }
}

[gauravgargcs]

hello, thanks for reply, i am calling in component like this, can you guide please where i am doing wrong

class UserManagement extends Component
{
public function export()
    {
        $rows = [];
        User::query()
            ->where('role', 'like', '%' . $this->search . '%')
            ->where('name', 'like', '%' . $this->search_name . '%')
            ->lazyById(2000, 'id')
            ->each(function ($user) use (&$rows) {
                $rows[] = $user->toArray();
            });
            $fileName='users.csv';
            $writer= SimpleExcelWriter::streamDownload($fileName);
            $writer->addRows($rows);
            return response()->streamDownload(function () use ($writer) {
                $writer->close();
            },  $fileName);
    }
}

[shokanshi]

You can try:

public function export()
{
        $fileName = 'example.xlsx';

        $writer = SimpleExcelWriter::streamDownload($fileName)
        ->nameCurrentSheet('Users')
        ->addHeader(['name', 'role']);

        User::query()->where('role', 'like', "%{$this->search}%")
        ->select(['name', 'role'])
        ->chunk(2000, function (Collection $users) use ($writer) {
                foreach ($users as $user) {
                        $writer->addRow($user->toArray());
                }

                flush();
        });

        return response()->streamDownload(function () use ($writer) {
                $writer->close();
        },  $fileName);
}

[gauravgargcs]

problem resolved thanks