Create Excel Files With Explicit Cell Datatype In PHP Using PHPSpreadSheet

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

$ composer install

<?php

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

// Import the core class of PhpSpreadsheet
use PhpOffice\PhpSpreadsheet\Spreadsheet;

// Import the Xlsx writer class
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// Create a new Spreadsheet object
$spreadsheet = new Spreadsheet();

// Retrieve the current active worksheet
$sheet = $spreadsheet->getActiveSheet();

// Set cell A1 with a "1" numeric value
$sheet->getCell('A1')->setValueExplicit(
    '1',
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC
);

// Set cell A2 with a "True" boolean value
$sheet->getCell('A2')->setValueExplicit(
    true,
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_BOOL
);

// Set cell A4 with a "Hello World !" string value with datatype numeric
/*$sheet->getCell('A4')->setValueExplicit(
    "Hello World !",
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC
);*/

// Write a new .xlsx file
$writer = new Xlsx($spreadsheet);

// Save the new .xlsx file
$writer->save('create-xlsx-files-with-explicit-cell-datatype.xlsx');

$ php create-xlsx-files-with-explicit-cell-datatype.php

// Set cell A1 with a "1" numeric value
$sheet->getCell('A1')->setValueExplicit(
    '1',
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC
);

// Set cell A2 with a "True" boolean value
$sheet->getCell('A2')->setValueExplicit(
    true,
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_BOOL
);

$sheet->getCell('A4')->setValueExplicit(
    "Hello World !",
    \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC
);