Properties

$_numberFormatIndex

$_numberFormatIndex : integer

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

Type

integer

$_text_justlast

$_text_justlast : integer

1 bit, apparently not used.

Type

integer

$_fg_color

$_fg_color : integer

The cell's foreground color.

Type

integer

$_bg_color

$_bg_color : integer

The cell's background color.

Type

integer

$_bottom_color

$_bottom_color : integer

Color of the bottom border of the cell.

Type

integer

$_top_color

$_top_color : integer

Color of the top border of the cell.

Type

integer

$_left_color

$_left_color : integer

Color of the left border of the cell.

Type

integer

$_right_color

$_right_color : integer

Color of the right border of the cell.

Type

integer

$_isStyleXf

$_isStyleXf : boolean

Style XF or a cell XF ?

Type

boolean

$_fontIndex

$_fontIndex : integer

Index to the FONT record. Index 4 does not exist

Type

integer

$_mapBorderStyle

$_mapBorderStyle : 

Map of BIFF2-BIFF8 codes for border styles

Type

$_mapFillType

$_mapFillType : 

Map of BIFF2-BIFF8 codes for fill types

Type

$_mapHAlign

$_mapHAlign : 

Map of BIFF2-BIFF8 codes for horizontal alignment

Type

$_mapVAlign

$_mapVAlign : 

Map of BIFF2-BIFF8 codes for vertical alignment

Type

Methods

__construct()

__construct(\PHPExcel_Style  $style = null) 

Constructor

Parameters

\PHPExcel_Style $style

writeXf()

writeXf() : string

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

Returns

string —

The XF record

setIsStyleXf()

setIsStyleXf(boolean  $value) 

Is this a style XF ?

Parameters

boolean $value

setBottomColor()

setBottomColor(integer  $colorIndex) 

Sets the cell's bottom border color

Parameters

integer $colorIndex

Color index

setTopColor()

setTopColor(integer  $colorIndex) 

Sets the cell's top border color

Parameters

integer $colorIndex

Color index

setLeftColor()

setLeftColor(integer  $colorIndex) 

Sets the cell's left border color

Parameters

integer $colorIndex

Color index

setRightColor()

setRightColor(integer  $colorIndex) 

Sets the cell's right border color

Parameters

integer $colorIndex

Color index

setDiagColor()

setDiagColor(integer  $colorIndex) 

Sets the cell's diagonal border color

Parameters

integer $colorIndex

Color index

setFgColor()

setFgColor(integer  $colorIndex) 

Sets the cell's foreground color

Parameters

integer $colorIndex

Color index

setBgColor()

setBgColor(integer  $colorIndex) 

Sets the cell's background color

Parameters

integer $colorIndex

Color index

setNumberFormatIndex()

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

setFontIndex()

setFontIndex(integer  $value) 

Set the font index.

Parameters

integer $value

Font index, note that value 4 does not exist

_mapBorderStyle()

_mapBorderStyle(string  $borderStyle) : integer

Map border style

Parameters

string $borderStyle

Returns

integer

_mapFillType()

_mapFillType(string  $fillType) : integer

Map fill type

Parameters

string $fillType

Returns

integer

_mapHAlign()

_mapHAlign(string  $hAlign) : integer

Map to BIFF2-BIFF8 codes for horizontal alignment

Parameters

string $hAlign

Returns

integer

_mapVAlign()

_mapVAlign(string  $vAlign) : integer

Map to BIFF2-BIFF8 codes for vertical alignment

Parameters

string $vAlign

Returns

integer

_mapTextRotation()

_mapTextRotation(integer  $textRotation) : integer

Map to BIFF8 codes for text rotation angle

Parameters

integer $textRotation

Returns

integer

_mapLocked()

_mapLocked(  $locked) : integer

Map locked

Parameters

$locked

Returns

integer

_mapHidden()

_mapHidden(  $hidden) : integer

Map hidden

Parameters

$hidden

Returns

integer