Category: PhpSpreadsheet

  • 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 […]

  • Merge Cells In Excel Files In PHP Using PHPSpreadSheet

    Using the generated file from the tutorial Create Xlsx Files With Different Cell Background Colors, learn how to merge cells in PhpSpreadsheet. Requirements: Composer PHP 7.2 or newer Before Cell Merging 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 Text Links In PHP Using PHPSpreadSheet

    Write texts with links on a new xlsx file, either an external link to a website, or an internal link within another sheet is possible. 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 Underlined Texts In PHP Using PHPSpreadSheet

    Underline cell texts on a new xlsx file. 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 core […]

  • Create Excel Files With Different Cell Font Colors In PHP Using PHPSpreadSheet

    Create an xlsx file and write texts with different cell font colors. 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’; […]