33chartcreate-bar.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()
	$dataSeriesLabels
	$xAxisTickValues
	$dataSeriesValues
	$series
	$plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series))
	$legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false)
	$title = new PHPExcel_Chart_Title('Test Bar Chart')
	$yAxisLabel = new PHPExcel_Chart_Title('Value ($k)')
	$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,                   
        $yAxisLabel             
)

Definition at line 113 of file 33chartcreate-bar.php.

$dataSeriesLabels

$dataSeriesLabels

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 62 of file 33chartcreate-bar.php.

$dataSeriesValues

$dataSeriesValues

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 84 of file 33chartcreate-bar.php.

$legend

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

Definition at line 106 of file 33chartcreate-bar.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

PHPExcel.

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

$objWorksheet

$objWorksheet = $objPHPExcel->getActiveSheet()

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

$objWriter

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

Definition at line 134 of file 33chartcreate-bar.php.

$plotArea

$plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series))

Definition at line 104 of file 33chartcreate-bar.php.

$series

$series

Initial value:

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

Definition at line 91 of file 33chartcreate-bar.php.

$title

$title = new PHPExcel_Chart_Title('Test Bar Chart')

Definition at line 108 of file 33chartcreate-bar.php.

$xAxisTickValues

$xAxisTickValues

Initial value:

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

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

$yAxisLabel

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

Definition at line 109 of file 33chartcreate-bar.php.

EOL

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

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

file

Done writing file

Definition at line 144 of file 33chartcreate-bar.php.

format

Write to Excel2007 format

Definition at line 133 of file 33chartcreate-bar.php.

MB

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

Definition at line 141 of file 33chartcreate-bar.php.

to

File written to

Definition at line 137 of file 33chartcreate-bar.php.

usage

Peak memory usage

Definition at line 141 of file 33chartcreate-bar.php.