[Bug]: No writer found for type xlsx

[skfaisal93]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• [X] Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1.44

What version of Laravel are you using?

8.83.25

What version of PHP are you using?

8.0

Describe your issue

I have followed 5 minute quick start from your documentation.

While downloading the excel file I get the following error

Call to undefined method Symfony\Component\HttpFoundation\BinaryFileResponse::header()

To overcome this I have added writerType parameter to Excel::download function. So it looks like as follows

return Excel::download(new UsersExport, 'users.xlsx', 'xlsx');

This gave me following error

PhpOffice\PhpSpreadsheet\Writer\Exception
No writer found for type xlsx

How can the issue be reproduced?

1. Follow this minute quick start guide from documentation
2. In UserController.php, export function should look as below

public function export()
{
    return Excel::download(new UsersExport, 'users.xlsx', 'xlsx');
}

3. Hit the route url in the browser

What should be the expected behaviour?

As per the documentation, the xlsx file should be downloaded in the dowloads folder

[Naghal]

Hi, you need to use 'Xlsx' with a capital X. Otherwise, you can use \Maatwebsite\Excel\Excel::XLSX

[stale[bot]]

This bug report has been automatically closed because it has not had recent activity. If this is still an active bug, please comment to reopen. Thank you for your contributions.