Properties

$_numberFormatIndex

$_numberFormatIndex : int

An index (2 bytes) to a FORMAT record (number format).

Type

int

$_text_justlast

$_text_justlast : int

1 bit, apparently not used.

Type

int

$_fg_color

$_fg_color : int

The cell's foreground color.

Type

int

$_bg_color

$_bg_color : int

The cell's background color.

Type

int

$_bottom_color

$_bottom_color : int

Color of the bottom border of the cell.

Type

int

$_top_color

$_top_color : int

Color of the top border of the cell.

Type

int

$_left_color

$_left_color : int

Color of the left border of the cell.

Type

int

$_right_color

$_right_color : int

Color of the right border of the cell.

Type

int

$_isStyleXf

$_isStyleXf : bool

Style XF or a cell XF ?

Type

bool

$_fontIndex

$_fontIndex : int

Index to the FONT record. Index 4 does not exist

Type

int

$_mapBorderStyle

$_mapBorderStyle

Map of BIFF2-BIFF8 codes for border styles

$_mapFillType

$_mapFillType

Map of BIFF2-BIFF8 codes for fill types

$_mapHAlign

$_mapHAlign

Map of BIFF2-BIFF8 codes for horizontal alignment

$_mapVAlign

$_mapVAlign

Map of BIFF2-BIFF8 codes for vertical alignment

Methods

__construct()

__construct(\PHPExcel_Style  $style = null) : mixed

Constructor

Parameters

\PHPExcel_Style $style

Returns

mixed —

writeXf()

writeXf() : string

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

Returns

string —

The XF record

setIsStyleXf()

setIsStyleXf(bool  $value) : mixed

Is this a style XF ?

Parameters

bool $value

Returns

mixed —

setBottomColor()

setBottomColor(int  $colorIndex) : mixed

Sets the cell's bottom border color

Parameters

int $colorIndex

Color index

Returns

mixed —

setTopColor()

setTopColor(int  $colorIndex) : mixed

Sets the cell's top border color

Parameters

int $colorIndex

Color index

Returns

mixed —

setLeftColor()

setLeftColor(int  $colorIndex) : mixed

Sets the cell's left border color

Parameters

int $colorIndex

Color index

Returns

mixed —

setRightColor()

setRightColor(int  $colorIndex) : mixed

Sets the cell's right border color

Parameters

int $colorIndex

Color index

Returns

mixed —

setDiagColor()

setDiagColor(int  $colorIndex) : mixed

Sets the cell's diagonal border color

Parameters

int $colorIndex

Color index

Returns

mixed —

setFgColor()

setFgColor(int  $colorIndex) : mixed

Sets the cell's foreground color

Parameters

int $colorIndex

Color index

Returns

mixed —

setBgColor()

setBgColor(int  $colorIndex) : mixed

Sets the cell's background color

Parameters

int $colorIndex

Color index

Returns

mixed —

setNumberFormatIndex()

setNumberFormatIndex(int  $numberFormatIndex) : mixed

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

..

Parameters

int $numberFormatIndex

Index to format record

Returns

mixed —

setFontIndex()

setFontIndex(int  $value) : mixed

Set the font index.

Parameters

int $value

Font index, note that value 4 does not exist

Returns

mixed —

_mapBorderStyle()

_mapBorderStyle(string  $borderStyle) : int

Map border style

Parameters

string $borderStyle

Returns

int —

_mapFillType()

_mapFillType(string  $fillType) : int

Map fill type

Parameters

string $fillType

Returns

int —

_mapHAlign()

_mapHAlign(string  $hAlign) : int

Map to BIFF2-BIFF8 codes for horizontal alignment

Parameters

string $hAlign

Returns

int —

_mapVAlign()

_mapVAlign(string  $vAlign) : int

Map to BIFF2-BIFF8 codes for vertical alignment

Parameters

string $vAlign

Returns

int —

_mapTextRotation()

_mapTextRotation(int  $textRotation) : int

Map to BIFF8 codes for text rotation angle

Parameters

int $textRotation

Returns

int —

_mapLocked()

_mapLocked(mixed  $locked) : int

Map locked

Parameters

mixed $locked

Returns

int —

_mapHidden()

_mapHidden(mixed  $hidden) : int

Map hidden

Parameters

mixed $hidden

Returns

int —