Constants

FILL_NONE

FILL_NONE = 'none'

FILL_SOLID

FILL_SOLID = 'solid'

FILL_GRADIENT_LINEAR

FILL_GRADIENT_LINEAR = 'linear'

FILL_GRADIENT_PATH

FILL_GRADIENT_PATH = 'path'

FILL_PATTERN_DARKDOWN

FILL_PATTERN_DARKDOWN = 'darkDown'

FILL_PATTERN_DARKGRAY

FILL_PATTERN_DARKGRAY = 'darkGray'

FILL_PATTERN_DARKGRID

FILL_PATTERN_DARKGRID = 'darkGrid'

FILL_PATTERN_DARKHORIZONTAL

FILL_PATTERN_DARKHORIZONTAL = 'darkHorizontal'

FILL_PATTERN_DARKTRELLIS

FILL_PATTERN_DARKTRELLIS = 'darkTrellis'

FILL_PATTERN_DARKUP

FILL_PATTERN_DARKUP = 'darkUp'

FILL_PATTERN_DARKVERTICAL

FILL_PATTERN_DARKVERTICAL = 'darkVertical'

FILL_PATTERN_GRAY0625

FILL_PATTERN_GRAY0625 = 'gray0625'

FILL_PATTERN_GRAY125

FILL_PATTERN_GRAY125 = 'gray125'

FILL_PATTERN_LIGHTDOWN

FILL_PATTERN_LIGHTDOWN = 'lightDown'

FILL_PATTERN_LIGHTGRAY

FILL_PATTERN_LIGHTGRAY = 'lightGray'

FILL_PATTERN_LIGHTGRID

FILL_PATTERN_LIGHTGRID = 'lightGrid'

FILL_PATTERN_LIGHTHORIZONTAL

FILL_PATTERN_LIGHTHORIZONTAL = 'lightHorizontal'

FILL_PATTERN_LIGHTTRELLIS

FILL_PATTERN_LIGHTTRELLIS = 'lightTrellis'

FILL_PATTERN_LIGHTUP

FILL_PATTERN_LIGHTUP = 'lightUp'

FILL_PATTERN_LIGHTVERTICAL

FILL_PATTERN_LIGHTVERTICAL = 'lightVertical'

FILL_PATTERN_MEDIUMGRAY

FILL_PATTERN_MEDIUMGRAY = 'mediumGray'

Properties

$_isSupervisor

$_isSupervisor : bool

Supervisor?

Type

bool

$_parent

$_parent : \PHPExcel_Style

Parent. Only used for supervisor

Type

PHPExcel_Style

$_fillType

$_fillType : string

Fill type

Type

string

$_rotation

$_rotation : float

Rotation

Type

float

Methods

__construct()

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

Create a new PHPExcel_Style_Fill

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_Fill

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

Only used for style supervisor

Returns

\PHPExcel_Style_Fill —

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents

Parameters

array $array

Returns

array —

applyFromArray()

applyFromArray(array  $pStyles = null) : \PHPExcel_Style_Fill

Apply styles from array

$objPHPExcel->getActiveSheet()->getStyle('B2')->getFill()->applyFromArray( array( 'type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR, 'rotation' => 0, 'startcolor' => array( 'rgb' => '000000' ), 'endcolor' => array( 'argb' => 'FFFFFFFF' ) ) );

Parameters

array $pStyles

Array containing style information

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Fill —

getFillType()

getFillType() : string

Get Fill Type

Returns

string —

setFillType()

setFillType(string  $pValue = PHPExcel_Style_Fill::FILL_NONE) : \PHPExcel_Style_Fill

Set Fill Type

Parameters

string $pValue

PHPExcel_Style_Fill fill type

Returns

\PHPExcel_Style_Fill —

getRotation()

getRotation() : float

Get Rotation

Returns

float —

setRotation()

setRotation(float  $pValue) : \PHPExcel_Style_Fill

Set Rotation

Parameters

float $pValue

Returns

\PHPExcel_Style_Fill —

getStartColor()

getStartColor() : \PHPExcel_Style_Color

Get Start Color

Returns

\PHPExcel_Style_Color —

setStartColor()

setStartColor(\PHPExcel_Style_Color  $pValue = null) : \PHPExcel_Style_Fill

Set Start Color

Parameters

\PHPExcel_Style_Color $pValue

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Fill —

getEndColor()

getEndColor() : \PHPExcel_Style_Color

Get End Color

Returns

\PHPExcel_Style_Color —

setEndColor()

setEndColor(\PHPExcel_Style_Color  $pValue = null) : \PHPExcel_Style_Fill

Set End Color

Parameters

\PHPExcel_Style_Color $pValue

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Fill —

getHashCode()

getHashCode() : string

Get hash code

Returns

string —

Hash code