In cases the file is yet to be identified, the method IOFactory::identify() can be used to automatically identify a file type. The file type is needed to instantiate the reader object.

Requirements:

• Composer
• PHP 7.2 or newer

Step 1.

Setup dependencies.

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

composer.json

Step 2.

Install phpspreadsheet.

$ composer install

command line

Step 3.

Create a new PHP file, and start coding.

<?php

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

// Import the IOFactory class
use \PhpOffice\PhpSpreadsheet\IOFactory;

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

// Identify the file type using the IOFactory object
$inputFileType = IOFactory::identify($inputFileName);

// Display the file type
echo $inputFileType;

identify-file-types.php

Test.

Command line testing.

$ php identify-file-types.php

command line

Result.

References:

• How to install PhpSpreadsheet
• Creating a spreadsheet
• Reading Files