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

$startcolorIndex

$startcolorIndex : int

Type

int

$endcolorIndex

$endcolorIndex : int

Type

int

$isSupervisor

$isSupervisor : bool

Supervisor?

Type

bool

$parent

$parent : \PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style

Parent. Only used for supervisor.

Type

Style

$parentPropertyName

$parentPropertyName : null|string

Parent property name.

Type

null|string

$fillType

$fillType : string

Fill type.

Type

string

$rotation

$rotation : float

Rotation.

Type

float

$startColor

$startColor : \PhpOffice\PhpSpreadsheet\Style\Color

Start color.

Type

Color

$endColor

$endColor : \PhpOffice\PhpSpreadsheet\Style\Color

End color.

Type

Color

Methods

__construct()

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

Create a new 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(\PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style  $parent, null|string  $parentPropertyName = null) : $this

Bind parent. Only used for supervisor.

Parameters

\PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style $parent
null|string $parentPropertyName

Returns

$this —

getIsSupervisor()

getIsSupervisor() : bool

Is this a supervisor or a cell style component?

Returns

bool —

getActiveSheet()

getActiveSheet() : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet

Get the currently active sheet. Only used for supervisor.

Returns

\PhpOffice\PhpSpreadsheet\Worksheet\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 —

exportArray()

exportArray() : array

Export style as array.

Available to anything which extends this class: Alignment, Border, Borders, Color, Fill, Font, NumberFormat, Protection, and Style.

Returns

array —

getSharedComponent()

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

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

Only used for style supervisor.

Returns

\PhpOffice\PhpSpreadsheet\Style\Fill —

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents.

Parameters

array $array

Returns

array —

applyFromArray()

applyFromArray(array  $pStyles) : $this

Apply styles from array.

$spreadsheet->getActiveSheet()->getStyle('B2')->getFill()->applyFromArray( [ 'fillType' => Fill::FILL_GRADIENT_LINEAR, 'rotation' => 0, 'startColor' => [ 'rgb' => '000000' ], 'endColor' => [ 'argb' => 'FFFFFFFF' ] ] );

Parameters

array $pStyles

Array containing style information

Returns

$this —

getFillType()

getFillType() : string

Get Fill Type.

Returns

string —

setFillType()

setFillType(string  $pValue) : $this

Set Fill Type.

Parameters

string $pValue

Fill type, see self::FILL_*

Returns

$this —

getRotation()

getRotation() : float

Get Rotation.

Returns

float —

setRotation()

setRotation(float  $pValue) : $this

Set Rotation.

Parameters

float $pValue

Returns

$this —

getStartColor()

getStartColor() : \PhpOffice\PhpSpreadsheet\Style\Color

Get Start Color.

Returns

\PhpOffice\PhpSpreadsheet\Style\Color —

setStartColor()

setStartColor(\PhpOffice\PhpSpreadsheet\Style\Color  $pValue) : $this

Set Start Color.

Parameters

\PhpOffice\PhpSpreadsheet\Style\Color $pValue

Returns

$this —

getEndColor()

getEndColor() : \PhpOffice\PhpSpreadsheet\Style\Color

Get End Color.

Returns

\PhpOffice\PhpSpreadsheet\Style\Color —

setEndColor()

setEndColor(\PhpOffice\PhpSpreadsheet\Style\Color  $pValue) : $this

Set End Color.

Parameters

\PhpOffice\PhpSpreadsheet\Style\Color $pValue

Returns

$this —

getHashCode()

getHashCode() : string

Get hash code.

Returns

string —

Hash code

exportArray1()

exportArray1() : array

Abstract method to be implemented in anything which extends this class.

This method invokes exportArray2 with the names and values of all properties to be included in output array, returning that array to exportArray, then to caller.

Returns

array —

exportArray2()

exportArray2(array  $exportedArray, string  $index, mixed  $objOrValue) : void

Populate array from exportArray1.

This method is available to anything which extends this class. The parameter index is the key to be added to the array. The parameter objOrValue is either a primitive type, which is the value added to the array, or a Style object to be recursively added via exportArray.

Parameters

array $exportedArray
string $index
mixed $objOrValue