33chartcreate-composite.php File Reference

Go to the source code of this file.

Namespaces
	PHPExcel

Variables
const	EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
	$objPHPExcel = new PHPExcel()
	PHPExcel. More...
	$objWorksheet = $objPHPExcel->getActiveSheet()
	$dataSeriesLabels1
	$dataSeriesLabels2
	$dataSeriesLabels3
	$xAxisTickValues
	$dataSeriesValues1
	$series1
	$dataSeriesValues2
	$series2
	$dataSeriesValues3
	$series3
	$plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series1, $series2, $series3))
	$legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false)
	$title = new PHPExcel_Chart_Title('Average Weather Chart for Crete')
	$chart
Write to Excel2007	format
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')
File written	to
Peak memory	usage
Peak memory memory_get_peak_usage(true)/1024/1024)	MB
Done writing	file

Variable Documentation

$chart

$chart

Initial value:

= new PHPExcel_Chart(
        'chart1',               
        $title,                 
        $legend,                
        $plotArea,              
        true,                   
        0,                              
        NULL,                   
        NULL                    
)

Definition at line 171 of file 33chartcreate-composite.php.

$dataSeriesLabels1

$dataSeriesLabels1

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),       
)

Definition at line 71 of file 33chartcreate-composite.php.

$dataSeriesLabels2

$dataSeriesLabels2

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),       
)

Definition at line 74 of file 33chartcreate-composite.php.

$dataSeriesLabels3

$dataSeriesLabels3

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),       
)

Definition at line 77 of file 33chartcreate-composite.php.

$dataSeriesValues1

$dataSeriesValues1

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$13', NULL, 12),
)

Definition at line 100 of file 33chartcreate-composite.php.

$dataSeriesValues2

$dataSeriesValues2

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
)

Definition at line 125 of file 33chartcreate-composite.php.

$dataSeriesValues3

$dataSeriesValues3

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
)

Definition at line 147 of file 33chartcreate-composite.php.

$legend

$legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false)

Definition at line 165 of file 33chartcreate-composite.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

PHPExcel.

Definition at line 43 of file 33chartcreate-composite.php.

$objWorksheet

$objWorksheet = $objPHPExcel->getActiveSheet()

Definition at line 44 of file 33chartcreate-composite.php.

$objWriter

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')

Definition at line 192 of file 33chartcreate-composite.php.

$plotArea

$plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series1, $series2, $series3))

Definition at line 163 of file 33chartcreate-composite.php.

$series1

$series1

Initial value:

= new PHPExcel_Chart_DataSeries(
        PHPExcel_Chart_DataSeries::TYPE_BARCHART,               
        PHPExcel_Chart_DataSeries::GROUPING_CLUSTERED,  
        range(0, count($dataSeriesValues1)-1),                  
        $dataSeriesLabels1,                                                             
        $xAxisTickValues,                                                               
        $dataSeriesValues1                                                              
)

Definition at line 105 of file 33chartcreate-composite.php.

$series2

$series2

Initial value:

= new PHPExcel_Chart_DataSeries(
        PHPExcel_Chart_DataSeries::TYPE_LINECHART,              
        PHPExcel_Chart_DataSeries::GROUPING_STANDARD,   
        range(0, count($dataSeriesValues2)-1),                  
        $dataSeriesLabels2,                                                             
        NULL,                                                                                   
        $dataSeriesValues2                                                              
)

Definition at line 130 of file 33chartcreate-composite.php.

$series3

$series3

Initial value:

= new PHPExcel_Chart_DataSeries(
        PHPExcel_Chart_DataSeries::TYPE_AREACHART,              
        PHPExcel_Chart_DataSeries::GROUPING_STANDARD,   
        range(0, count($dataSeriesValues2)-1),                  
        $dataSeriesLabels3,                                                             
        NULL,                                                                                   
        $dataSeriesValues3                                                              
)

Definition at line 152 of file 33chartcreate-composite.php.

$title

$title = new PHPExcel_Chart_Title('Average Weather Chart for Crete')

Definition at line 167 of file 33chartcreate-composite.php.

$xAxisTickValues

$xAxisTickValues

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),        
)

Definition at line 88 of file 33chartcreate-composite.php.

EOL

getcwd () EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'

Definition at line 9 of file 33chartcreate-composite.php.

file

Done writing file

Definition at line 202 of file 33chartcreate-composite.php.

format

Write to Excel2007 format

Definition at line 191 of file 33chartcreate-composite.php.

MB

Peak memory memory_get_peak_usage (true)/1024/1024) MB

Definition at line 199 of file 33chartcreate-composite.php.

to

File written to

Definition at line 195 of file 33chartcreate-composite.php.

usage

Peak memory usage

Definition at line 199 of file 33chartcreate-composite.php.