Inspection of "Avoid duplicated info in README" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 942ad7...b0621f )

by Adrien

created 2016-08-25 02:56 UTC

Status

Indentation +64 added lines, -64 removed lines patch added patch discarded remove patch

@@ -22,79 +22,79 @@
 block discarded – undo
 
 
 if (!PHPExcel\Settings::setChartRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
 $inputFileType = 'Excel2007';
 $inputFileNames = 'templates/32readwrite*[0-9].xlsx';
 
-	if ((isset($argc)) && ($argc > 1)) {
-	$inputFileNames = array();
-	for($i = 1; $i < $argc; ++$i) {
-		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
-	}
+    if ((isset($argc)) && ($argc > 1)) {
+    $inputFileNames = array();
+    for($i = 1; $i < $argc; ++$i) {
+        $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
+    }
 } else {
-	$inputFileNames = glob($inputFileNames);
+    $inputFileNames = glob($inputFileNames);
 }
 foreach($inputFileNames as $inputFileName) {
-	$inputFileNameShort = basename($inputFileName);
-
-	if (!file_exists($inputFileName)) {
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
-		continue;
-	}
-
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
-
-	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
-	$objReader->setIncludeCharts(TRUE);
-	$objPHPExcel = $objReader->load($inputFileName);
-
-
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
-	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-		$sheetName = $worksheet->getTitle();
-		echo 'Worksheet: ' , $sheetName , EOL;
-
-		$chartNames = $worksheet->getChartNames();
-		if(empty($chartNames)) {
-			echo '    There are no charts in this worksheet' , EOL;
-		} else {
-			natsort($chartNames);
-			foreach($chartNames as $i => $chartName) {
-				$chart = $worksheet->getChartByName($chartName);
-				if (!is_null($chart->getTitle())) {
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
-				} else {
-					$caption = 'Untitled';
-				}
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
-				echo str_repeat(' ',strlen($chartName)+3);
-
-				$jpegFile = '35'.str_replace('.xlsx', '.jpg', substr($inputFileNameShort,2));
-				if (file_exists($jpegFile)) {
-					unlink($jpegFile);
-				}
-				try {
-					$chart->render($jpegFile);
-				} catch (Exception $e) {
-					echo 'Error rendering chart: ',$e->getMessage();
-				}
-			}
-		}
-	}
-
-
-	$objPHPExcel->disconnectWorksheets();
-	unset($objPHPExcel);
+    $inputFileNameShort = basename($inputFileName);
+
+    if (!file_exists($inputFileName)) {
+        echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
+        continue;
+    }
+
+    echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
+
+    $objReader = \PHPExcel\IOFactory::createReader($inputFileType);
+    $objReader->setIncludeCharts(TRUE);
+    $objPHPExcel = $objReader->load($inputFileName);
+
+
+    echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
+    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
+        $sheetName = $worksheet->getTitle();
+        echo 'Worksheet: ' , $sheetName , EOL;
+
+        $chartNames = $worksheet->getChartNames();
+        if(empty($chartNames)) {
+            echo '    There are no charts in this worksheet' , EOL;
+        } else {
+            natsort($chartNames);
+            foreach($chartNames as $i => $chartName) {
+                $chart = $worksheet->getChartByName($chartName);
+                if (!is_null($chart->getTitle())) {
+                    $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
+                } else {
+                    $caption = 'Untitled';
+                }
+                echo '    ' , $chartName , ' - ' , $caption , EOL;
+                echo str_repeat(' ',strlen($chartName)+3);
+
+                $jpegFile = '35'.str_replace('.xlsx', '.jpg', substr($inputFileNameShort,2));
+                if (file_exists($jpegFile)) {
+                    unlink($jpegFile);
+                }
+                try {
+                    $chart->render($jpegFile);
+                } catch (Exception $e) {
+                    echo 'Error rendering chart: ',$e->getMessage();
+                }
+            }
+        }
+    }
+
+
+    $objPHPExcel->disconnectWorksheets();
+    unset($objPHPExcel);
 }
 
 // Echo memory peak usage

Please login to merge, or discard this patch.

Examples/33chartcreate-pie.php 1 patch

Indentation +41 added lines, -41 removed lines patch added patch discarded remove patch

@@ -43,13 +43,13 @@  discard block
 block discarded – undo
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',	2010,	2011,	2012),
-		array('Q1',   12,   15,		21),
-		array('Q2',   56,   73,		86),
-		array('Q3',   52,   61,		69),
-		array('Q4',   30,   32,		0),
-	)
+    array(
+        array('',	2010,	2011,	2012),
+        array('Q1',   12,   15,		21),
+        array('Q2',   56,   73,		86),
+        array('Q3',   52,   61,		69),
+        array('Q4',   30,   32,		0),
+    )
 );
 
 
@@ -61,7 +61,7 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesLabels1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $xAxisTickValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -81,17 +81,17 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
 );
 
 //	Build the dataseries
 $series1 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_PIECHART,				// plotType
-	NULL,			                                        // plotGrouping (Pie charts don't have any grouping)
-	range(0, count($dataSeriesValues1)-1),					// plotOrder
-	$dataSeriesLabels1,										// plotLabel
-	$xAxisTickValues1,										// plotCategory
-	$dataSeriesValues1										// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_PIECHART,				// plotType
+    NULL,			                                        // plotGrouping (Pie charts don't have any grouping)
+    range(0, count($dataSeriesValues1)-1),					// plotOrder
+    $dataSeriesLabels1,										// plotLabel
+    $xAxisTickValues1,										// plotCategory
+    $dataSeriesValues1										// plotValues
 );
 
 //	Set up a layout object for the Pie chart
@@ -109,14 +109,14 @@  discard block
 block discarded – undo
 
 //	Create the chart
 $chart1 = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title1,		// title
-	$legend1,		// legend
-	$plotArea1,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	NULL			// yAxisLabel		- Pie charts don't have a Y-Axis
+    'chart1',		// name
+    $title1,		// title
+    $legend1,		// legend
+    $plotArea1,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    NULL			// yAxisLabel		- Pie charts don't have a Y-Axis
 );
 
 //	Set the position where the chart should appear in the worksheet
@@ -135,7 +135,7 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesLabels2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -145,7 +145,7 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $xAxisTickValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -155,17 +155,17 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
 );
 
 //	Build the dataseries
 $series2 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_DONUTCHART,		// plotType
-	NULL,			                                // plotGrouping (Donut charts don't have any grouping)
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels2,								// plotLabel
-	$xAxisTickValues2,								// plotCategory
-	$dataSeriesValues2								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_DONUTCHART,		// plotType
+    NULL,			                                // plotGrouping (Donut charts don't have any grouping)
+    range(0, count($dataSeriesValues2)-1),			// plotOrder
+    $dataSeriesLabels2,								// plotLabel
+    $xAxisTickValues2,								// plotCategory
+    $dataSeriesValues2								// plotValues
 );
 
 //	Set up a layout object for the Pie chart
@@ -181,14 +181,14 @@  discard block
 block discarded – undo
 
 //	Create the chart
 $chart2 = new \PHPExcel\Chart(
-	'chart2',		// name
-	$title2,		// title
-	NULL,			// legend
-	$plotArea2,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	NULL			// yAxisLabel		- Like Pie charts, Donut charts don't have a Y-Axis
+    'chart2',		// name
+    $title2,		// title
+    NULL,			// legend
+    $plotArea2,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    NULL			// yAxisLabel		- Like Pie charts, Donut charts don't have a Y-Axis
 );
 
 //	Set the position where the chart should appear in the worksheet

Please login to merge, or discard this patch.

Examples/13calculation.php 1 patch

Indentation +85 added lines, -85 removed lines patch added patch discarded remove patch

@@ -52,142 +52,142 @@  discard block
 block discarded – undo
 // Add some data, we will use some formulas here
 echo date('H:i:s') , " Add some data and formulas" , EOL;
 $objPHPExcel->getActiveSheet()->setCellValue('A14', 'Count:')
-                              ->setCellValue('A15', 'Sum:')
-                              ->setCellValue('A16', 'Max:')
-                              ->setCellValue('A17', 'Min:')
-                              ->setCellValue('A18', 'Average:')
-                              ->setCellValue('A19', 'Median:')
-                              ->setCellValue('A20', 'Mode:');
+                                ->setCellValue('A15', 'Sum:')
+                                ->setCellValue('A16', 'Max:')
+                                ->setCellValue('A17', 'Min:')
+                                ->setCellValue('A18', 'Average:')
+                                ->setCellValue('A19', 'Median:')
+                                ->setCellValue('A20', 'Mode:');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A22', 'CountA:')
-                              ->setCellValue('A23', 'MaxA:')
-                              ->setCellValue('A24', 'MinA:');
+                                ->setCellValue('A23', 'MaxA:')
+                                ->setCellValue('A24', 'MinA:');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A26', 'StDev:')
-                              ->setCellValue('A27', 'StDevA:')
-                              ->setCellValue('A28', 'StDevP:')
-                              ->setCellValue('A29', 'StDevPA:');
+                                ->setCellValue('A27', 'StDevA:')
+                                ->setCellValue('A28', 'StDevP:')
+                                ->setCellValue('A29', 'StDevPA:');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A31', 'DevSq:')
-                              ->setCellValue('A32', 'Var:')
-                              ->setCellValue('A33', 'VarA:')
-                              ->setCellValue('A34', 'VarP:')
-                              ->setCellValue('A35', 'VarPA:');
+                                ->setCellValue('A32', 'Var:')
+                                ->setCellValue('A33', 'VarA:')
+                                ->setCellValue('A34', 'VarP:')
+                                ->setCellValue('A35', 'VarPA:');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A37', 'Date:');
 
 
 $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Range 1')
-                              ->setCellValue('B2', 2)
-                              ->setCellValue('B3', 8)
-                              ->setCellValue('B4', 10)
-                              ->setCellValue('B5', True)
-                              ->setCellValue('B6', False)
-                              ->setCellValue('B7', 'Text String')
-                              ->setCellValue('B9', '22')
-                              ->setCellValue('B10', 4)
-                              ->setCellValue('B11', 6)
-                              ->setCellValue('B12', 12);
+                                ->setCellValue('B2', 2)
+                                ->setCellValue('B3', 8)
+                                ->setCellValue('B4', 10)
+                                ->setCellValue('B5', True)
+                                ->setCellValue('B6', False)
+                                ->setCellValue('B7', 'Text String')
+                                ->setCellValue('B9', '22')
+                                ->setCellValue('B10', 4)
+                                ->setCellValue('B11', 6)
+                                ->setCellValue('B12', 12);
 
 $objPHPExcel->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)')
-                              ->setCellValue('B15', '=SUM(B2:B12)')
-                              ->setCellValue('B16', '=MAX(B2:B12)')
-                              ->setCellValue('B17', '=MIN(B2:B12)')
-                              ->setCellValue('B18', '=AVERAGE(B2:B12)')
-                              ->setCellValue('B19', '=MEDIAN(B2:B12)')
-                              ->setCellValue('B20', '=MODE(B2:B12)');
+                                ->setCellValue('B15', '=SUM(B2:B12)')
+                                ->setCellValue('B16', '=MAX(B2:B12)')
+                                ->setCellValue('B17', '=MIN(B2:B12)')
+                                ->setCellValue('B18', '=AVERAGE(B2:B12)')
+                                ->setCellValue('B19', '=MEDIAN(B2:B12)')
+                                ->setCellValue('B20', '=MODE(B2:B12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('B22', '=COUNTA(B2:B12)')
-                              ->setCellValue('B23', '=MAXA(B2:B12)')
-                              ->setCellValue('B24', '=MINA(B2:B12)');
+                                ->setCellValue('B23', '=MAXA(B2:B12)')
+                                ->setCellValue('B24', '=MINA(B2:B12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('B26', '=STDEV(B2:B12)')
-                              ->setCellValue('B27', '=STDEVA(B2:B12)')
-                              ->setCellValue('B28', '=STDEVP(B2:B12)')
-                              ->setCellValue('B29', '=STDEVPA(B2:B12)');
+                                ->setCellValue('B27', '=STDEVA(B2:B12)')
+                                ->setCellValue('B28', '=STDEVP(B2:B12)')
+                                ->setCellValue('B29', '=STDEVPA(B2:B12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('B31', '=DEVSQ(B2:B12)')
-                              ->setCellValue('B32', '=VAR(B2:B12)')
-                              ->setCellValue('B33', '=VARA(B2:B12)')
-                              ->setCellValue('B34', '=VARP(B2:B12)')
-                              ->setCellValue('B35', '=VARPA(B2:B12)');
+                                ->setCellValue('B32', '=VAR(B2:B12)')
+                                ->setCellValue('B33', '=VARA(B2:B12)')
+                                ->setCellValue('B34', '=VARP(B2:B12)')
+                                ->setCellValue('B35', '=VARPA(B2:B12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('B37', '=DATE(2007, 12, 21)')
-                              ->setCellValue('B38', '=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )')
-                              ->setCellValue('B39', '=DATEVALUE("01-Feb-2006 10:06 AM")')
-                              ->setCellValue('B40', '=DAY( DATE(2006, 1, 2) )')
-                              ->setCellValue('B41', '=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )');
+                                ->setCellValue('B38', '=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )')
+                                ->setCellValue('B39', '=DATEVALUE("01-Feb-2006 10:06 AM")')
+                                ->setCellValue('B40', '=DAY( DATE(2006, 1, 2) )')
+                                ->setCellValue('B41', '=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )');
 
 
 $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Range 2')
-                              ->setCellValue('C2', 1)
-                              ->setCellValue('C3', 2)
-                              ->setCellValue('C4', 2)
-                              ->setCellValue('C5', 3)
-                              ->setCellValue('C6', 3)
-                              ->setCellValue('C7', 3)
-                              ->setCellValue('C8', '0')
-                              ->setCellValue('C9', 4)
-                              ->setCellValue('C10', 4)
-                              ->setCellValue('C11', 4)
-                              ->setCellValue('C12', 4);
+                                ->setCellValue('C2', 1)
+                                ->setCellValue('C3', 2)
+                                ->setCellValue('C4', 2)
+                                ->setCellValue('C5', 3)
+                                ->setCellValue('C6', 3)
+                                ->setCellValue('C7', 3)
+                                ->setCellValue('C8', '0')
+                                ->setCellValue('C9', 4)
+                                ->setCellValue('C10', 4)
+                                ->setCellValue('C11', 4)
+                                ->setCellValue('C12', 4);
 
 $objPHPExcel->getActiveSheet()->setCellValue('C14', '=COUNT(C2:C12)')
-                              ->setCellValue('C15', '=SUM(C2:C12)')
-                              ->setCellValue('C16', '=MAX(C2:C12)')
-                              ->setCellValue('C17', '=MIN(C2:C12)')
-                              ->setCellValue('C18', '=AVERAGE(C2:C12)')
-                              ->setCellValue('C19', '=MEDIAN(C2:C12)')
-                              ->setCellValue('C20', '=MODE(C2:C12)');
+                                ->setCellValue('C15', '=SUM(C2:C12)')
+                                ->setCellValue('C16', '=MAX(C2:C12)')
+                                ->setCellValue('C17', '=MIN(C2:C12)')
+                                ->setCellValue('C18', '=AVERAGE(C2:C12)')
+                                ->setCellValue('C19', '=MEDIAN(C2:C12)')
+                                ->setCellValue('C20', '=MODE(C2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('C22', '=COUNTA(C2:C12)')
-                              ->setCellValue('C23', '=MAXA(C2:C12)')
-                              ->setCellValue('C24', '=MINA(C2:C12)');
+                                ->setCellValue('C23', '=MAXA(C2:C12)')
+                                ->setCellValue('C24', '=MINA(C2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('C26', '=STDEV(C2:C12)')
-                              ->setCellValue('C27', '=STDEVA(C2:C12)')
-                              ->setCellValue('C28', '=STDEVP(C2:C12)')
-                              ->setCellValue('C29', '=STDEVPA(C2:C12)');
+                                ->setCellValue('C27', '=STDEVA(C2:C12)')
+                                ->setCellValue('C28', '=STDEVP(C2:C12)')
+                                ->setCellValue('C29', '=STDEVPA(C2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('C31', '=DEVSQ(C2:C12)')
-                              ->setCellValue('C32', '=VAR(C2:C12)')
-                              ->setCellValue('C33', '=VARA(C2:C12)')
-                              ->setCellValue('C34', '=VARP(C2:C12)')
-                              ->setCellValue('C35', '=VARPA(C2:C12)');
+                                ->setCellValue('C32', '=VAR(C2:C12)')
+                                ->setCellValue('C33', '=VARA(C2:C12)')
+                                ->setCellValue('C34', '=VARP(C2:C12)')
+                                ->setCellValue('C35', '=VARPA(C2:C12)');
 
 
 $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Range 3')
-                              ->setCellValue('D2', 2)
-                              ->setCellValue('D3', 3)
-                              ->setCellValue('D4', 4);
+                                ->setCellValue('D2', 2)
+                                ->setCellValue('D3', 3)
+                                ->setCellValue('D4', 4);
 
 $objPHPExcel->getActiveSheet()->setCellValue('D14', '=((D2 * D3) + D4) & " should be 10"');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E12', 'Other functions')
-                              ->setCellValue('E14', '=PI()')
-                              ->setCellValue('E15', '=RAND()')
-                              ->setCellValue('E16', '=RANDBETWEEN(5, 10)');
+                                ->setCellValue('E14', '=PI()')
+                                ->setCellValue('E15', '=RAND()')
+                                ->setCellValue('E16', '=RANDBETWEEN(5, 10)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E17', 'Count of both ranges:')
-                              ->setCellValue('F17', '=COUNT(B2:C12)');
+                                ->setCellValue('F17', '=COUNT(B2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E18', 'Total of both ranges:')
-                              ->setCellValue('F18', '=SUM(B2:C12)');
+                                ->setCellValue('F18', '=SUM(B2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E19', 'Maximum of both ranges:')
-                              ->setCellValue('F19', '=MAX(B2:C12)');
+                                ->setCellValue('F19', '=MAX(B2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E20', 'Minimum of both ranges:')
-                              ->setCellValue('F20', '=MIN(B2:C12)');
+                                ->setCellValue('F20', '=MIN(B2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E21', 'Average of both ranges:')
-                              ->setCellValue('F21', '=AVERAGE(B2:C12)');
+                                ->setCellValue('F21', '=AVERAGE(B2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E22', 'Median of both ranges:')
-                              ->setCellValue('F22', '=MEDIAN(B2:C12)');
+                                ->setCellValue('F22', '=MEDIAN(B2:C12)');
 
 $objPHPExcel->getActiveSheet()->setCellValue('E23', 'Mode of both ranges:')
-                              ->setCellValue('F23', '=MODE(B2:C12)');
+                                ->setCellValue('F23', '=MODE(B2:C12)');
 
 
 // Calculated data
@@ -195,9 +195,9 @@  discard block
 block discarded – undo
 for ($col = 'B'; $col != 'G'; ++$col) {
     for($row = 14; $row <= 41; ++$row) {
         if ((!is_null($formula = $objPHPExcel->getActiveSheet()->getCell($col.$row)->getValue())) &&
-			($formula[0] == '=')) {
+            ($formula[0] == '=')) {
             echo 'Value of ' , $col , $row , ' [' , $formula , ']: ' ,
-                               $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL;
+                                $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL;
         }
     }
 }

Please login to merge, or discard this patch.

Examples/06largescale-with-cellcaching.php 1 patch

Indentation +14 added lines, -14 removed lines patch added patch discarded remove patch

@@ -39,7 +39,7 @@  discard block
 block discarded – undo
 
 $cacheMethod = \PHPExcel\CachedObjectStorageFactory::CACHE_IN_MEMORY_GZIP;
 if (!\PHPExcel\Settings::setCacheStorageMethod($cacheMethod)) {
-	die($cacheMethod . " caching method is not available" . EOL);
+    die($cacheMethod . " caching method is not available" . EOL);
 }
 echo date('H:i:s') , " Enable Cell Caching using " , $cacheMethod , " method" , EOL;
 
@@ -51,12 +51,12 @@  discard block
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Create a first sheet
@@ -78,8 +78,8 @@  discard block
 block discarded – undo
 // Set outline levels
 echo date('H:i:s') , " Set outline levels" , EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
-                                                       ->setVisible(false)
-                                                       ->setCollapsed(true);
+                                                        ->setVisible(false)
+                                                        ->setCollapsed(true);
 
 // Freeze panes
 echo date('H:i:s') , " Freeze panes" , EOL;
@@ -93,11 +93,11 @@  discard block
 block discarded – undo
 
 // Add data
 for ($i = 2; $i <= 5000; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
-	                              ->setCellValue('B' . $i, "LName $i")
-	                              ->setCellValue('C' . $i, "PhoneNo $i")
-	                              ->setCellValue('D' . $i, "FaxNo $i")
-	                              ->setCellValue('E' . $i, true);
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
+                                    ->setCellValue('B' . $i, "LName $i")
+                                    ->setCellValue('C' . $i, "PhoneNo $i")
+                                    ->setCellValue('D' . $i, "FaxNo $i")
+                                    ->setCellValue('E' . $i, true);
 }
 
 

Please login to merge, or discard this patch.

Examples/33chartcreate-area.php 1 patch

Indentation +28 added lines, -28 removed lines patch added patch discarded remove patch

@@ -43,13 +43,13 @@  discard block
 block discarded – undo
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',	2010,	2011,	2012),
-		array('Q1',   12,   15,		21),
-		array('Q2',   56,   73,		86),
-		array('Q3',   52,   61,		69),
-		array('Q4',   30,   32,		0),
-	)
+    array(
+        array('',	2010,	2011,	2012),
+        array('Q1',   12,   15,		21),
+        array('Q2',   56,   73,		86),
+        array('Q3',   52,   61,		69),
+        array('Q4',   30,   32,		0),
+    )
 );
 
 //	Set the Labels for each data series we want to plot
@@ -60,9 +60,9 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -82,19 +82,19 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesValues = 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),
+    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),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),					// plotOrder
-	$dataSeriesLabels,										// plotLabel
-	$xAxisTickValues,										// plotCategory
-	$dataSeriesValues										// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
+    range(0, count($dataSeriesValues)-1),					// plotOrder
+    $dataSeriesLabels,										// plotLabel
+    $xAxisTickValues,										// plotCategory
+    $dataSeriesValues										// plotValues
 );
 
 //	Set the series in the plot area
@@ -108,14 +108,14 @@  discard block
 block discarded – undo
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Please login to merge, or discard this patch.

Examples/26utf8.php 1 patch

Indentation +16 added lines, -16 removed lines patch added patch discarded remove patch

@@ -77,23 +77,23 @@
 block discarded – undo
 // Export to PDF (.pdf)
 echo date('H:i:s') , " Write to PDF format" , EOL;
 try {
-	if (!\PHPExcel\Settings::setPdfRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-		echo (
-			'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-			EOL .
-			'at the top of this script as appropriate for your directory structure' .
-			EOL
-		);
-	} else {
-		$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
-		$objWriter->save(str_replace('.php', '.pdf', __FILE__));
-		echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-	}
+    if (!\PHPExcel\Settings::setPdfRenderer(
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+        echo (
+            'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+            EOL .
+            'at the top of this script as appropriate for your directory structure' .
+            EOL
+        );
+    } else {
+        $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
+        $objWriter->save(str_replace('.php', '.pdf', __FILE__));
+        echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+    }
 } catch (Exception $e) {
-	echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL;
+    echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL;
 }
 
 // Remove first two rows with field headers before exporting to CSV

Please login to merge, or discard this patch.

Examples/06largescale-with-cellcaching-sqlite.php 1 patch

Indentation +13 added lines, -13 removed lines patch added patch discarded remove patch

@@ -52,12 +52,12 @@  discard block
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Create a first sheet
@@ -79,8 +79,8 @@  discard block
 block discarded – undo
 // Set outline levels
 echo date('H:i:s') , " Set outline levels" , EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
-                                                       ->setVisible(false)
-                                                       ->setCollapsed(true);
+                                                        ->setVisible(false)
+                                                        ->setCollapsed(true);
 
 // Freeze panes
 echo date('H:i:s') , " Freeze panes" , EOL;
@@ -94,11 +94,11 @@  discard block
 block discarded – undo
 
 // Add data
 for ($i = 2; $i <= 5000; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
-	                              ->setCellValue('B' . $i, "LName $i")
-	                              ->setCellValue('C' . $i, "PhoneNo $i")
-	                              ->setCellValue('D' . $i, "FaxNo $i")
-	                              ->setCellValue('E' . $i, true);
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
+                                    ->setCellValue('B' . $i, "LName $i")
+                                    ->setCellValue('C' . $i, "PhoneNo $i")
+                                    ->setCellValue('D' . $i, "FaxNo $i")
+                                    ->setCellValue('E' . $i, true);
 }
 
 

Please login to merge, or discard this patch.

Examples/33chartcreate-bar.php 1 patch

Indentation +28 added lines, -28 removed lines patch added patch discarded remove patch

@@ -43,13 +43,13 @@  discard block
 block discarded – undo
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',	2010,	2011,	2012),
-		array('Q1',   12,   15,		21),
-		array('Q2',   56,   73,		86),
-		array('Q3',   52,   61,		69),
-		array('Q4',   30,   32,		0),
-	)
+    array(
+        array('',	2010,	2011,	2012),
+        array('Q1',   12,   15,		21),
+        array('Q2',   56,   73,		86),
+        array('Q3',   52,   61,		69),
+        array('Q4',   30,   32,		0),
+    )
 );
 
 //	Set the Labels for each data series we want to plot
@@ -60,9 +60,9 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -82,19 +82,19 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesValues = 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),
+    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),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
+    range(0, count($dataSeriesValues)-1),			// plotOrder
+    $dataSeriesLabels,								// plotLabel
+    $xAxisTickValues,								// plotCategory
+    $dataSeriesValues								// plotValues
 );
 //	Set additional dataseries parameters
 //		Make it a horizontal bar rather than a vertical column graph
@@ -111,14 +111,14 @@  discard block
 block discarded – undo
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Please login to merge, or discard this patch.

Examples/37page_layout_view.php 1 patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

@@ -44,12 +44,12 @@
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("PHPOffice")
-							 ->setLastModifiedBy("PHPOffice")
-							 ->setTitle("PHPExcel Test Document")
-							 ->setSubject("PHPExcel Test Document")
-							 ->setDescription("Test document for PHPExcel, generated using PHP classes.")
-							 ->setKeywords("Office PHPExcel php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("PHPOffice")
+                                ->setTitle("PHPExcel Test Document")
+                                ->setSubject("PHPExcel Test Document")
+                                ->setDescription("Test document for PHPExcel, generated using PHP classes.")
+                                ->setKeywords("Office PHPExcel php")
+                                ->setCategory("Test result file");
 
 
 // Add some data

Please login to merge, or discard this patch.

		@@ -22,79 +22,79 @@
		block discarded – undo
22	22
23	23
24	24	if (!PHPExcel\Settings::setChartRenderer(
25		- $rendererName,
26		- $rendererLibraryPath
27		- )) {
28		- die(
29		- 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
30		- EOL .
31		- 'at the top of this script as appropriate for your directory structure'
32		- );
	25	+ $rendererName,
	26	+ $rendererLibraryPath
	27	+ )) {
	28	+ die(
	29	+ 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
	30	+ EOL .
	31	+ 'at the top of this script as appropriate for your directory structure'
	32	+ );
33	33	}
34	34
35	35
36	36	$inputFileType = 'Excel2007';
37	37	$inputFileNames = 'templates/32readwrite*[0-9].xlsx';
38	38
39		- if ((isset($argc)) && ($argc > 1)) {
40		- $inputFileNames = array();
41		- for($i = 1; $i < $argc; ++$i) {
42		- $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
43		- }
	39	+ if ((isset($argc)) && ($argc > 1)) {
	40	+ $inputFileNames = array();
	41	+ for($i = 1; $i < $argc; ++$i) {
	42	+ $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
	43	+ }
44	44	} else {
45		- $inputFileNames = glob($inputFileNames);
	45	+ $inputFileNames = glob($inputFileNames);
46	46	}
47	47	foreach($inputFileNames as $inputFileName) {
48		- $inputFileNameShort = basename($inputFileName);
49		-
50		- if (!file_exists($inputFileName)) {
51		- echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
52		- continue;
53		- }
54		-
55		- echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
56		-
57		- $objReader = \PHPExcel\IOFactory::createReader($inputFileType);
58		- $objReader->setIncludeCharts(TRUE);
59		- $objPHPExcel = $objReader->load($inputFileName);
60		-
61		-
62		- echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
63		- foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
64		- $sheetName = $worksheet->getTitle();
65		- echo 'Worksheet: ' , $sheetName , EOL;
66		-
67		- $chartNames = $worksheet->getChartNames();
68		- if(empty($chartNames)) {
69		- echo ' There are no charts in this worksheet' , EOL;
70		- } else {
71		- natsort($chartNames);
72		- foreach($chartNames as $i => $chartName) {
73		- $chart = $worksheet->getChartByName($chartName);
74		- if (!is_null($chart->getTitle())) {
75		- $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
76		- } else {
77		- $caption = 'Untitled';
78		- }
79		- echo ' ' , $chartName , ' - ' , $caption , EOL;
80		- echo str_repeat(' ',strlen($chartName)+3);
81		-
82		- $jpegFile = '35'.str_replace('.xlsx', '.jpg', substr($inputFileNameShort,2));
83		- if (file_exists($jpegFile)) {
84		- unlink($jpegFile);
85		- }
86		- try {
87		- $chart->render($jpegFile);
88		- } catch (Exception $e) {
89		- echo 'Error rendering chart: ',$e->getMessage();
90		- }
91		- }
92		- }
93		- }
94		-
95		-
96		- $objPHPExcel->disconnectWorksheets();
97		- unset($objPHPExcel);
	48	+ $inputFileNameShort = basename($inputFileName);
	49	+
	50	+ if (!file_exists($inputFileName)) {
	51	+ echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
	52	+ continue;
	53	+ }
	54	+
	55	+ echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
	56	+
	57	+ $objReader = \PHPExcel\IOFactory::createReader($inputFileType);
	58	+ $objReader->setIncludeCharts(TRUE);
	59	+ $objPHPExcel = $objReader->load($inputFileName);
	60	+
	61	+
	62	+ echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
	63	+ foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
	64	+ $sheetName = $worksheet->getTitle();
	65	+ echo 'Worksheet: ' , $sheetName , EOL;
	66	+
	67	+ $chartNames = $worksheet->getChartNames();
	68	+ if(empty($chartNames)) {
	69	+ echo ' There are no charts in this worksheet' , EOL;
	70	+ } else {
	71	+ natsort($chartNames);
	72	+ foreach($chartNames as $i => $chartName) {
	73	+ $chart = $worksheet->getChartByName($chartName);
	74	+ if (!is_null($chart->getTitle())) {
	75	+ $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
	76	+ } else {
	77	+ $caption = 'Untitled';
	78	+ }
	79	+ echo ' ' , $chartName , ' - ' , $caption , EOL;
	80	+ echo str_repeat(' ',strlen($chartName)+3);
	81	+
	82	+ $jpegFile = '35'.str_replace('.xlsx', '.jpg', substr($inputFileNameShort,2));
	83	+ if (file_exists($jpegFile)) {
	84	+ unlink($jpegFile);
	85	+ }
	86	+ try {
	87	+ $chart->render($jpegFile);
	88	+ } catch (Exception $e) {
	89	+ echo 'Error rendering chart: ',$e->getMessage();
	90	+ }
	91	+ }
	92	+ }
	93	+ }
	94	+
	95	+
	96	+ $objPHPExcel->disconnectWorksheets();
	97	+ unset($objPHPExcel);
98	98	}
99	99
100	100	// Echo memory peak usage

		@@ -43,13 +43,13 @@ discard block
		block discarded – undo
43	43	$objPHPExcel = new \PHPExcel\Spreadsheet();
44	44	$objWorksheet = $objPHPExcel->getActiveSheet();
45	45	$objWorksheet->fromArray(
46		- array(
47		- array('', 2010, 2011, 2012),
48		- array('Q1', 12, 15, 21),
49		- array('Q2', 56, 73, 86),
50		- array('Q3', 52, 61, 69),
51		- array('Q4', 30, 32, 0),
52		- )
	46	+ array(
	47	+ array('', 2010, 2011, 2012),
	48	+ array('Q1', 12, 15, 21),
	49	+ array('Q2', 56, 73, 86),
	50	+ array('Q3', 52, 61, 69),
	51	+ array('Q4', 30, 32, 0),
	52	+ )
53	53	);
54	54
55	55
		@@ -61,7 +61,7 @@ discard block
		block discarded – undo
61	61	// Data values
62	62	// Data Marker
63	63	$dataSeriesLabels1 = array(
64		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
	64	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
65	65	);
66	66	// Set the X-Axis Labels
67	67	// Datatype
		@@ -71,7 +71,7 @@ discard block
		block discarded – undo
71	71	// Data values
72	72	// Data Marker
73	73	$xAxisTickValues1 = array(
74		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4
	74	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4
75	75	);
76	76	// Set the Data values for each data series we want to plot
77	77	// Datatype
		@@ -81,17 +81,17 @@ discard block
		block discarded – undo
81	81	// Data values
82	82	// Data Marker
83	83	$dataSeriesValues1 = array(
84		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
	84	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
85	85	);
86	86
87	87	// Build the dataseries
88	88	$series1 = new \PHPExcel\Chart\DataSeries(
89		- \PHPExcel\Chart\DataSeries::TYPE_PIECHART, // plotType
90		- NULL, // plotGrouping (Pie charts don't have any grouping)
91		- range(0, count($dataSeriesValues1)-1), // plotOrder
92		- $dataSeriesLabels1, // plotLabel
93		- $xAxisTickValues1, // plotCategory
94		- $dataSeriesValues1 // plotValues
	89	+ \PHPExcel\Chart\DataSeries::TYPE_PIECHART, // plotType
	90	+ NULL, // plotGrouping (Pie charts don't have any grouping)
	91	+ range(0, count($dataSeriesValues1)-1), // plotOrder
	92	+ $dataSeriesLabels1, // plotLabel
	93	+ $xAxisTickValues1, // plotCategory
	94	+ $dataSeriesValues1 // plotValues
95	95	);
96	96
97	97	// Set up a layout object for the Pie chart
		@@ -109,14 +109,14 @@ discard block
		block discarded – undo
109	109
110	110	// Create the chart
111	111	$chart1 = new \PHPExcel\Chart(
112		- 'chart1', // name
113		- $title1, // title
114		- $legend1, // legend
115		- $plotArea1, // plotArea
116		- true, // plotVisibleOnly
117		- 0, // displayBlanksAs
118		- NULL, // xAxisLabel
119		- NULL // yAxisLabel - Pie charts don't have a Y-Axis
	112	+ 'chart1', // name
	113	+ $title1, // title
	114	+ $legend1, // legend
	115	+ $plotArea1, // plotArea
	116	+ true, // plotVisibleOnly
	117	+ 0, // displayBlanksAs
	118	+ NULL, // xAxisLabel
	119	+ NULL // yAxisLabel - Pie charts don't have a Y-Axis
120	120	);
121	121
122	122	// Set the position where the chart should appear in the worksheet
		@@ -135,7 +135,7 @@ discard block
		block discarded – undo
135	135	// Data values
136	136	// Data Marker
137	137	$dataSeriesLabels2 = array(
138		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
	138	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
139	139	);
140	140	// Set the X-Axis Labels
141	141	// Datatype
		@@ -145,7 +145,7 @@ discard block
		block discarded – undo
145	145	// Data values
146	146	// Data Marker
147	147	$xAxisTickValues2 = array(
148		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4
	148	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4
149	149	);
150	150	// Set the Data values for each data series we want to plot
151	151	// Datatype
		@@ -155,17 +155,17 @@ discard block
		block discarded – undo
155	155	// Data values
156	156	// Data Marker
157	157	$dataSeriesValues2 = array(
158		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
	158	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
159	159	);
160	160
161	161	// Build the dataseries
162	162	$series2 = new \PHPExcel\Chart\DataSeries(
163		- \PHPExcel\Chart\DataSeries::TYPE_DONUTCHART, // plotType
164		- NULL, // plotGrouping (Donut charts don't have any grouping)
165		- range(0, count($dataSeriesValues2)-1), // plotOrder
166		- $dataSeriesLabels2, // plotLabel
167		- $xAxisTickValues2, // plotCategory
168		- $dataSeriesValues2 // plotValues
	163	+ \PHPExcel\Chart\DataSeries::TYPE_DONUTCHART, // plotType
	164	+ NULL, // plotGrouping (Donut charts don't have any grouping)
	165	+ range(0, count($dataSeriesValues2)-1), // plotOrder
	166	+ $dataSeriesLabels2, // plotLabel
	167	+ $xAxisTickValues2, // plotCategory
	168	+ $dataSeriesValues2 // plotValues
169	169	);
170	170
171	171	// Set up a layout object for the Pie chart
		@@ -181,14 +181,14 @@ discard block
		block discarded – undo
181	181
182	182	// Create the chart
183	183	$chart2 = new \PHPExcel\Chart(
184		- 'chart2', // name
185		- $title2, // title
186		- NULL, // legend
187		- $plotArea2, // plotArea
188		- true, // plotVisibleOnly
189		- 0, // displayBlanksAs
190		- NULL, // xAxisLabel
191		- NULL // yAxisLabel - Like Pie charts, Donut charts don't have a Y-Axis
	184	+ 'chart2', // name
	185	+ $title2, // title
	186	+ NULL, // legend
	187	+ $plotArea2, // plotArea
	188	+ true, // plotVisibleOnly
	189	+ 0, // displayBlanksAs
	190	+ NULL, // xAxisLabel
	191	+ NULL // yAxisLabel - Like Pie charts, Donut charts don't have a Y-Axis
192	192	);
193	193
194	194	// Set the position where the chart should appear in the worksheet

		@@ -52,142 +52,142 @@ discard block
		block discarded – undo
52	52	// Add some data, we will use some formulas here
53	53	echo date('H:i:s') , " Add some data and formulas" , EOL;
54	54	$objPHPExcel->getActiveSheet()->setCellValue('A14', 'Count:')
55		- ->setCellValue('A15', 'Sum:')
56		- ->setCellValue('A16', 'Max:')
57		- ->setCellValue('A17', 'Min:')
58		- ->setCellValue('A18', 'Average:')
59		- ->setCellValue('A19', 'Median:')
60		- ->setCellValue('A20', 'Mode:');
	55	+ ->setCellValue('A15', 'Sum:')
	56	+ ->setCellValue('A16', 'Max:')
	57	+ ->setCellValue('A17', 'Min:')
	58	+ ->setCellValue('A18', 'Average:')
	59	+ ->setCellValue('A19', 'Median:')
	60	+ ->setCellValue('A20', 'Mode:');
61	61
62	62	$objPHPExcel->getActiveSheet()->setCellValue('A22', 'CountA:')
63		- ->setCellValue('A23', 'MaxA:')
64		- ->setCellValue('A24', 'MinA:');
	63	+ ->setCellValue('A23', 'MaxA:')
	64	+ ->setCellValue('A24', 'MinA:');
65	65
66	66	$objPHPExcel->getActiveSheet()->setCellValue('A26', 'StDev:')
67		- ->setCellValue('A27', 'StDevA:')
68		- ->setCellValue('A28', 'StDevP:')
69		- ->setCellValue('A29', 'StDevPA:');
	67	+ ->setCellValue('A27', 'StDevA:')
	68	+ ->setCellValue('A28', 'StDevP:')
	69	+ ->setCellValue('A29', 'StDevPA:');
70	70
71	71	$objPHPExcel->getActiveSheet()->setCellValue('A31', 'DevSq:')
72		- ->setCellValue('A32', 'Var:')
73		- ->setCellValue('A33', 'VarA:')
74		- ->setCellValue('A34', 'VarP:')
75		- ->setCellValue('A35', 'VarPA:');
	72	+ ->setCellValue('A32', 'Var:')
	73	+ ->setCellValue('A33', 'VarA:')
	74	+ ->setCellValue('A34', 'VarP:')
	75	+ ->setCellValue('A35', 'VarPA:');
76	76
77	77	$objPHPExcel->getActiveSheet()->setCellValue('A37', 'Date:');
78	78
79	79
80	80	$objPHPExcel->getActiveSheet()->setCellValue('B1', 'Range 1')
81		- ->setCellValue('B2', 2)
82		- ->setCellValue('B3', 8)
83		- ->setCellValue('B4', 10)
84		- ->setCellValue('B5', True)
85		- ->setCellValue('B6', False)
86		- ->setCellValue('B7', 'Text String')
87		- ->setCellValue('B9', '22')
88		- ->setCellValue('B10', 4)
89		- ->setCellValue('B11', 6)
90		- ->setCellValue('B12', 12);
	81	+ ->setCellValue('B2', 2)
	82	+ ->setCellValue('B3', 8)
	83	+ ->setCellValue('B4', 10)
	84	+ ->setCellValue('B5', True)
	85	+ ->setCellValue('B6', False)
	86	+ ->setCellValue('B7', 'Text String')
	87	+ ->setCellValue('B9', '22')
	88	+ ->setCellValue('B10', 4)
	89	+ ->setCellValue('B11', 6)
	90	+ ->setCellValue('B12', 12);
91	91
92	92	$objPHPExcel->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)')
93		- ->setCellValue('B15', '=SUM(B2:B12)')
94		- ->setCellValue('B16', '=MAX(B2:B12)')
95		- ->setCellValue('B17', '=MIN(B2:B12)')
96		- ->setCellValue('B18', '=AVERAGE(B2:B12)')
97		- ->setCellValue('B19', '=MEDIAN(B2:B12)')
98		- ->setCellValue('B20', '=MODE(B2:B12)');
	93	+ ->setCellValue('B15', '=SUM(B2:B12)')
	94	+ ->setCellValue('B16', '=MAX(B2:B12)')
	95	+ ->setCellValue('B17', '=MIN(B2:B12)')
	96	+ ->setCellValue('B18', '=AVERAGE(B2:B12)')
	97	+ ->setCellValue('B19', '=MEDIAN(B2:B12)')
	98	+ ->setCellValue('B20', '=MODE(B2:B12)');
99	99
100	100	$objPHPExcel->getActiveSheet()->setCellValue('B22', '=COUNTA(B2:B12)')
101		- ->setCellValue('B23', '=MAXA(B2:B12)')
102		- ->setCellValue('B24', '=MINA(B2:B12)');
	101	+ ->setCellValue('B23', '=MAXA(B2:B12)')
	102	+ ->setCellValue('B24', '=MINA(B2:B12)');
103	103
104	104	$objPHPExcel->getActiveSheet()->setCellValue('B26', '=STDEV(B2:B12)')
105		- ->setCellValue('B27', '=STDEVA(B2:B12)')
106		- ->setCellValue('B28', '=STDEVP(B2:B12)')
107		- ->setCellValue('B29', '=STDEVPA(B2:B12)');
	105	+ ->setCellValue('B27', '=STDEVA(B2:B12)')
	106	+ ->setCellValue('B28', '=STDEVP(B2:B12)')
	107	+ ->setCellValue('B29', '=STDEVPA(B2:B12)');
108	108
109	109	$objPHPExcel->getActiveSheet()->setCellValue('B31', '=DEVSQ(B2:B12)')
110		- ->setCellValue('B32', '=VAR(B2:B12)')
111		- ->setCellValue('B33', '=VARA(B2:B12)')
112		- ->setCellValue('B34', '=VARP(B2:B12)')
113		- ->setCellValue('B35', '=VARPA(B2:B12)');
	110	+ ->setCellValue('B32', '=VAR(B2:B12)')
	111	+ ->setCellValue('B33', '=VARA(B2:B12)')
	112	+ ->setCellValue('B34', '=VARP(B2:B12)')
	113	+ ->setCellValue('B35', '=VARPA(B2:B12)');
114	114
115	115	$objPHPExcel->getActiveSheet()->setCellValue('B37', '=DATE(2007, 12, 21)')
116		- ->setCellValue('B38', '=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )')
117		- ->setCellValue('B39', '=DATEVALUE("01-Feb-2006 10:06 AM")')
118		- ->setCellValue('B40', '=DAY( DATE(2006, 1, 2) )')
119		- ->setCellValue('B41', '=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )');
	116	+ ->setCellValue('B38', '=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )')
	117	+ ->setCellValue('B39', '=DATEVALUE("01-Feb-2006 10:06 AM")')
	118	+ ->setCellValue('B40', '=DAY( DATE(2006, 1, 2) )')
	119	+ ->setCellValue('B41', '=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )');
120	120
121	121
122	122	$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Range 2')
123		- ->setCellValue('C2', 1)
124		- ->setCellValue('C3', 2)
125		- ->setCellValue('C4', 2)
126		- ->setCellValue('C5', 3)
127		- ->setCellValue('C6', 3)
128		- ->setCellValue('C7', 3)
129		- ->setCellValue('C8', '0')
130		- ->setCellValue('C9', 4)
131		- ->setCellValue('C10', 4)
132		- ->setCellValue('C11', 4)
133		- ->setCellValue('C12', 4);
	123	+ ->setCellValue('C2', 1)
	124	+ ->setCellValue('C3', 2)
	125	+ ->setCellValue('C4', 2)
	126	+ ->setCellValue('C5', 3)
	127	+ ->setCellValue('C6', 3)
	128	+ ->setCellValue('C7', 3)
	129	+ ->setCellValue('C8', '0')
	130	+ ->setCellValue('C9', 4)
	131	+ ->setCellValue('C10', 4)
	132	+ ->setCellValue('C11', 4)
	133	+ ->setCellValue('C12', 4);
134	134
135	135	$objPHPExcel->getActiveSheet()->setCellValue('C14', '=COUNT(C2:C12)')
136		- ->setCellValue('C15', '=SUM(C2:C12)')
137		- ->setCellValue('C16', '=MAX(C2:C12)')
138		- ->setCellValue('C17', '=MIN(C2:C12)')
139		- ->setCellValue('C18', '=AVERAGE(C2:C12)')
140		- ->setCellValue('C19', '=MEDIAN(C2:C12)')
141		- ->setCellValue('C20', '=MODE(C2:C12)');
	136	+ ->setCellValue('C15', '=SUM(C2:C12)')
	137	+ ->setCellValue('C16', '=MAX(C2:C12)')
	138	+ ->setCellValue('C17', '=MIN(C2:C12)')
	139	+ ->setCellValue('C18', '=AVERAGE(C2:C12)')
	140	+ ->setCellValue('C19', '=MEDIAN(C2:C12)')
	141	+ ->setCellValue('C20', '=MODE(C2:C12)');
142	142
143	143	$objPHPExcel->getActiveSheet()->setCellValue('C22', '=COUNTA(C2:C12)')
144		- ->setCellValue('C23', '=MAXA(C2:C12)')
145		- ->setCellValue('C24', '=MINA(C2:C12)');
	144	+ ->setCellValue('C23', '=MAXA(C2:C12)')
	145	+ ->setCellValue('C24', '=MINA(C2:C12)');
146	146
147	147	$objPHPExcel->getActiveSheet()->setCellValue('C26', '=STDEV(C2:C12)')
148		- ->setCellValue('C27', '=STDEVA(C2:C12)')
149		- ->setCellValue('C28', '=STDEVP(C2:C12)')
150		- ->setCellValue('C29', '=STDEVPA(C2:C12)');
	148	+ ->setCellValue('C27', '=STDEVA(C2:C12)')
	149	+ ->setCellValue('C28', '=STDEVP(C2:C12)')
	150	+ ->setCellValue('C29', '=STDEVPA(C2:C12)');
151	151
152	152	$objPHPExcel->getActiveSheet()->setCellValue('C31', '=DEVSQ(C2:C12)')
153		- ->setCellValue('C32', '=VAR(C2:C12)')
154		- ->setCellValue('C33', '=VARA(C2:C12)')
155		- ->setCellValue('C34', '=VARP(C2:C12)')
156		- ->setCellValue('C35', '=VARPA(C2:C12)');
	153	+ ->setCellValue('C32', '=VAR(C2:C12)')
	154	+ ->setCellValue('C33', '=VARA(C2:C12)')
	155	+ ->setCellValue('C34', '=VARP(C2:C12)')
	156	+ ->setCellValue('C35', '=VARPA(C2:C12)');
157	157
158	158
159	159	$objPHPExcel->getActiveSheet()->setCellValue('D1', 'Range 3')
160		- ->setCellValue('D2', 2)
161		- ->setCellValue('D3', 3)
162		- ->setCellValue('D4', 4);
	160	+ ->setCellValue('D2', 2)
	161	+ ->setCellValue('D3', 3)
	162	+ ->setCellValue('D4', 4);
163	163
164	164	$objPHPExcel->getActiveSheet()->setCellValue('D14', '=((D2 * D3) + D4) & " should be 10"');
165	165
166	166	$objPHPExcel->getActiveSheet()->setCellValue('E12', 'Other functions')
167		- ->setCellValue('E14', '=PI()')
168		- ->setCellValue('E15', '=RAND()')
169		- ->setCellValue('E16', '=RANDBETWEEN(5, 10)');
	167	+ ->setCellValue('E14', '=PI()')
	168	+ ->setCellValue('E15', '=RAND()')
	169	+ ->setCellValue('E16', '=RANDBETWEEN(5, 10)');
170	170
171	171	$objPHPExcel->getActiveSheet()->setCellValue('E17', 'Count of both ranges:')
172		- ->setCellValue('F17', '=COUNT(B2:C12)');
	172	+ ->setCellValue('F17', '=COUNT(B2:C12)');
173	173
174	174	$objPHPExcel->getActiveSheet()->setCellValue('E18', 'Total of both ranges:')
175		- ->setCellValue('F18', '=SUM(B2:C12)');
	175	+ ->setCellValue('F18', '=SUM(B2:C12)');
176	176
177	177	$objPHPExcel->getActiveSheet()->setCellValue('E19', 'Maximum of both ranges:')
178		- ->setCellValue('F19', '=MAX(B2:C12)');
	178	+ ->setCellValue('F19', '=MAX(B2:C12)');
179	179
180	180	$objPHPExcel->getActiveSheet()->setCellValue('E20', 'Minimum of both ranges:')
181		- ->setCellValue('F20', '=MIN(B2:C12)');
	181	+ ->setCellValue('F20', '=MIN(B2:C12)');
182	182
183	183	$objPHPExcel->getActiveSheet()->setCellValue('E21', 'Average of both ranges:')
184		- ->setCellValue('F21', '=AVERAGE(B2:C12)');
	184	+ ->setCellValue('F21', '=AVERAGE(B2:C12)');
185	185
186	186	$objPHPExcel->getActiveSheet()->setCellValue('E22', 'Median of both ranges:')
187		- ->setCellValue('F22', '=MEDIAN(B2:C12)');
	187	+ ->setCellValue('F22', '=MEDIAN(B2:C12)');
188	188
189	189	$objPHPExcel->getActiveSheet()->setCellValue('E23', 'Mode of both ranges:')
190		- ->setCellValue('F23', '=MODE(B2:C12)');
	190	+ ->setCellValue('F23', '=MODE(B2:C12)');
191	191
192	192
193	193	// Calculated data
		@@ -195,9 +195,9 @@ discard block
		block discarded – undo
195	195	for ($col = 'B'; $col != 'G'; ++$col) {
196	196	for($row = 14; $row <= 41; ++$row) {
197	197	if ((!is_null($formula = $objPHPExcel->getActiveSheet()->getCell($col.$row)->getValue())) &&
198		- ($formula[0] == '=')) {
	198	+ ($formula[0] == '=')) {
199	199	echo 'Value of ' , $col , $row , ' [' , $formula , ']: ' ,
200		- $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL;
	200	+ $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL;
201	201	}
202	202	}
203	203	}

		@@ -39,7 +39,7 @@ discard block
		block discarded – undo
39	39
40	40	$cacheMethod = \PHPExcel\CachedObjectStorageFactory::CACHE_IN_MEMORY_GZIP;
41	41	if (!\PHPExcel\Settings::setCacheStorageMethod($cacheMethod)) {
42		- die($cacheMethod . " caching method is not available" . EOL);
	42	+ die($cacheMethod . " caching method is not available" . EOL);
43	43	}
44	44	echo date('H:i:s') , " Enable Cell Caching using " , $cacheMethod , " method" , EOL;
45	45
		@@ -51,12 +51,12 @@ discard block
		block discarded – undo
51	51	// Set document properties
52	52	echo date('H:i:s') , " Set properties" , EOL;
53	53	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
54		- ->setLastModifiedBy("Maarten Balliauw")
55		- ->setTitle("Office 2007 XLSX Test Document")
56		- ->setSubject("Office 2007 XLSX Test Document")
57		- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
58		- ->setKeywords("office 2007 openxml php")
59		- ->setCategory("Test result file");
	54	+ ->setLastModifiedBy("Maarten Balliauw")
	55	+ ->setTitle("Office 2007 XLSX Test Document")
	56	+ ->setSubject("Office 2007 XLSX Test Document")
	57	+ ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
	58	+ ->setKeywords("office 2007 openxml php")
	59	+ ->setCategory("Test result file");
60	60
61	61
62	62	// Create a first sheet
		@@ -78,8 +78,8 @@ discard block
		block discarded – undo
78	78	// Set outline levels
79	79	echo date('H:i:s') , " Set outline levels" , EOL;
80	80	$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
81		- ->setVisible(false)
82		- ->setCollapsed(true);
	81	+ ->setVisible(false)
	82	+ ->setCollapsed(true);
83	83
84	84	// Freeze panes
85	85	echo date('H:i:s') , " Freeze panes" , EOL;
		@@ -93,11 +93,11 @@ discard block
		block discarded – undo
93	93
94	94	// Add data
95	95	for ($i = 2; $i <= 5000; $i++) {
96		- $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
97		- ->setCellValue('B' . $i, "LName $i")
98		- ->setCellValue('C' . $i, "PhoneNo $i")
99		- ->setCellValue('D' . $i, "FaxNo $i")
100		- ->setCellValue('E' . $i, true);
	96	+ $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
	97	+ ->setCellValue('B' . $i, "LName $i")
	98	+ ->setCellValue('C' . $i, "PhoneNo $i")
	99	+ ->setCellValue('D' . $i, "FaxNo $i")
	100	+ ->setCellValue('E' . $i, true);
101	101	}
102	102
103	103

		@@ -77,23 +77,23 @@
		block discarded – undo
77	77	// Export to PDF (.pdf)
78	78	echo date('H:i:s') , " Write to PDF format" , EOL;
79	79	try {
80		- if (!\PHPExcel\Settings::setPdfRenderer(
81		- $rendererName,
82		- $rendererLibraryPath
83		- )) {
84		- echo (
85		- 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
86		- EOL .
87		- 'at the top of this script as appropriate for your directory structure' .
88		- EOL
89		- );
90		- } else {
91		- $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
92		- $objWriter->save(str_replace('.php', '.pdf', __FILE__));
93		- echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
94		- }
	80	+ if (!\PHPExcel\Settings::setPdfRenderer(
	81	+ $rendererName,
	82	+ $rendererLibraryPath
	83	+ )) {
	84	+ echo (
	85	+ 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
	86	+ EOL .
	87	+ 'at the top of this script as appropriate for your directory structure' .
	88	+ EOL
	89	+ );
	90	+ } else {
	91	+ $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
	92	+ $objWriter->save(str_replace('.php', '.pdf', __FILE__));
	93	+ echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
	94	+ }
95	95	} catch (Exception $e) {
96		- echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL;
	96	+ echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL;
97	97	}
98	98
99	99	// Remove first two rows with field headers before exporting to CSV

		@@ -52,12 +52,12 @@ discard block
		block discarded – undo
52	52	// Set document properties
53	53	echo date('H:i:s') , " Set properties" , EOL;
54	54	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
55		- ->setLastModifiedBy("Maarten Balliauw")
56		- ->setTitle("Office 2007 XLSX Test Document")
57		- ->setSubject("Office 2007 XLSX Test Document")
58		- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
59		- ->setKeywords("office 2007 openxml php")
60		- ->setCategory("Test result file");
	55	+ ->setLastModifiedBy("Maarten Balliauw")
	56	+ ->setTitle("Office 2007 XLSX Test Document")
	57	+ ->setSubject("Office 2007 XLSX Test Document")
	58	+ ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
	59	+ ->setKeywords("office 2007 openxml php")
	60	+ ->setCategory("Test result file");
61	61
62	62
63	63	// Create a first sheet
		@@ -79,8 +79,8 @@ discard block
		block discarded – undo
79	79	// Set outline levels
80	80	echo date('H:i:s') , " Set outline levels" , EOL;
81	81	$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
82		- ->setVisible(false)
83		- ->setCollapsed(true);
	82	+ ->setVisible(false)
	83	+ ->setCollapsed(true);
84	84
85	85	// Freeze panes
86	86	echo date('H:i:s') , " Freeze panes" , EOL;
		@@ -94,11 +94,11 @@ discard block
		block discarded – undo
94	94
95	95	// Add data
96	96	for ($i = 2; $i <= 5000; $i++) {
97		- $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
98		- ->setCellValue('B' . $i, "LName $i")
99		- ->setCellValue('C' . $i, "PhoneNo $i")
100		- ->setCellValue('D' . $i, "FaxNo $i")
101		- ->setCellValue('E' . $i, true);
	97	+ $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
	98	+ ->setCellValue('B' . $i, "LName $i")
	99	+ ->setCellValue('C' . $i, "PhoneNo $i")
	100	+ ->setCellValue('D' . $i, "FaxNo $i")
	101	+ ->setCellValue('E' . $i, true);
102	102	}
103	103
104	104

		@@ -44,12 +44,12 @@
		block discarded – undo
44	44	// Set document properties
45	45	echo date('H:i:s') , " Set document properties" , EOL;
46	46	$objPHPExcel->getProperties()->setCreator("PHPOffice")
47		- ->setLastModifiedBy("PHPOffice")
48		- ->setTitle("PHPExcel Test Document")
49		- ->setSubject("PHPExcel Test Document")
50		- ->setDescription("Test document for PHPExcel, generated using PHP classes.")
51		- ->setKeywords("Office PHPExcel php")
52		- ->setCategory("Test result file");
	47	+ ->setLastModifiedBy("PHPOffice")
	48	+ ->setTitle("PHPExcel Test Document")
	49	+ ->setSubject("PHPExcel Test Document")
	50	+ ->setDescription("Test document for PHPExcel, generated using PHP classes.")
	51	+ ->setKeywords("Office PHPExcel php")
	52	+ ->setCategory("Test result file");
53	53
54	54
55	55	// Add some data

PHPOffice / PhpSpreadsheet

Push — develop ( 942ad7...b0621f )

Status

Category

Indentation +64 added lines, -64 removed lines patch added patch discarded remove patch

Indentation +41 added lines, -41 removed lines patch added patch discarded remove patch

Indentation +85 added lines, -85 removed lines patch added patch discarded remove patch

Indentation +14 added lines, -14 removed lines patch added patch discarded remove patch

Indentation +28 added lines, -28 removed lines patch added patch discarded remove patch

Indentation +16 added lines, -16 removed lines patch added patch discarded remove patch

Indentation +13 added lines, -13 removed lines patch added patch discarded remove patch

Indentation +28 added lines, -28 removed lines patch added patch discarded remove patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch