Overview

Packages

  • JAMA
  • None
  • PHP
  • PHPExcel
    • CachedObjectStorage
    • Calculation
    • Cell
    • Chart
      • Renderer
    • Reader
      • Excel2007
      • Excel5
    • RichText
    • Settings
    • Shared
      • Escher
      • OLE
      • Trend
      • ZipArchive
    • Style
    • Worksheet
      • Drawing
    • Writer
      • 2007
      • CSV
      • Excel2007
      • Excel5
      • HTML
      • PDF

Classes

  • PHPExcel_Style
  • PHPExcel_Style_Alignment
  • PHPExcel_Style_Border
  • PHPExcel_Style_Borders
  • PHPExcel_Style_Color
  • PHPExcel_Style_Conditional
  • PHPExcel_Style_Fill
  • PHPExcel_Style_Font
  • PHPExcel_Style_NumberFormat
  • PHPExcel_Style_Protection
  • PHPExcel_Style_Supervisor
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class PHPExcel_Style

PHPExcel_Style

PHPExcel_Style_Supervisor
Extended by PHPExcel_Style implements PHPExcel_IComparable
Package: PHPExcel\Style
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Style.php
Methods summary
public
# __construct( boolean $isSupervisor = false, boolean $isConditional = false )

Create a new PHPExcel_Style

Create a new PHPExcel_Style

Parameters

$isSupervisor

Flag indicating if this is a supervisor or not Leave this value at default unless you understand exactly what its ramifications are

$isConditional

Flag indicating if this is a conditional style or not Leave this value at default unless you understand exactly what its ramifications are

Overrides

PHPExcel_Style_Supervisor::__construct()
public PHPExcel_Style
# getSharedComponent( )

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

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

Returns

PHPExcel_Style
public PHPExcel
# getParent( )

Get parent. Only used for style supervisor

Get parent. Only used for style supervisor

Returns

PHPExcel
public array
# getStyleArray( array $array )

Build style array from subcomponents

Build style array from subcomponents

Parameters

$array

Returns

array
public PHPExcel_Style
# applyFromArray( array $pStyles = null, boolean $pAdvanced = true )

Apply styles from array

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'
                    )
                )
            ),
            'quotePrefix'    => true
        )
);

Parameters

$pStyles
Array containing style information
$pAdvanced
Advanced mode for setting borders.

Returns

PHPExcel_Style

Throws

PHPExcel_Exception
public PHPExcel_Style_Fill
# getFill( )

Get Fill

Get Fill

Returns

PHPExcel_Style_Fill
public PHPExcel_Style_Font
# getFont( )

Get Font

Get Font

Returns

PHPExcel_Style_Font
public PHPExcel_Style
# setFont( PHPExcel_Style_Font $font )

Set font

Set font

Parameters

$font

Returns

PHPExcel_Style
public PHPExcel_Style_Borders
# getBorders( )

Get Borders

Get Borders

Returns

PHPExcel_Style_Borders
public PHPExcel_Style_Alignment
# getAlignment( )

Get Alignment

Get Alignment

Returns

PHPExcel_Style_Alignment
public PHPExcel_Style_NumberFormat
# getNumberFormat( )

Get Number Format

Get Number Format

Returns

PHPExcel_Style_NumberFormat
public PHPExcel_Style_Conditional[]
# getConditionalStyles( )

Get Conditional Styles. Only used on supervisor.

Get Conditional Styles. Only used on supervisor.

Returns

PHPExcel_Style_Conditional[]
public PHPExcel_Style
# setConditionalStyles( PHPExcel_Style_Conditional[] $pValue = null )

Set Conditional Styles. Only used on supervisor.

Set Conditional Styles. Only used on supervisor.

Parameters

$pValue
Array of condtional styles

Returns

PHPExcel_Style
public PHPExcel_Style_Protection
# getProtection( )

Get Protection

Get Protection

Returns

PHPExcel_Style_Protection
public boolean
# getQuotePrefix( )

Get quote prefix

Get quote prefix

Returns

boolean
public
# setQuotePrefix( boolean $pValue )

Set quote prefix

Set quote prefix

Parameters

$pValue
public string
# getHashCode( )

Get hash code

Get hash code

Returns

string
Hash code

Implementation of

PHPExcel_IComparable::getHashCode()
public integer
# getIndex( )

Get own index in style collection

Get own index in style collection

Returns

integer
public
# setIndex( integer $pValue )

Set own index in style collection

Set own index in style collection

Parameters

$pValue
Methods inherited from PHPExcel_Style_Supervisor
__clone(), bindParent(), getActiveCell(), getActiveSheet(), getIsSupervisor(), getSelectedCells()
Properties summary
protected PHPExcel_Style_Font $_font

Font

Font

#
protected PHPExcel_Style_Fill $_fill

Fill

Fill

#
protected PHPExcel_Style_Borders $_borders

Borders

Borders

#
protected PHPExcel_Style_Alignment $_alignment

Alignment

Alignment

#
protected PHPExcel_Style_NumberFormat $_numberFormat

Number Format

Number Format

#
protected PHPExcel_Style_Conditional[] $_conditionalStyles

Conditional styles

Conditional styles

#
protected PHPExcel_Style_Protection $_protection

Protection

Protection

#
protected integer $_index

Index of style in collection. Only used for real style.

Index of style in collection. Only used for real style.

#
protected boolean $_quotePrefix

Use Quote Prefix when displaying in cell editor. Only used for real style.

Use Quote Prefix when displaying in cell editor. Only used for real style.

# false
Properties inherited from PHPExcel_Style_Supervisor
$_isSupervisor, $_parent
Autene API documentation generated by ApiGen