Constants

UNDERLINE_NONE

UNDERLINE_NONE = 'none'

UNDERLINE_DOUBLE

UNDERLINE_DOUBLE = 'double'

UNDERLINE_DOUBLEACCOUNTING

UNDERLINE_DOUBLEACCOUNTING = 'doubleAccounting'

UNDERLINE_SINGLE

UNDERLINE_SINGLE = 'single'

UNDERLINE_SINGLEACCOUNTING

UNDERLINE_SINGLEACCOUNTING = 'singleAccounting'

Properties

$_isSupervisor

$_isSupervisor : bool

Supervisor?

Type

bool

$_parent

$_parent : \PHPExcel_Style

Parent. Only used for supervisor

Type

PHPExcel_Style

$_name

$_name : string

Font Name

Type

string

$_size

$_size : float

Font Size

Type

float

$_bold

$_bold : bool

Bold

Type

bool

$_italic

$_italic : bool

Italic

Type

bool

$_superScript

$_superScript : bool

Superscript

Type

bool

$_subScript

$_subScript : bool

Subscript

Type

bool

$_underline

$_underline : string

Underline

Type

string

$_strikethrough

$_strikethrough : bool

Strikethrough

Type

bool

Methods

__construct()

__construct(bool  $isSupervisor = FALSE, bool  $isConditional = FALSE) : mixed

Create a new PHPExcel_Style_Font

Parameters

bool $isSupervisor

Flag indicating if this is a supervisor or not Leave this value at default unless you understand exactly what its ramifications are

bool $isConditional

Flag indicating if this is a conditional style or not Leave this value at default unless you understand exactly what its ramifications are

Returns

mixed —

bindParent()

bindParent(\PHPExcel  $parent, mixed  $parentPropertyName = NULL) : \PHPExcel_Style_Supervisor

Bind parent. Only used for supervisor

Parameters

\PHPExcel $parent
mixed $parentPropertyName

Returns

\PHPExcel_Style_Supervisor —

getIsSupervisor()

getIsSupervisor() : bool

Is this a supervisor or a cell style component?

Returns

bool —

getActiveSheet()

getActiveSheet() : \PHPExcel_Worksheet

Get the currently active sheet. Only used for supervisor

Returns

\PHPExcel_Worksheet —

getSelectedCells()

getSelectedCells() : string

Get the currently active cell coordinate in currently active sheet.

Only used for supervisor

Returns

string —

E.g. 'A1'

getActiveCell()

getActiveCell() : string

Get the currently active cell coordinate in currently active sheet.

Only used for supervisor

Returns

string —

E.g. 'A1'

__clone()

__clone() : mixed

Implement PHP __clone to create a deep clone, not just a shallow copy.

Returns

mixed —

getSharedComponent()

getSharedComponent() : \PHPExcel_Style_Font

Get the shared style component for the currently active cell in currently active sheet.

Only used for style supervisor

Returns

\PHPExcel_Style_Font —

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents

Parameters

array $array

Returns

array —

applyFromArray()

applyFromArray(array  $pStyles = null) : \PHPExcel_Style_Font

Apply styles from array

$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->applyFromArray( array( 'name' => 'Arial', 'bold' => TRUE, 'italic' => FALSE, 'underline' => PHPExcel_Style_Font::UNDERLINE_DOUBLE, 'strike' => FALSE, 'color' => array( 'rgb' => '808080' ) ) );

Parameters

array $pStyles

Array containing style information

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Font —

getName()

getName() : string

Get Name

Returns

string —

setName()

setName(string  $pValue = 'Calibri') : \PHPExcel_Style_Font

Set Name

Parameters

string $pValue

Returns

\PHPExcel_Style_Font —

getSize()

getSize() : float

Get Size

Returns

float —

setSize()

setSize(float  $pValue = 10) : \PHPExcel_Style_Font

Set Size

Parameters

float $pValue

Returns

\PHPExcel_Style_Font —

getBold()

getBold() : bool

Get Bold

Returns

bool —

setBold()

setBold(bool  $pValue = false) : \PHPExcel_Style_Font

Set Bold

Parameters

bool $pValue

Returns

\PHPExcel_Style_Font —

getItalic()

getItalic() : bool

Get Italic

Returns

bool —

setItalic()

setItalic(bool  $pValue = false) : \PHPExcel_Style_Font

Set Italic

Parameters

bool $pValue

Returns

\PHPExcel_Style_Font —

getSuperScript()

getSuperScript() : bool

Get SuperScript

Returns

bool —

setSuperScript()

setSuperScript(bool  $pValue = false) : \PHPExcel_Style_Font

Set SuperScript

Parameters

bool $pValue

Returns

\PHPExcel_Style_Font —

getSubScript()

getSubScript() : bool

Get SubScript

Returns

bool —

setSubScript()

setSubScript(bool  $pValue = false) : \PHPExcel_Style_Font

Set SubScript

Parameters

bool $pValue

Returns

\PHPExcel_Style_Font —

getUnderline()

getUnderline() : string

Get Underline

Returns

string —

setUnderline()

setUnderline(string|bool  $pValue = self::UNDERLINE_NONE) : \PHPExcel_Style_Font

Set Underline

Parameters

string|bool $pValue

PHPExcel_Style_Font underline type If a boolean is passed, then TRUE equates to UNDERLINE_SINGLE, false equates to UNDERLINE_NONE

Returns

\PHPExcel_Style_Font —

getStrikethrough()

getStrikethrough() : bool

Get Strikethrough

Returns

bool —

setStrikethrough()

setStrikethrough(bool  $pValue = false) : \PHPExcel_Style_Font

Set Strikethrough

Parameters

bool $pValue

Returns

\PHPExcel_Style_Font —

getColor()

getColor() : \PHPExcel_Style_Color

Get Color

Returns

\PHPExcel_Style_Color —

setColor()

setColor(\PHPExcel_Style_Color  $pValue = null) : \PHPExcel_Style_Font

Set Color

Parameters

\PHPExcel_Style_Color $pValue

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Font —

getHashCode()

getHashCode() : string

Get hash code

Returns

string —

Hash code