Read Data from 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. Read data from MS Excel (XLSX) file:

1
2
3
4
5
6
7
8
9
10
11
12
<?php

use PhpOffice\PhpSpreadsheet\IOFactory;

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

$spreadsheet = IOFactory::load('test.xlsx');
$sheet = $spreadsheet->getActiveSheet();

$data = $sheet->toArray();

print_r($data);