PHP Spreadsheet_Excel_Writer setFgColor()函数用法

2021年4月15日18:07:23 发表评论 1,135 次浏览

setFgColor()函数是PHP中的内置函数| Spreadsheet_Excel_Writer, 用于设置电子表格单元格的前景色。为了使用此功能, 请使用setPattern函数。在此, "前景"是指单元格背景的顶层。

语法如下：

void Format::setFgColor( $color )

参数：该函数接受单个参数颜色通过将颜色值指定为8至63之间的颜色代码, 将颜色值作为字符串(例如"红色", "绿色")和另一种方法。

返回值：成功时返回TRUE, 失败时返回PEAR_ERROR。

示例1：

<?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, "lsbin" , $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();
?>

输出如下：

PHP Spreadsheet_Excel_Writer setFgColor()函数用法

示例2：

<?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, "lsbin" , $format_setFgColor );
$worksheet ->write(2, 1, "https://www.lsbin.org/" , $format_setFgColor );
$workbook ->send( 'test.xls' );
  
$workbook ->close();
?>

输出如下：