Constants

DIAGONAL_NONE

DIAGONAL_NONE = 0

DIAGONAL_UP

DIAGONAL_UP = 1

DIAGONAL_DOWN

DIAGONAL_DOWN = 2

DIAGONAL_BOTH

DIAGONAL_BOTH = 3

Properties

$_isSupervisor

$_isSupervisor : bool

Supervisor?

Type

bool

$_parent

$_parent : \PHPExcel_Style

Parent. Only used for supervisor

Type

PHPExcel_Style

$_diagonalDirection

$_diagonalDirection : int

DiagonalDirection

Type

int

$_allBorders

$_allBorders : \PHPExcel_Style_Border

All borders psedo-border. Only applies to supervisor.

Type

PHPExcel_Style_Border

$_outline

$_outline : \PHPExcel_Style_Border

Outline psedo-border. Only applies to supervisor.

Type

PHPExcel_Style_Border

$_inside

$_inside : \PHPExcel_Style_Border

Inside psedo-border. Only applies to supervisor.

Type

PHPExcel_Style_Border

$_vertical

$_vertical : \PHPExcel_Style_Border

Vertical pseudo-border. Only applies to supervisor.

Type

PHPExcel_Style_Border

$_horizontal

$_horizontal : \PHPExcel_Style_Border

Horizontal pseudo-border. Only applies to supervisor.

Type

PHPExcel_Style_Border

Methods

__construct()

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

Create a new PHPExcel_Style_Borders

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_Borders

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

Only used for style supervisor

Returns

\PHPExcel_Style_Borders —

getStyleArray()

getStyleArray(array  $array) : array

Build style array from subcomponents

Parameters

array $array

Returns

array —

applyFromArray()

applyFromArray(array  $pStyles = null) : \PHPExcel_Style_Borders

Apply styles from array

$objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->applyFromArray( 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' ) ) ) ); $objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->applyFromArray( array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_DASHDOT, 'color' => array( 'rgb' => '808080' ) ) ) );

Parameters

array $pStyles

Array containing style information

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Borders —

getLeft()

getLeft() : \PHPExcel_Style_Border

Get Left

Returns

\PHPExcel_Style_Border —

getRight()

getRight() : \PHPExcel_Style_Border

Get Right

Returns

\PHPExcel_Style_Border —

getTop()

getTop() : \PHPExcel_Style_Border

Get Top

Returns

\PHPExcel_Style_Border —

getBottom()

getBottom() : \PHPExcel_Style_Border

Get Bottom

Returns

\PHPExcel_Style_Border —

getDiagonal()

getDiagonal() : \PHPExcel_Style_Border

Get Diagonal

Returns

\PHPExcel_Style_Border —

getAllBorders()

getAllBorders() : \PHPExcel_Style_Border

Get AllBorders (pseudo-border). Only applies to supervisor.

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Border —

getOutline()

getOutline() : bool

Get Outline (pseudo-border). Only applies to supervisor.

Throws

\PHPExcel_Exception

Returns

bool —

getInside()

getInside() : bool

Get Inside (pseudo-border). Only applies to supervisor.

Throws

\PHPExcel_Exception

Returns

bool —

getVertical()

getVertical() : \PHPExcel_Style_Border

Get Vertical (pseudo-border). Only applies to supervisor.

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Border —

getHorizontal()

getHorizontal() : \PHPExcel_Style_Border

Get Horizontal (pseudo-border). Only applies to supervisor.

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Style_Border —

getDiagonalDirection()

getDiagonalDirection() : int

Get DiagonalDirection

Returns

int —

setDiagonalDirection()

setDiagonalDirection(int  $pValue = PHPExcel_Style_Borders::DIAGONAL_NONE) : \PHPExcel_Style_Borders

Set DiagonalDirection

Parameters

int $pValue

Returns

\PHPExcel_Style_Borders —

getHashCode()

getHashCode() : string

Get hash code

Returns

string —

Hash code