Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

Oct 10, 2023

5

OP

Level 4

Export to Excel

I have a pre-formated Excel sheet and I want to fill it in with data in Laravel. It is basically the standard form that the company uses. The workflow would be:

User fill-in info in the Laravel app.
User download or print off the form with info.

I can get step one working ok but not sure about step 2. In VBA I can open an Excel form and fill in info using named ranges. What package should I use to do that in PHP?

Level 6

if you want to export data from table database to excel may you can try this package maatwebsite/excel

1 like

OP

Level 4

@tangtang Thank you. I had a look at that and read the doc but there is nothing about opening an existing excel file and fill it with data.

Level 122

@anchan42 No, it only supports exporting to a new file.

Best Answer

Level 122

There is a package here that allows you to use a template, and describe in that template what Laravel fields you want to insert or iterate over

https://laravel-news.com/generate-documents-in-php-with-an-excel-template

1 like

OP

Level 4

Thank you. It looks exactly like what I want. I will try it out.

Please or to participate in this conversation.