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

$colorIndex

$colorIndex : integer

Type

integer

$isSupervisor

$isSupervisor : boolean

Supervisor?

Type

boolean

$parentPropertyName

$parentPropertyName : null|string

Parent property name.

Type

null|string

$name

$name : string

Font Name.

Type

string

$size

$size : float

Font Size.

Type

float

$bold

$bold : boolean

Bold.

Type

boolean

$italic

$italic : boolean

Italic.

Type

boolean

$superscript

$superscript : boolean

Superscript.

Type

boolean

$subscript

$subscript : boolean

Subscript.

Type

boolean

$underline

$underline : string

Underline.

Type

string

$strikethrough

$strikethrough : boolean

Strikethrough.

Type

boolean

Methods

__construct()

__construct(boolean  $isSupervisor = false, boolean  $isConditional = false) 

Create a new Font.

Parameters

boolean $isSupervisor

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

boolean $isConditional

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

getIsSupervisor()

getIsSupervisor() : boolean

Is this a supervisor or a cell style component?

Returns

boolean

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() 

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

getSharedComponent()

getSharedComponent() : \PhpOffice\PhpSpreadsheet\Style\Font

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

Only used for style supervisor.

Returns

\PhpOffice\PhpSpreadsheet\Style\Font

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents.

Parameters

array $array

Returns

array

applyFromArray()

applyFromArray(array  $pStyles) : \PhpOffice\PhpSpreadsheet\Style\Font

Apply styles from array.

$spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->applyFromArray( [ 'name' => 'Arial', 'bold' => TRUE, 'italic' => FALSE, 'underline' => \PhpOffice\PhpSpreadsheet\Style\Font::UNDERLINE_DOUBLE, 'strikethrough' => FALSE, 'color' => [ 'rgb' => '808080' ] ] );

Parameters

array $pStyles

Array containing style information

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

\PhpOffice\PhpSpreadsheet\Style\Font

getName()

getName() : string

Get Name.

Returns

string

getSize()

getSize() : float

Get Size.

Returns

float

getBold()

getBold() : boolean

Get Bold.

Returns

boolean

getItalic()

getItalic() : boolean

Get Italic.

Returns

boolean

getSuperscript()

getSuperscript() : boolean

Get Superscript.

Returns

boolean

getSubscript()

getSubscript() : boolean

Get Subscript.

Returns

boolean

getUnderline()

getUnderline() : string

Get Underline.

Returns

string

setUnderline()

setUnderline(boolean|string  $pValue) : \PhpOffice\PhpSpreadsheet\Style\Font

Set Underline.

Parameters

boolean|string $pValue

\PhpOffice\PhpSpreadsheet\Style\Font underline type If a boolean is passed, then TRUE equates to UNDERLINE_SINGLE, false equates to UNDERLINE_NONE

Returns

\PhpOffice\PhpSpreadsheet\Style\Font

getStrikethrough()

getStrikethrough() : boolean

Get Strikethrough.

Returns

boolean

setStrikethrough()

setStrikethrough(boolean  $pValue) : \PhpOffice\PhpSpreadsheet\Style\Font

Set Strikethrough.

Parameters

boolean $pValue

Returns

\PhpOffice\PhpSpreadsheet\Style\Font

getHashCode()

getHashCode() : string

Get hash code.

Returns

string —

Hash code