ItSolutionStuff.com

Laravel Maatwebsite Excel Set Font Color Example

By Hardik Savani • April 16, 2024
Laravel

Here, i will show you laravel maatwebsite excel set font color. i would like to share with you laravel excel font color. if you want to see example of laravel maatwebsite getColor() then you are a right place. step by step explain how to add font color in laravel excel maatwebsite.

We will use getColor() for set font color in laravel maatwesite composer package. you can use this example with laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 version.

You can follow bellow url for checking full example of Import and Export Excel File with laravel. Here i will give you solution with export class:

Laravel Import Export Excel and CSV File Tutorial

Solution:

app/Exports/UsersExport.php

<?php

namespace App\Exports;

use App\Models\User;

use Maatwebsite\Excel\Concerns\FromCollection;

use Maatwebsite\Excel\Concerns\WithHeadings;

use Maatwebsite\Excel\Concerns\WithEvents;

use Maatwebsite\Excel\Events\AfterSheet;

class UsersExport implements FromCollection, WithHeadings, WithEvents

{

/**

* Write code on Method

*

* @return response()

*/

public function collection()

{

return User::select("id", "name", "email")->get();

}

/**

* Write code on Method

*

* @return response()

*/

public function headings() :array

{

return [

'ID',

'Name',

'Email',

];

}

/**

* Write code on Method

*

* @return response()

*/

public function registerEvents(): array

{

return [

AfterSheet::class => function(AfterSheet $event) {

$event->sheet->getDelegate()->getStyle('A1:C1')

->getFont()

->getColor()

->setARGB('DD4B39');

},

];

}

}

Output:

I hope it can help you...

Tags: Laravel
Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

📺 Subscribe on YouTube

We Are Recommending You

Laravel Maatwebsite Excel Increase Font Size Example

Read Now →

Laravel Maatwebsite Excel Fix Header Row using freezePane()

Read Now →

Laravel Maatwebsite Excel Set Background Color Example

Read Now →

Laravel - Create CSV File from Custom Array using Maatwebsite

Read Now →

How to Validate Excel Sheet Data in Laravel?

Read Now →

How to Import Database in Mysql using Command Line in Ubuntu?

Read Now →

Laravel Import Large SQL File using Seeder Example

Read Now →

Laravel 8 Import Export Excel and CSV File Tutorial

Read Now →

Laravel 8 Mail | Laravel 8 Send Email Tutorial

Read Now →

Laravel 8 Database Seeder Tutorial Example

Read Now →

Laravel 7/6 Import Export Excel & CSV File Tutorial

Read Now →