Gitee
\
OSS
Core
Http
Model
Result
Qcloud_cos
qcloudcos
Qiniu
Http
Processing
Storage
Testify
We7
Table
Account
Article
Core
Mc
Modules
Phoneapp
Qrcode
Rule
Site
Stat
Store
System
Uni
Userapi
Users
Wechat
Wxapp

\PHPExcel_Writer_Excel5_Xf

PHPExcel_Writer_Excel5_Xf

Summary

Methods
Properties
Constants
__construct()
writeXf()
setIsStyleXf()
setBottomColor()
setTopColor()
setLeftColor()
setRightColor()
setDiagColor()
setFgColor()
setBgColor()
setNumberFormatIndex()
setFontIndex()
$_numberFormatIndex
$_text_justlast
$_fg_color
$_bg_color
$_bottom_color
$_top_color
$_left_color
$_right_color
No constants found
No protected methods found
No protected properties found
N/A
_mapBorderStyle()
_mapFillType()
_mapHAlign()
_mapVAlign()
_mapTextRotation()
_mapLocked()
_mapHidden()
$_isStyleXf
$_fontIndex
$_mapBorderStyle
$_mapFillType
$_mapHAlign
$_mapVAlign
N/A

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