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();
?>
输出如下:
文章图片
示例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();
?>
输出如下:
文章图片
参考: https://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.setfgcolor.php
推荐阅读
- 递归与迭代之间有什么区别()
- u盘里东西删不掉,教您u盘文件删不了怎样办
- 技嘉 bios设置,教您技嘉主板bios如何设置U盘打开
- amd bios设置,教您amd主板bios怎样设置u盘打开
- rog,教您华硕rog怎样设置U盘打开
- 扩容u盘修好,教您怎样修好扩容U盘
- u盘打开ghost,教您如何运用u盘打开盘自已手工ghost备份系统
- 英特尔u盘打开,教您英特尔主板怎样在bios中设置u盘打开
- 安装系统 笔记本重装系统u盘,教您笔记本怎样运用u盘重装win7系统