PHPExcel classes
Back to top  

PHPExcel_Writer_Excel5_Xf

category PHPExcel
package PHPExcel_Writer_Excel5
copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

 Methods

Constructor

__construct(\PHPExcel_Style $style) 
access public

Parameters

$style

\PHPExcel_Style

The XF format

Sets the cell's background color

setBgColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Sets the cell's bottom border color

setBottomColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Sets the cell's diagonal border color

setDiagColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Sets the cell's foreground color

setFgColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Set the font index.

setFontIndex(int $value) 

Parameters

$value

int

Font index, note that value 4 does not exist

Is this a style XF ?

setIsStyleXf(boolean $value) 

Parameters

$value

boolean

Sets the cell's left border color

setLeftColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Sets the index to the number format record It can be date, time, currency, etc.

setNumberFormatIndex(integer $numberFormatIndex) 

..

access public

Parameters

$numberFormatIndex

integer

Index to format record

Sets the cell's right border color

setRightColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Sets the cell's top border color

setTopColor(int $colorIndex) 
access public

Parameters

$colorIndex

int

Color index

Generate an Excel BIFF XF record (style or cell).

writeXf() : string

Returns

stringThe XF record

 Properties

 

$_bg_color : integer
 

$_bottom_color : integer
 

$_fg_color : integer
 

$_left_color : integer
 

$_numberFormatIndex : integer
 

$_right_color : integer
 

$_text_justlast : integer
 

$_top_color : integer