Write Data to MS Excel (XLSX) File using PHP

phpoffice/phpspreadsheet library

1. Add phpoffice/phpspreadsheet library to composer.json file:

1
2
3
"require": {
    "phpoffice/phpspreadsheet": "^1.14"
}

2. Install library from the command line:

1
composer install

3. Write data to MS Excel (XLSX) file:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<?php

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

require_once __DIR__.'/vendor/autoload.php';

$data = [
    ['John', 25],
    ['Mary', 30],
    ['Robert', 42],
];

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$row = 1;
foreach ($data as $item) {
    $sheet->setCellValueByColumnAndRow(1, $row, $item[0]);
    $sheet->setCellValueByColumnAndRow(2, $row, $item[1]);
    $row++;
}

$writer = new Xlsx($spreadsheet);
$writer->save('test.xlsx');