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

writeChart()

writeChart(\PHPExcel_Chart  $pChart = NULL) : string

Write charts to XML format

Parameters

\PHPExcel_Chart $pChart

Throws

\PHPExcel_Writer_Exception

Returns

string —

XML Output

_writeTitle()

_writeTitle(\PHPExcel_Chart_Title  $title = NULL, \PHPExcel_Shared_XMLWriter  $objWriter) 

Write Chart Title

Parameters

\PHPExcel_Chart_Title $title
\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writeLegend()

_writeLegend(\PHPExcel_Chart_Legend  $legend = NULL, \PHPExcel_Shared_XMLWriter  $objWriter) 

Write Chart Legend

Parameters

\PHPExcel_Chart_Legend $legend
\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writePlotArea()

_writePlotArea(\PHPExcel_Chart_PlotArea  $plotArea, \PHPExcel_Chart_Title  $xAxisLabel = NULL, \PHPExcel_Chart_Title  $yAxisLabel = NULL, \PHPExcel_Shared_XMLWriter  $objWriter, \PHPExcel_Worksheet  $pSheet, \PHPExcel_Chart_Axis  $xAxis, \PHPExcel_Chart_Axis  $yAxis, \PHPExcel_Chart_GridLines  $majorGridlines, \PHPExcel_Chart_GridLines  $minorGridlines) 

Write Chart Plot Area

Parameters

\PHPExcel_Chart_PlotArea $plotArea
\PHPExcel_Chart_Title $xAxisLabel
\PHPExcel_Chart_Title $yAxisLabel
\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Worksheet $pSheet
\PHPExcel_Chart_Axis $xAxis
\PHPExcel_Chart_Axis $yAxis
\PHPExcel_Chart_GridLines $majorGridlines
\PHPExcel_Chart_GridLines $minorGridlines

Throws

\PHPExcel_Writer_Exception

_writeDataLbls()

_writeDataLbls(\PHPExcel_Shared_XMLWriter  $objWriter, \PHPExcel_Chart_Layout  $chartLayout) 

Write Data Labels

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Chart_Layout $chartLayout

Chart layout

Throws

\PHPExcel_Writer_Exception

_writeCatAx()

_writeCatAx(\PHPExcel_Shared_XMLWriter  $objWriter, \PHPExcel_Chart_PlotArea  $plotArea, \PHPExcel_Chart_Title  $xAxisLabel, string  $groupType, string  $id1, string  $id2, boolean  $isMultiLevelSeries,   $xAxis,   $yAxis) 

Write Category Axis

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Chart_PlotArea $plotArea
\PHPExcel_Chart_Title $xAxisLabel
string $groupType

Chart type

string $id1
string $id2
boolean $isMultiLevelSeries
$xAxis
$yAxis

Throws

\PHPExcel_Writer_Exception

_writeValAx()

_writeValAx(\PHPExcel_Shared_XMLWriter  $objWriter, \PHPExcel_Chart_PlotArea  $plotArea, \PHPExcel_Chart_Title  $yAxisLabel, string  $groupType, string  $id1, string  $id2, boolean  $isMultiLevelSeries,   $xAxis,   $yAxis,   $majorGridlines,   $minorGridlines) 

Write Value Axis

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

\PHPExcel_Chart_PlotArea $plotArea
\PHPExcel_Chart_Title $yAxisLabel
string $groupType

Chart type

string $id1
string $id2
boolean $isMultiLevelSeries
$xAxis
$yAxis
$majorGridlines
$minorGridlines

Throws

\PHPExcel_Writer_Exception

_getChartType()

_getChartType(\PHPExcel_Chart_PlotArea  $plotArea) : string|array

Get the data series type(s) for a chart plot series

Parameters

\PHPExcel_Chart_PlotArea $plotArea

Throws

\PHPExcel_Writer_Exception

Returns

string|array

_writePlotGroup()

_writePlotGroup(\PHPExcel_Chart_DataSeries  $plotGroup, string  $groupType, \PHPExcel_Shared_XMLWriter  $objWriter,   $catIsMultiLevelSeries,   $valIsMultiLevelSeries,   $plotGroupingType, \PHPExcel_Worksheet  $pSheet) 

Write Plot Group (series of related plots)

Parameters

\PHPExcel_Chart_DataSeries $plotGroup
string $groupType

Type of plot for dataseries

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

$catIsMultiLevelSeries
$valIsMultiLevelSeries
$plotGroupingType
\PHPExcel_Worksheet $pSheet

Throws

\PHPExcel_Writer_Exception

_writePlotSeriesLabel()

_writePlotSeriesLabel(\PHPExcel_Chart_DataSeriesValues  $plotSeriesLabel, \PHPExcel_Shared_XMLWriter  $objWriter) 

Write Plot Series Label

Parameters

\PHPExcel_Chart_DataSeriesValues $plotSeriesLabel
\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writePlotSeriesValues()

_writePlotSeriesValues(\PHPExcel_Chart_DataSeriesValues  $plotSeriesValues, \PHPExcel_Shared_XMLWriter  $objWriter, string  $groupType, string  $dataType = 'str', \PHPExcel_Worksheet  $pSheet) 

Write Plot Series Values

Parameters

\PHPExcel_Chart_DataSeriesValues $plotSeriesValues
\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

string $groupType

Type of plot for dataseries

string $dataType

Datatype of series values

\PHPExcel_Worksheet $pSheet

Throws

\PHPExcel_Writer_Exception

_writeLayout()

_writeLayout(\PHPExcel_Chart_Layout  $layout = NULL, \PHPExcel_Shared_XMLWriter  $objWriter) 

Write Layout

Parameters

\PHPExcel_Chart_Layout $layout
\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writeAlternateContent()

_writeAlternateContent(\PHPExcel_Shared_XMLWriter  $objWriter) 

Write Alternate Content block

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception

_writePrintSettings()

_writePrintSettings(\PHPExcel_Shared_XMLWriter  $objWriter) 

Write Printer Settings

Parameters

\PHPExcel_Shared_XMLWriter $objWriter

XML Writer

Throws

\PHPExcel_Writer_Exception