class PHPExcel_Writer_Excel5_Xf

Methods

__construct(PHPExcel_Style $style = null)

Constructor

string
writeXf()

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

setIsStyleXf(boolean $value)

Is this a style XF ?

setBottomColor(int $colorIndex)

Sets the cell's bottom border color

setTopColor(int $colorIndex)

Sets the cell's top border color

setLeftColor(int $colorIndex)

Sets the cell's left border color

setRightColor(int $colorIndex)

Sets the cell's right border color

setDiagColor(int $colorIndex)

Sets the cell's diagonal border color

setFgColor(int $colorIndex)

Sets the cell's foreground color

setBgColor(int $colorIndex)

Sets the cell's background color

setNumberFormatIndex(integer $numberFormatIndex)

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

setFontIndex(int $value)

Set the font index.

Details

at line 141
__construct(PHPExcel_Style $style = null)

Constructor

Parameters

PHPExcel_Style $style The XF format

at line 170
string writeXf()

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

Return Value

string The XF record

at line 271
setIsStyleXf(boolean $value)

Is this a style XF ?

Parameters

boolean $value

at line 282
setBottomColor(int $colorIndex)

Sets the cell's bottom border color

Parameters

int $colorIndex Color index

at line 293
setTopColor(int $colorIndex)

Sets the cell's top border color

Parameters

int $colorIndex Color index

at line 304
setLeftColor(int $colorIndex)

Sets the cell's left border color

Parameters

int $colorIndex Color index

at line 315
setRightColor(int $colorIndex)

Sets the cell's right border color

Parameters

int $colorIndex Color index

at line 326
setDiagColor(int $colorIndex)

Sets the cell's diagonal border color

Parameters

int $colorIndex Color index

at line 338
setFgColor(int $colorIndex)

Sets the cell's foreground color

Parameters

int $colorIndex Color index

at line 349
setBgColor(int $colorIndex)

Sets the cell's background color

Parameters

int $colorIndex Color index

at line 361
setNumberFormatIndex(integer $numberFormatIndex)

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

..

Parameters

integer $numberFormatIndex Index to format record

at line 371
setFontIndex(int $value)

Set the font index.

Parameters

int $value Font index, note that value 4 does not exist