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

Posted

in

by

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"
    }
}

Step 2.

Install phpspreadsheet.

$ composer install

Step 3.

Create a new PHP file, and start coding.

<?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 the "Hello World !" string value
$sheet->setCellValue('A1', 'Hello World !');

// Set cell A1 font color to red
$sheet->getStyle('A1')->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);

// Set cell A2 with the "Hello World !" string value
$sheet->setCellValue('A2', 'Hello World !');

// Set cell A2 font color to blue
$sheet->getStyle('A2')->getFont()->getColor()->setARGB('FF0000FF');

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

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

Test.

Run the following codes.

$ php create-xlsx-files-with-different-cell-font-colors.php

Result.

Open the generated file create-xlsx-files-with-different-cell-font-colors.xlsx.

References:


Posted

in

by

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest Tutorials

Web Dev Tutorials