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