Properties

$_isSupervisor

$_isSupervisor : bool

Supervisor?

Type

bool

$_parent

$_parent : \PHPExcel_Style

Parent. Only used for supervisor

Type

PHPExcel_Style

$_index

$_index : int

Index of style in collection. Only used for real style.

Type

int

$_quotePrefix

$_quotePrefix : bool

Use Quote Prefix when displaying in cell editor. Only used for real style.

Type

bool

Methods

__construct()

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

Create a new PHPExcel_Style

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

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

Only used for style supervisor

Returns

\PHPExcel_Style —

getParent()

getParent() : \PHPExcel

Get parent. Only used for style supervisor

Returns

\PHPExcel —

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents

Parameters

array $array

Returns

array —

applyFromArray()

applyFromArray(array  $pStyles = null, bool  $pAdvanced = true) : \PHPExcel_Style

Apply styles from array

$objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray( array( 'font' => array( 'name' => 'Arial', 'bold' => true, 'italic' => false, 'underline' => PHPExcel_Style_Font::UNDERLINE_DOUBLE, 'strike' => false, 'color' => array( 'rgb' => '808080' ) ), 'borders' => array( 'bottom' => array( 'style' => PHPExcel_Style_Border::BORDER_DASHDOT, 'color' => array( 'rgb' => '808080' ) ), 'top' => array( 'style' => PHPExcel_Style_Border::BORDER_DASHDOT, 'color' => array( 'rgb' => '808080' ) ) ), 'quotePrefix' => true ) );

Parameters

array $pStyles

Array containing style information

bool $pAdvanced

Advanced mode for setting borders.

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style —

getFill()

getFill() : \PHPExcel_Style_Fill

Get Fill

Returns

\PHPExcel_Style_Fill —

getFont()

getFont() : \PHPExcel_Style_Font

Get Font

Returns

\PHPExcel_Style_Font —

setFont()

setFont(\PHPExcel_Style_Font  $font) : \PHPExcel_Style

Set font

Parameters

\PHPExcel_Style_Font $font

Returns

\PHPExcel_Style —

getBorders()

getBorders() : \PHPExcel_Style_Borders

Get Borders

Returns

\PHPExcel_Style_Borders —

getAlignment()

getAlignment() : \PHPExcel_Style_Alignment

Get Alignment

Returns

\PHPExcel_Style_Alignment —

getNumberFormat()

getNumberFormat() : \PHPExcel_Style_NumberFormat

Get Number Format

Returns

\PHPExcel_Style_NumberFormat —

getConditionalStyles()

getConditionalStyles() : \PHPExcel_Style_Conditional[]

Get Conditional Styles. Only used on supervisor.

Returns

\PHPExcel_Style_Conditional[] —

setConditionalStyles()

setConditionalStyles(\PHPExcel_Style_Conditional[]  $pValue = null) : \PHPExcel_Style

Set Conditional Styles. Only used on supervisor.

Parameters

\PHPExcel_Style_Conditional[] $pValue

Array of condtional styles

Returns

\PHPExcel_Style —

getProtection()

getProtection() : \PHPExcel_Style_Protection

Get Protection

Returns

\PHPExcel_Style_Protection —

getQuotePrefix()

getQuotePrefix() : bool

Get quote prefix

Returns

bool —

setQuotePrefix()

setQuotePrefix(bool  $pValue) : mixed

Set quote prefix

Parameters

bool $pValue

Returns

mixed —

getHashCode()

getHashCode() : string

Get hash code

Returns

string —

Hash code

getIndex()

getIndex() : int

Get own index in style collection

Returns

int —

setIndex()

setIndex(int  $pValue) : mixed

Set own index in style collection

Parameters

int $pValue

Returns

mixed —