PHP | Spreadsheet_Excel_Writer | setFgColor() Function

The setFgColor() function is an inbuilt function in PHP | Spreadsheet_Excel_Writer which is used to set the foreground color for the cell of the spreadsheet. In order to use this function use the setPattern function. Here, “foreground” means the top layer of a cell’s background.

Syntax:

void Format::setFgColor( $color )

Parameters: This function accepts single parameter $color which takes the value of color as string like ‘red’, ‘green’ and another method by specifying the color codes between 8 to 63.



Return Value: This function returns TRUE on success and PEAR_ERROR on failure.

Example 1:

filter_none

edit
close

play_arrow

link
brightness_4
code

<?php
  
require_once 'Spreadsheet/Excel/Writer.php';
  
// Create Spreadsheet Excel Writer Object
$workbook = new Spreadsheet_Excel_Writer();
  
// Add Worksheet to the spreadsheet
$worksheet =& $workbook->addWorksheet();
  
// Add "regular" green to the cell
$format_regular_green =& $workbook->addFormat();
$format_regular_green->setFgColor('green');
  
// Add "special" green to the cell
$format_special_green =& $workbook->addFormat();
$format_special_green->setFgColor(11);
  
// Set Custom Green Color
$workbook->setCustomColor(12, 10, 200, 10);
$format_our_green =& $workbook->addFormat();
$format_our_green->setFgColor(12);
  
// Set Column width
$worksheet->setColumn(0, 0, 30);
  
// Add data to the spreadsheet 
$worksheet->write(0, 0, "GeeksforGeeks", $format_regular_green);
$worksheet->write(1, 0, "Sarthak Prajapati", $format_special_green);
$worksheet->write(2, 0, "sarthak_ishu11", $format_our_green);
  
// Send file to the browser
$workbook->send('setFgColor.xls');
  
// Close the file 
$workbook->close();
?>

chevron_right


Output:

Example 2:

filter_none

edit
close

play_arrow

link
brightness_4
code

<?php
  
require_once 'Spreadsheet/Excel/Writer.php';
  
// Create Spreadsheet_Excel_Writer Object
$workbook = new Spreadsheet_Excel_Writer();
  
// Add Worksheet
$worksheet =& $workbook->addWorksheet();
  
// Set Font Family Times New Roman 
$format_setFgColor =& $workbook->addFormat();
$format_setFgColor->setFontFamily('Times New Roman');
  
// Set Italic Property
$format_setFgColor->setItalic();
  
// Set Shadow to text
$format_setFgColor->setShadow();
  
// Set the foreground color 
$format_setFgColor->setBgColor('yellow');
  
// Set the pattern
$format_setFgColor->setPattern(4);
  
// Write to Worksheet
$worksheet->write(0, 0, "Information", $format_setFgColor);
$worksheet->write(1, 0, "Website Name", $format_setFgColor);
$worksheet->write(1, 1, "Address", $format_setFgColor);
$worksheet->write(2, 0, "GeeksforGeeks", $format_setFgColor);
$worksheet->write(2, 1, "https://www.geeksforgeeks.org/", $format_setFgColor);
$workbook->send('test.xls');
  
$workbook->close();
?> 

chevron_right


Output:

Reference: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.setfgcolor.php



My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.



Improved By : nidhi_biet