Mindblown: a blog about philosophy.

  • Create Excel Files With Explicit Cell Datatype In PHP Using PHPSpreadSheet

    Explicitly set a cell’s datatype when creating an xslx file with PhpSpreadsheet. 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’; […]

  • Create Excel Files With Line Breaks In PHP Using PHPSpreadSheet

    Using PhpSpreadsheet, write text contents in an xlsx file with each words or paragraphs on it’s own line. 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. […]

  • Create Excel Files With Formulas In PHP Using PHPSpreadSheet

    Write formulas in an xlsx file, and easily compute for an average, sum a range of cell values, and even set a conditional formula based on a given cell value. These are just a few of the many formulas you can write in creating xlsx files with PhpSpreadsheet. Requirements: Composer PHP 7.2 or newer Step […]

  • Create Excel Files With Date And Time Data In PHP Using PHPSpreadSheet

    Create a new xlsx file with correct cell date format settings. 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’; // […]

  • Set Metadata Of Excel Files In PHP Using PHPSpreadSheet

    Create a new xlsx file and set it’s metadata properties. Author / Creator Last Modified / Saved By Title Subjects Tags / Keywords Category Description 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 […]

  • Create Excel Files With Italic Texts In PHP Using PHPSpreadSheet

    Stylize the fonts on an xlsx file and make it italic with this PhpSpreadsheet tutorial. 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 […]

  • Create Excel Files With Bold Texts In PHP Using PHPSpreadSheet

    Easily make the font weight thick in xlsx file with this PhpSpreadsheet tutorial. 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 […]

  • Update Excel Files In PHP Using PHPSpreadSheet

    Edit texts, links, font colors, background colors, and many more. Learn how to update xlsx files in this PhpSpreadsheet tutorial. The generated file from Create Xlsx Files With Underlined Texts will be used as the sample xlsx file to be updated. Requirements: Composer PHP 7.2 or newer Before Xlsx file update. Step 1. Setup dependencies. […]

  • Unmerge Cells In Excel Files In PHP Using PHPSpreadSheet

    After the tutorial Merge Cells In Xlsx Files in PhpSpreadsheet, unmerging cells in xlsx files in PhpSpreadsheet is the next example to read. The file from Merge Cells In Xlsx Files will be used as a sample to unmerged the cells in an xlsx file. Requirements: Composer PHP 7.2 or newer Before Cell Unmerging Step […]

Got any book recommendations?

Get In Touch