\PHPExcel_Writer_Excel2007_Chart

PHPExcel_Writer_Excel2007_Chart

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()
writeChart()
No public properties found
No constants found
No protected methods found
$calculateCellValues
N/A
writeTitle()
writeLegend()
writePlotArea()
writeDataLabels()
writeCategoryAxis()
writeValueAxis()
getChartType()
writePlotGroup()
writePlotSeriesLabel()
writePlotSeriesValues()
writeBubbles()
writeLayout()
writeAlternateContent()
writePrintSettings()
$parentWriter
N/A

Properties

$calculateCellValues

$calculateCellValues : 

Type

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,   $calculateCellValues = true) : string

Write charts to XML format

Parameters

\PHPExcel_Chart $pChart
$calculateCellValues

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

writeDataLabels()

writeDataLabels(\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

writeCategoryAxis()

writeCategoryAxis(\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

writeValueAxis()

writeValueAxis(\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