\PHPExcel_Writer_Excel2007_Style

PHPExcel_Writer_Excel2007_Style

Copyright (c) 2006 - 2015 PHPExcel

This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

Summary

Methods
Properties
Constants
setParentWriter()
getParentWriter()
__construct()
writeStyles()
allStyles()
allConditionalStyles()
allFills()
allFonts()
allBorders()
allNumberFormats()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
writeFill()
writeGradientFill()
writePatternFill()
writeFont()
writeBorder()
writeCellStyleXf()
writeCellStyleDxf()
writeBorderPr()
writeNumFmt()
$parentWriter
N/A

Properties

Methods

setParentWriter()

setParentWriter(\PHPExcel_Writer_IWriter  $pWriter = null) 

Set parent IWriter object

Parameters

\PHPExcel_Writer_IWriter $pWriter

Throws

\PHPExcel_Writer_Exception

getParentWriter()

getParentWriter() : \PHPExcel_Writer_IWriter

Get parent IWriter object

Throws

\PHPExcel_Writer_Exception

Returns

\PHPExcel_Writer_IWriter

__construct()

__construct(\PHPExcel_Writer_IWriter  $pWriter = null) 

Set parent IWriter object

Parameters

\PHPExcel_Writer_IWriter $pWriter

Throws

\PHPExcel_Writer_Exception

writeStyles()

writeStyles(\PHPExcel  $pPHPExcel = null) : string

Write styles to XML format

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

string —

XML Output

allStyles()

allStyles(\PHPExcel  $pPHPExcel = null) : array<mixed,\PHPExcel_Style>

Get an array of all styles

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

array<mixed,\PHPExcel_Style> —

All styles in PHPExcel

allConditionalStyles()

allConditionalStyles(\PHPExcel  $pPHPExcel = null) : array<mixed,\PHPExcel_Style_Conditional>

Get an array of all conditional styles

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

array<mixed,\PHPExcel_Style_Conditional> —

All conditional styles in PHPExcel

allFills()

allFills(\PHPExcel  $pPHPExcel = null) : array<mixed,\PHPExcel_Style_Fill>

Get an array of all fills

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

array<mixed,\PHPExcel_Style_Fill> —

All fills in PHPExcel

allFonts()

allFonts(\PHPExcel  $pPHPExcel = null) : array<mixed,\PHPExcel_Style_Font>

Get an array of all fonts

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

array<mixed,\PHPExcel_Style_Font> —

All fonts in PHPExcel

allBorders()

allBorders(\PHPExcel  $pPHPExcel = null) : array<mixed,\PHPExcel_Style_Borders>

Get an array of all borders

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

array<mixed,\PHPExcel_Style_Borders> —

All borders in PHPExcel

allNumberFormats()

allNumberFormats(\PHPExcel  $pPHPExcel = null) : array<mixed,\PHPExcel_Style_NumberFormat>

Get an array of all number formats

Parameters

\PHPExcel $pPHPExcel

Throws

\PHPExcel_Writer_Exception

Returns

array<mixed,\PHPExcel_Style_NumberFormat> —

All number formats in PHPExcel

writeFill()

writeFill(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style_Fill  $pFill = null) 

Write Fill

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style_Fill $pFill

Fill style

Throws

\PHPExcel_Writer_Exception

writeGradientFill()

writeGradientFill(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style_Fill  $pFill = null) 

Write Gradient Fill

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style_Fill $pFill

Fill style

Throws

\PHPExcel_Writer_Exception

writePatternFill()

writePatternFill(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style_Fill  $pFill = null) 

Write Pattern Fill

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style_Fill $pFill

Fill style

Throws

\PHPExcel_Writer_Exception

writeFont()

writeFont(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style_Font  $pFont = null) 

Write Font

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style_Font $pFont

Font style

Throws

\PHPExcel_Writer_Exception

writeBorder()

writeBorder(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style_Borders  $pBorders = null) 

Write Border

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style_Borders $pBorders

Borders style

Throws

\PHPExcel_Writer_Exception

writeCellStyleXf()

writeCellStyleXf(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style  $pStyle = null, \PHPExcel  $pPHPExcel = null) 

Write Cell Style Xf

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style $pStyle

Style

\PHPExcel $pPHPExcel

Workbook

Throws

\PHPExcel_Writer_Exception

writeCellStyleDxf()

writeCellStyleDxf(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style  $pStyle = null) 

Write Cell Style Dxf

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style $pStyle

Style

Throws

\PHPExcel_Writer_Exception

writeBorderPr()

writeBorderPr(\PHPExcel_Shared_XMLWriter  $objWriter = null, string  $pName = 'left', \PHPExcel_Style_Border  $pBorder = null) 

Write BorderPr

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

string $pName

Element name

\PHPExcel_Style_Border $pBorder

Border style

Throws

\PHPExcel_Writer_Exception

writeNumFmt()

writeNumFmt(\PHPExcel_Shared_XMLWriter  $objWriter = null, \PHPExcel_Style_NumberFormat  $pNumberFormat = null, integer  $pId) 

Write NumberFormat

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Style_NumberFormat $pNumberFormat

Number Format

integer $pId

Number Format identifier

Throws

\PHPExcel_Writer_Exception