class Xf (View source)

Methods

__construct(Style $style)

Constructor.

string
writeXf()

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

setIsStyleXf(bool $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(int $numberFormatIndex)

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

setFontIndex(int $value)

Set the font index.

Details

__construct(Style $style)

Constructor.

Parameters

Style $style The XF format

string writeXf()

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

Return Value

string The XF record

setIsStyleXf(bool $value)

Is this a style XF ?

Parameters

bool $value

setBottomColor(int $colorIndex)

Sets the cell's bottom border color.

Parameters

int $colorIndex Color index

setTopColor(int $colorIndex)

Sets the cell's top border color.

Parameters

int $colorIndex Color index

setLeftColor(int $colorIndex)

Sets the cell's left border color.

Parameters

int $colorIndex Color index

setRightColor(int $colorIndex)

Sets the cell's right border color.

Parameters

int $colorIndex Color index

setDiagColor(int $colorIndex)

Sets the cell's diagonal border color.

Parameters

int $colorIndex Color index

setFgColor(int $colorIndex)

Sets the cell's foreground color.

Parameters

int $colorIndex Color index

setBgColor(int $colorIndex)

Sets the cell's background color.

Parameters

int $colorIndex Color index

setNumberFormatIndex(int $numberFormatIndex)

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

..

Parameters

int $numberFormatIndex Index to format record

setFontIndex(int $value)

Set the font index.

Parameters

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