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