PHP Spreadsheet_Excel_Writer setFgColor()函数用法

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

void Format::setFgColor( $color )

参数：该函数接受单个参数颜色通过将颜色值指定为8至63之间的颜色代码, 将颜色值作为字符串(例如"红色", "绿色")和另一种方法。
返回值：成功时返回TRUE, 失败时返回PEAR_ERROR。
【PHP Spreadsheet_Excel_Writer setFgColor()函数用法】示例1：

< ?phprequire_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：

< ?phprequire_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(); ?>

输出如下：