Generate Documents in PHP With an Excel Template – Laravel News

The AnourValar/office package is a PHP +8.1 library to generate documents from XLSX templates. Given a template like the following example template (from the readme):

Using the following code you can generate a document using the template values:

 1$data = [
 2    // scalar
 3    'vat' => 'No',
 4    'total' => [
 5        'price' => 2004.14,
 6        'qty' => 3,
 7    ],
 8 
 9    // one-dimensional table
10    'products' => [
11        [
12            'name' => 'Product #1',
13            'price' => 989,
14            'qty' => 1,
15            'date' => new DateTime('2022-03-30'),
16        ],
17        [
18            'name' => 'Product #2',
19            'price' => 1015.14,
20            'qty' => 2,
21            'date' => new DateTime('2022-03-31'),
22        ],
23    ],
24];
25 
26// Save as XLSX (Excel)
27(new AnourValarOfficeTemplateService())
28    ->generate(
29        'template1.xlsx', // path to template
30        $data // input data
31    )
32    ->saveAs(
33        'generated_document.xlsx', // path to save
<span class=".......
Source: https://laravel-news.com/generate-documents-in-php-with-an-excel-template