Read Excel Files In PHP Using PHPSpreadSheet

{
    "require": {
        "phpoffice/phpspreadsheet": "^1.3"
    }
}

$ composer install

<?php

// Autoload dependencies
require 'vendor/autoload.php';

// Import the Xlsx reader class
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

// Full path of the file to read
$inputFileName = 'create-xlsx-files.xlsx';

// Create the reader object
$reader = new Xlsx();

// Load the file to read
$spreadsheet = $reader->load($inputFileName);

// Get the active sheet
$sheet = $spreadsheet->getActiveSheet();

/**
 * Get the value of column A, row 1 using the
 * combination of the column letter and row number.
 */
echo $sheet->getCell('A1')->getValue();

echo PHP_EOL;

/**
 * Get the value of column A, row 1 using the
 * combination of the column number and row number.
 */
echo $sheet->getCellByColumnAndRow('1', '1')->getValue();

$ php read-xlsx-files.php