Constants

BORDER_NONE

BORDER_NONE = 'none'

BORDER_DASHDOT

BORDER_DASHDOT = 'dashDot'

BORDER_DASHDOTDOT

BORDER_DASHDOTDOT = 'dashDotDot'

BORDER_DASHED

BORDER_DASHED = 'dashed'

BORDER_DOTTED

BORDER_DOTTED = 'dotted'

BORDER_DOUBLE

BORDER_DOUBLE = 'double'

BORDER_HAIR

BORDER_HAIR = 'hair'

BORDER_MEDIUM

BORDER_MEDIUM = 'medium'

BORDER_MEDIUMDASHDOT

BORDER_MEDIUMDASHDOT = 'mediumDashDot'

BORDER_MEDIUMDASHDOTDOT

BORDER_MEDIUMDASHDOTDOT = 'mediumDashDotDot'

BORDER_MEDIUMDASHED

BORDER_MEDIUMDASHED = 'mediumDashed'

BORDER_SLANTDASHDOT

BORDER_SLANTDASHDOT = 'slantDashDot'

BORDER_THICK

BORDER_THICK = 'thick'

BORDER_THIN

BORDER_THIN = 'thin'

Properties

$_isSupervisor

$_isSupervisor : boolean

Supervisor?

Type

boolean

$_parent

$_parent : \PHPExcel_Style

Parent. Only used for supervisor

Type

\PHPExcel_Style

$_borderStyle

$_borderStyle : string

Border style

Type

string

$_parentPropertyName

$_parentPropertyName : string

Parent property name

Type

string

Methods

__construct()

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

Create a new PHPExcel_Style_Border

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

bindParent()

bindParent(\PHPExcel_Style_Borders  $parent, string  $parentPropertyName = NULL) : \PHPExcel_Style_Border

Bind parent. Only used for supervisor

Parameters

\PHPExcel_Style_Borders $parent
string $parentPropertyName

Returns

\PHPExcel_Style_Border

getIsSupervisor()

getIsSupervisor() : boolean

Is this a supervisor or a cell style component?

Returns

boolean

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

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

getSharedComponent()

getSharedComponent() : \PHPExcel_Style_Border

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

Only used for style supervisor

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Border

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents

Parameters

array $array

Returns

array

applyFromArray()

applyFromArray(array  $pStyles = null) : \PHPExcel_Style_Border

Apply styles from array

$objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->getTop()->applyFromArray( array( 'style' => PHPExcel_Style_Border::BORDER_DASHDOT, 'color' => array( 'rgb' => '808080' ) ) );

Parameters

array $pStyles

Array containing style information

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Border

getBorderStyle()

getBorderStyle() : string

Get Border style

Returns

string

setBorderStyle()

setBorderStyle(string|boolean  $pValue = \PHPExcel_Style_Border::BORDER_NONE) : \PHPExcel_Style_Border

Set Border style

Parameters

string|boolean $pValue

When passing a boolean, FALSE equates PHPExcel_Style_Border::BORDER_NONE and TRUE to PHPExcel_Style_Border::BORDER_MEDIUM

Returns

\PHPExcel_Style_Border

getHashCode()

getHashCode() : string

Get hash code

Returns

string —

Hash code