33chartcreate-multiple-charts.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
	$xAxisTickValues1
	$dataSeriesValues1
	$series1
	$plotArea1 = new PHPExcel_Chart_PlotArea(NULL, array($series1))
	$legend1 = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_TOPRIGHT, NULL, false)
	$title1 = new PHPExcel_Chart_Title('Test %age-Stacked Area Chart')
	$yAxisLabel1 = new PHPExcel_Chart_Title('Value ($k)')
	$chart1
	$dataSeriesLabels2
	$xAxisTickValues2
	$dataSeriesValues2
	$series2
	$plotArea2 = new PHPExcel_Chart_PlotArea(NULL, array($series2))
	$legend2 = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false)
	$title2 = new PHPExcel_Chart_Title('Test Column Chart')
	$yAxisLabel2 = new PHPExcel_Chart_Title('Value ($k)')
	$chart2
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

$chart1

$chart1

Initial value:

= new PHPExcel_Chart(
        'chart1',               
        $title1,                
        $legend1,               
        $plotArea1,             
        true,                   
        0,                              
        NULL,                   
        $yAxisLabel1    
)

Definition at line 111 of file 33chartcreate-multiple-charts.php.

$chart2

$chart2

Initial value:

= new PHPExcel_Chart(
        'chart2',               
        $title2,                
        $legend2,               
        $plotArea2,             
        true,                   
        0,                              
        NULL,                   
        $yAxisLabel2    
)

Definition at line 188 of file 33chartcreate-multiple-charts.php.

$dataSeriesLabels1

$dataSeriesLabels1

Initial value:

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

Definition at line 63 of file 33chartcreate-multiple-charts.php.

$dataSeriesLabels2

$dataSeriesLabels2

Initial value:

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

Definition at line 137 of file 33chartcreate-multiple-charts.php.

$dataSeriesValues1

$dataSeriesValues1

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
)

Definition at line 85 of file 33chartcreate-multiple-charts.php.

$dataSeriesValues2

$dataSeriesValues2

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
)

Definition at line 159 of file 33chartcreate-multiple-charts.php.

$legend1

$legend1 = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_TOPRIGHT, NULL, false)

Definition at line 104 of file 33chartcreate-multiple-charts.php.

$legend2

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

Definition at line 181 of file 33chartcreate-multiple-charts.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

PHPExcel.

Definition at line 43 of file 33chartcreate-multiple-charts.php.

$objWorksheet

$objWorksheet = $objPHPExcel->getActiveSheet()

Definition at line 44 of file 33chartcreate-multiple-charts.php.

$objWriter

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

Definition at line 209 of file 33chartcreate-multiple-charts.php.

$plotArea1

$plotArea1 = new PHPExcel_Chart_PlotArea(NULL, array($series1))

Definition at line 102 of file 33chartcreate-multiple-charts.php.

$plotArea2

$plotArea2 = new PHPExcel_Chart_PlotArea(NULL, array($series2))

Definition at line 179 of file 33chartcreate-multiple-charts.php.

$series1

$series1

Initial value:

= new PHPExcel_Chart_DataSeries(
        PHPExcel_Chart_DataSeries::TYPE_AREACHART,                              
        PHPExcel_Chart_DataSeries::GROUPING_PERCENT_STACKED,    
        range(0, count($dataSeriesValues1)-1),                                  
        $dataSeriesLabels1,                                                                             
        $xAxisTickValues1,                                                                              
        $dataSeriesValues1                                                                              
)

Definition at line 92 of file 33chartcreate-multiple-charts.php.

$series2

$series2

Initial value:

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

Definition at line 166 of file 33chartcreate-multiple-charts.php.

$title1

$title1 = new PHPExcel_Chart_Title('Test %age-Stacked Area Chart')

Definition at line 106 of file 33chartcreate-multiple-charts.php.

$title2

$title2 = new PHPExcel_Chart_Title('Test Column Chart')

Definition at line 183 of file 33chartcreate-multiple-charts.php.

$xAxisTickValues1

$xAxisTickValues1

Initial value:

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

Definition at line 75 of file 33chartcreate-multiple-charts.php.

$xAxisTickValues2

$xAxisTickValues2

Initial value:

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

Definition at line 149 of file 33chartcreate-multiple-charts.php.

$yAxisLabel1

$yAxisLabel1 = new PHPExcel_Chart_Title('Value ($k)')

Definition at line 107 of file 33chartcreate-multiple-charts.php.

$yAxisLabel2

$yAxisLabel2 = new PHPExcel_Chart_Title('Value ($k)')

Definition at line 184 of file 33chartcreate-multiple-charts.php.

EOL

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

Definition at line 9 of file 33chartcreate-multiple-charts.php.

file

Done writing file

Definition at line 219 of file 33chartcreate-multiple-charts.php.

format

Write to Excel2007 format

Definition at line 208 of file 33chartcreate-multiple-charts.php.

MB

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

Definition at line 216 of file 33chartcreate-multiple-charts.php.

to

File written to

Definition at line 212 of file 33chartcreate-multiple-charts.php.

usage

Peak memory usage

Definition at line 216 of file 33chartcreate-multiple-charts.php.