$_isSupervisor
$_isSupervisor : boolean
Supervisor?
PHPExcel_Style
$_parent : \PHPExcel_Style
Parent. Only used for supervisor
$_font : \PHPExcel_Style_Font
Font
$_fill : \PHPExcel_Style_Fill
Fill
$_borders : \PHPExcel_Style_Borders
Borders
$_alignment : \PHPExcel_Style_Alignment
Alignment
$_numberFormat : \PHPExcel_Style_NumberFormat
Number Format
$_conditionalStyles : array<mixed,\PHPExcel_Style_Conditional>
Conditional styles
$_protection : \PHPExcel_Style_Protection
Protection
__construct(boolean $isSupervisor = false, boolean $isConditional = false)
Create a new PHPExcel_Style
| 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(\PHPExcel $parent, $parentPropertyName = NULL) : \PHPExcel_Style_Supervisor
Bind parent. Only used for supervisor
| \PHPExcel | $parent | |
| $parentPropertyName |
getActiveSheet() : \PHPExcel_Worksheet
Get the currently active sheet. Only used for supervisor
getSharedComponent() : \PHPExcel_Style
Get the shared style component for the currently active cell in currently active sheet.
Only used for style supervisor
getParent() : \PHPExcel
Get parent. Only used for style supervisor
applyFromArray(array $pStyles = null, boolean $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'
)
)
)
)
);
| array | $pStyles | Array containing style information |
| boolean | $pAdvanced | Advanced mode for setting borders. |
getFill() : \PHPExcel_Style_Fill
Get Fill
getFont() : \PHPExcel_Style_Font
Get Font
setFont(\PHPExcel_Style_Font $font) : \PHPExcel_Style
Set font
| \PHPExcel_Style_Font | $font |
getBorders() : \PHPExcel_Style_Borders
Get Borders
getAlignment() : \PHPExcel_Style_Alignment
Get Alignment
getNumberFormat() : \PHPExcel_Style_NumberFormat
Get Number Format
getConditionalStyles() : array<mixed,\PHPExcel_Style_Conditional>
Get Conditional Styles. Only used on supervisor.
setConditionalStyles(array<mixed,\PHPExcel_Style_Conditional> $pValue = null) : \PHPExcel_Style
Set Conditional Styles. Only used on supervisor.
| array<mixed,\PHPExcel_Style_Conditional> | $pValue | Array of condtional styles |
getProtection() : \PHPExcel_Style_Protection
Get Protection