PHPOffice / PhpSpreadsheet

Examples/GnumericReader.php

Spacing +7 added lines, -7 removed lines

@@ -33,7 +33,7 @@ 
 /** \PHPExcel\IOFactory */

 require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php';

 

-echo date('H:i:s') , " Load from Gnumeric file" , PHP_EOL;

+echo date('H:i:s'), " Load from Gnumeric file", PHP_EOL;

 $callStartTime = microtime(true);

 

 $objReader = \PHPExcel\IOFactory::createReader('Gnumeric');

@@ -42,19 +42,19 @@ 
 

 $callEndTime = microtime(true);

 $callTime = $callEndTime - $callStartTime;

-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , PHP_EOL;

+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", PHP_EOL;

 // Echo memory usage

-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;

+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", PHP_EOL;

 

 

-echo date('H:i:s') , " Write to Excel2007 format" , PHP_EOL;

+echo date('H:i:s'), " Write to Excel2007 format", PHP_EOL;

 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');

 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));

-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', __FILE__) , PHP_EOL;

+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', __FILE__), PHP_EOL;

 

 

 // Echo memory peak usage

-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;

+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", PHP_EOL;

 

 // Echo done

-echo date('H:i:s') , " Done writing file" , PHP_EOL;

+echo date('H:i:s'), " Done writing file", PHP_EOL;

Examples/Quadratic.php

Indentation +21 added lines, -21 removed lines

@@ -33,33 +33,33 @@
 <?php

 /**	If the user has submitted the form, then we need to execute a calculation **/

 if (isset($_POST['submit'])) {

-	if ($_POST['A'] == 0) {

-		echo 'The equation is not quadratic';

-	} else {

-		/**	So we include PHPExcel to perform the calculations	**/

-		include 'PHPExcel/IOFactory.php';

+    if ($_POST['A'] == 0) {

+        echo 'The equation is not quadratic';

+    } else {

+        /**	So we include PHPExcel to perform the calculations	**/

+        include 'PHPExcel/IOFactory.php';

 

-		/**	Load the quadratic equation solver worksheet into memory			**/

-		$objPHPExcel = \PHPExcel\IOFactory::load('./Quadratic.xlsx');

+        /**	Load the quadratic equation solver worksheet into memory			**/

+        $objPHPExcel = \PHPExcel\IOFactory::load('./Quadratic.xlsx');

 

-		/**	Set our A, B and C values			**/

-		$objPHPExcel->getActiveSheet()->setCellValue('A1', $_POST['A']);

-		$objPHPExcel->getActiveSheet()->setCellValue('B1', $_POST['B']);

-		$objPHPExcel->getActiveSheet()->setCellValue('C1', $_POST['C']);

+        /**	Set our A, B and C values			**/

+        $objPHPExcel->getActiveSheet()->setCellValue('A1', $_POST['A']);

+        $objPHPExcel->getActiveSheet()->setCellValue('B1', $_POST['B']);

+        $objPHPExcel->getActiveSheet()->setCellValue('C1', $_POST['C']);

 

 

-		/**	Calculate and Display the results			**/

-		echo '<hr /><b>Roots:</b><br />';

+        /**	Calculate and Display the results			**/

+        echo '<hr /><b>Roots:</b><br />';

 

-		$callStartTime = microtime(true);

-		echo $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue().'<br />';

-		echo $objPHPExcel->getActiveSheet()->getCell('B6')->getCalculatedValue().'<br />';

-		$callEndTime = microtime(true);

-		$callTime = $callEndTime - $callStartTime;

+        $callStartTime = microtime(true);

+        echo $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue().'<br />';

+        echo $objPHPExcel->getActiveSheet()->getCell('B6')->getCalculatedValue().'<br />';

+        $callEndTime = microtime(true);

+        $callTime = $callEndTime - $callStartTime;

 

-		echo '<hr />Call time for Quadratic Equation Solution was '.sprintf('%.4f',$callTime).' seconds<br /><hr />';

-		echo ' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB<br />';

-	}

+        echo '<hr />Call time for Quadratic Equation Solution was '.sprintf('%.4f',$callTime).' seconds<br /><hr />';

+        echo ' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB<br />';

+    }

 }

 

 ?>

Spacing +4 added lines, -4 removed lines

@@ -52,13 +52,13 @@
 		echo '<hr /><b>Roots:</b><br />';

 

 		$callStartTime = microtime(true);

-		echo $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue().'<br />';

-		echo $objPHPExcel->getActiveSheet()->getCell('B6')->getCalculatedValue().'<br />';

+		echo $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue() . '<br />';

+		echo $objPHPExcel->getActiveSheet()->getCell('B6')->getCalculatedValue() . '<br />';

 		$callEndTime = microtime(true);

 		$callTime = $callEndTime - $callStartTime;

 

-		echo '<hr />Call time for Quadratic Equation Solution was '.sprintf('%.4f',$callTime).' seconds<br /><hr />';

-		echo ' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB<br />';

+		echo '<hr />Call time for Quadratic Equation Solution was ' . sprintf('%.4f', $callTime) . ' seconds<br /><hr />';

+		echo ' Peak memory usage: ' . (memory_get_peak_usage(true) / 1024 / 1024) . ' MB<br />';

 	}

 }

 

Examples/07reader.php

Indentation +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
 
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;

Spacing +11 added lines, -11 removed lines

@@ -29,7 +29,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -41,19 +41,19 @@ 
 	exit("Please run 05featuredemo.php first." . EOL);
 }
 
-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load from Excel2007 file", EOL;
 $callStartTime = microtime(true);
 
 $objPHPExcel = \PHPExcel\IOFactory::load("05featuredemo.xlsx");
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -62,15 +62,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/34chartupdate.php

Indentation +9 added lines, -9 removed lines

@@ -40,7 +40,7 @@ 
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 if (!file_exists("33chartcreate-bar.xlsx")) {
-	exit("Please run 33chartcreate-bar.php first." . EOL);
+    exit("Please run 33chartcreate-bar.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;
@@ -52,14 +52,14 @@ 
 echo date('H:i:s') , " Update cell data values that are displayed in the chart" , EOL;
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array(50-12,   50-15,		50-21),
-		array(50-56,   50-73,		50-86),
-		array(50-52,   50-61,		50-69),
-		array(50-30,   50-32,		50),
-	),
-	NULL,
-	'B2'
+    array(
+        array(50-12,   50-15,		50-21),
+        array(50-56,   50-73,		50-86),
+        array(50-52,   50-61,		50-69),
+        array(50-30,   50-32,		50),
+    ),
+    NULL,
+    'B2'
 );
 
 // Save Excel 2007 file

Spacing +12 added lines, -12 removed lines

@@ -6,7 +6,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -43,36 +43,36 @@ 
 	exit("Please run 33chartcreate-bar.php first." . EOL);
 }
 
-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load from Excel2007 file", EOL;
 $objReader = \PHPExcel\IOFactory::createReader("Excel2007");
 $objReader->setIncludeCharts(TRUE);
 $objPHPExcel = $objReader->load("33chartcreate-bar.xlsx");
 
 
-echo date('H:i:s') , " Update cell data values that are displayed in the chart" , EOL;
+echo date('H:i:s'), " Update cell data values that are displayed in the chart", EOL;
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
 	array(
-		array(50-12,   50-15,		50-21),
-		array(50-56,   50-73,		50-86),
-		array(50-52,   50-61,		50-69),
-		array(50-30,   50-32,		50),
+		array(50 - 12, 50 - 15, 50 - 21),
+		array(50 - 56, 50 - 73, 50 - 86),
+		array(50 - 52, 50 - 61, 50 - 69),
+		array(50 - 30, 50 - 32, 50),
 	),
 	NULL,
 	'B2'
 );
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->setIncludeCharts(TRUE);
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/40duplicateStyle.php

Spacing +10 added lines, -10 removed lines

@@ -5,18 +5,18 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
 /** Include PHPExcel */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $worksheet = $objPHPExcel->getActiveSheet();
 
-echo date('H:i:s') , " Create styles array" , EOL;
+echo date('H:i:s'), " Create styles array", EOL;
 $styles = array();
 for ($i = 0; $i < 10; $i++) {
     $style = new \PHPExcel\Style();
@@ -24,7 +24,7 @@ 
     $styles[] = $style;
 }
 
-echo date('H:i:s') , " Add data (begin)" , EOL;
+echo date('H:i:s'), " Add data (begin)", EOL;
 $t = microtime(true);
 for ($col = 0; $col < 50; $col++) {
     for ($row = 0; $row < 100; $row++) {
@@ -36,16 +36,16 @@ 
     }
 }
 $d = microtime(true) - $t;
-echo date('H:i:s') , " Add data (end), time: " . round($d, 2) . " s", EOL;
+echo date('H:i:s'), " Add data (end), time: " . round($d, 2) . " s", EOL;
 
 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/33chartcreate-stock.php

Indentation +32 added lines, -32 removed lines

@@ -43,14 +43,14 @@ 
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('Counts', 		'Max', 		'Min', 		'Min Threshold', 	'Max Threshold'	),
-		array(10,		 		10, 		5, 			0, 					50				),
-		array(30,		 		20, 		10, 		0,	 				50				),
-		array(20,		 		30, 		15, 		0,	 				50				),
-		array(40,		 		10, 		0, 			0, 					50				),
-		array(100,		 		40, 		5, 			0, 					50				),
-	), null, 'A1', true
+    array(
+        array('Counts', 		'Max', 		'Min', 		'Min Threshold', 	'Max Threshold'	),
+        array(10,		 		10, 		5, 			0, 					50				),
+        array(30,		 		20, 		10, 		0,	 				50				),
+        array(20,		 		30, 		15, 		0,	 				50				),
+        array(40,		 		10, 		0, 			0, 					50				),
+        array(100,		 		40, 		5, 			0, 					50				),
+    ), null, 'A1', true
 );
 $objWorksheet->getStyle('B2:E6')->getNumberFormat()->setFormatCode(PHPExcel\Style\NumberFormat::FORMAT_NUMBER_00);
 
@@ -63,10 +63,10 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), //Max / Open
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), //Min / Close
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), //Min Threshold / Min
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1), //Max Threshold / Max
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), //Max / Open
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), //Min / Close
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), //Min Threshold / Min
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1), //Max Threshold / Max
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -76,7 +76,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$6', NULL, 5),	//	Counts
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$6', NULL, 5),	//	Counts
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -86,20 +86,20 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$6', NULL, 5),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$6', NULL, 5),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$6', NULL, 5),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$E$2:$E$6', NULL, 5),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$6', NULL, 5),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$6', NULL, 5),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$6', NULL, 5),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$E$2:$E$6', NULL, 5),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_STOCKCHART,	// plotType
-	null,										// plotGrouping - if we set this to not null, then xlsx throws error
-	range(0, count($dataSeriesValues)-1),		// plotOrder
-	$dataSeriesLabels,							// plotLabel
-	$xAxisTickValues,							// plotCategory
-	$dataSeriesValues							// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_STOCKCHART,	// plotType
+    null,										// plotGrouping - if we set this to not null, then xlsx throws error
+    range(0, count($dataSeriesValues)-1),		// plotOrder
+    $dataSeriesLabels,							// plotLabel
+    $xAxisTickValues,							// plotCategory
+    $dataSeriesValues							// plotValues
 );
 
 //	Set the series in the plot area
@@ -113,14 +113,14 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'stock-chart',	// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	$xAxisLabel,	// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'stock-chart',	// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    $xAxisLabel,	// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet
@@ -137,7 +137,7 @@ 
 $objWriter->setIncludeCharts(TRUE);
 $filename = str_replace('.php', '.xlsx', __FILE__);
 if(file_exists($filename)) {
-	unlink($filename);
+    unlink($filename);
 }
 $objWriter->save($filename);
 echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;

Spacing +26 added lines, -26 removed lines

@@ -6,7 +6,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -44,12 +44,12 @@ 
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
 	array(
-		array('Counts', 		'Max', 		'Min', 		'Min Threshold', 	'Max Threshold'	),
-		array(10,		 		10, 		5, 			0, 					50				),
-		array(30,		 		20, 		10, 		0,	 				50				),
-		array(20,		 		30, 		15, 		0,	 				50				),
-		array(40,		 		10, 		0, 			0, 					50				),
-		array(100,		 		40, 		5, 			0, 					50				),
+		array('Counts', 'Max', 'Min', 'Min Threshold', 'Max Threshold'),
+		array(10, 10, 5, 0, 50),
+		array(30, 20, 10, 0, 50),
+		array(20, 30, 15, 0, 50),
+		array(40, 10, 0, 0, 50),
+		array(100, 40, 5, 0, 50),
 	), null, 'A1', true
 );
 $objWorksheet->getStyle('B2:E6')->getNumberFormat()->setFormatCode(PHPExcel\Style\NumberFormat::FORMAT_NUMBER_00);
@@ -76,7 +76,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$6', NULL, 5),	//	Counts
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$6', NULL, 5), //	Counts
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -94,11 +94,11 @@ 
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_STOCKCHART,	// plotType
-	null,										// plotGrouping - if we set this to not null, then xlsx throws error
-	range(0, count($dataSeriesValues)-1),		// plotOrder
-	$dataSeriesLabels,							// plotLabel
-	$xAxisTickValues,							// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_STOCKCHART, // plotType
+	null, // plotGrouping - if we set this to not null, then xlsx throws error
+	range(0, count($dataSeriesValues) - 1), // plotOrder
+	$dataSeriesLabels, // plotLabel
+	$xAxisTickValues, // plotCategory
 	$dataSeriesValues							// plotValues
 );
 
@@ -113,13 +113,13 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'stock-chart',	// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	$xAxisLabel,	// xAxisLabel
+	'stock-chart', // name
+	$title, // title
+	$legend, // legend
+	$plotArea, // plotArea
+	true, // plotVisibleOnly
+	0, // displayBlanksAs
+	$xAxisLabel, // xAxisLabel
 	$yAxisLabel		// yAxisLabel
 );
 
@@ -132,20 +132,20 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->setIncludeCharts(TRUE);
 $filename = str_replace('.php', '.xlsx', __FILE__);
-if(file_exists($filename)) {
+if (file_exists($filename)) {
 	unlink($filename);
 }
 $objWriter->save($filename);
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/19namedrange.php

Indentation +16 added lines, -16 removed lines

@@ -46,23 +46,23 @@ 
 // Set document properties
 echo date('H:i:s') , " Set document 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");
 
 
 // Add some data
 echo date('H:i:s') , " Add some data" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Firstname:')
-                              ->setCellValue('A2', 'Lastname:')
-                              ->setCellValue('A3', 'Fullname:')
-                              ->setCellValue('B1', 'Maarten')
-                              ->setCellValue('B2', 'Balliauw')
-                              ->setCellValue('B3', '=B1 & " " & B2');
+                                ->setCellValue('A2', 'Lastname:')
+                                ->setCellValue('A3', 'Fullname:')
+                                ->setCellValue('B1', 'Maarten')
+                                ->setCellValue('B2', 'Balliauw')
+                                ->setCellValue('B3', '=B1 & " " & B2');
 
 // Define named ranges
 echo date('H:i:s') , " Define named ranges" , EOL;
@@ -86,11 +86,11 @@ 
 echo date('H:i:s') , " Add some data" , EOL;
 $objPHPExcel->setActiveSheetIndex(1);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Firstname:')
-                              ->setCellValue('A2', 'Lastname:')
-                              ->setCellValue('A3', 'Fullname:')
-                              ->setCellValue('B1', '=PersonFN')
-                              ->setCellValue('B2', '=PersonLN')
-                              ->setCellValue('B3', '=PersonFN & " " & PersonLN');
+                                ->setCellValue('A2', 'Lastname:')
+                                ->setCellValue('A3', 'Fullname:')
+                                ->setCellValue('B1', '=PersonFN')
+                                ->setCellValue('B2', '=PersonLN')
+                                ->setCellValue('B3', '=PersonFN & " " & PersonLN');
 
 // Resolve range
 echo date('H:i:s') , " Resolve range" , EOL;

Spacing +23 added lines, -23 removed lines

@@ -31,7 +31,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -40,11 +40,11 @@ 
 
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -55,7 +55,7 @@ 
 
 
 // Add some data
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Firstname:')
                               ->setCellValue('A2', 'Lastname:')
@@ -65,25 +65,25 @@ 
                               ->setCellValue('B3', '=B1 & " " & B2');
 
 // Define named ranges
-echo date('H:i:s') , " Define named ranges" , EOL;
-$objPHPExcel->addNamedRange( new \PHPExcel\NamedRange('PersonName', $objPHPExcel->getActiveSheet(), 'B1') );
-$objPHPExcel->addNamedRange( new \PHPExcel\NamedRange('PersonLN', $objPHPExcel->getActiveSheet(), 'B2') );
+echo date('H:i:s'), " Define named ranges", EOL;
+$objPHPExcel->addNamedRange(new \PHPExcel\NamedRange('PersonName', $objPHPExcel->getActiveSheet(), 'B1'));
+$objPHPExcel->addNamedRange(new \PHPExcel\NamedRange('PersonLN', $objPHPExcel->getActiveSheet(), 'B2'));
 
 // Rename named ranges
-echo date('H:i:s') , " Rename named ranges" , EOL;
+echo date('H:i:s'), " Rename named ranges", EOL;
 $objPHPExcel->getNamedRange('PersonName')->setName('PersonFN');
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Person');
 
 
 // Create a new worksheet, after the default sheet
-echo date('H:i:s') , " Create new Worksheet object" , EOL;
+echo date('H:i:s'), " Create new Worksheet object", EOL;
 $objPHPExcel->createSheet();
 
 // Add some data to the second sheet, resembling some different data types
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPHPExcel->setActiveSheetIndex(1);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Firstname:')
                               ->setCellValue('A2', 'Lastname:')
@@ -93,13 +93,13 @@ 
                               ->setCellValue('B3', '=PersonFN & " " & PersonLN');
 
 // Resolve range
-echo date('H:i:s') , " Resolve range" , EOL;
-echo 'Cell B1 {=PersonFN}: ' , $objPHPExcel->getActiveSheet()->getCell('B1')->getCalculatedValue() , EOL;
-echo 'Cell B3 {=PersonFN & " " & PersonLN}: ' , $objPHPExcel->getActiveSheet()->getCell('B3')->getCalculatedValue() , EOL;
-echo 'Cell Person!B1: ' , $objPHPExcel->getActiveSheet()->getCell('Person!B1')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Resolve range", EOL;
+echo 'Cell B1 {=PersonFN}: ', $objPHPExcel->getActiveSheet()->getCell('B1')->getCalculatedValue(), EOL;
+echo 'Cell B3 {=PersonFN & " " & PersonLN}: ', $objPHPExcel->getActiveSheet()->getCell('B3')->getCalculatedValue(), EOL;
+echo 'Cell Person!B1: ', $objPHPExcel->getActiveSheet()->getCell('Person!B1')->getCalculatedValue(), EOL;
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Person (cloned)');
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet
@@ -107,7 +107,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -115,15 +115,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/10autofilter.php

Indentation +65 added lines, -65 removed lines

@@ -44,78 +44,78 @@
 // Set document properties
 echo date('H:i:s').' Set document properties'.EOL;
 $objPHPExcel->getProperties()->setCreator('Maarten Balliauw')
-							 ->setLastModifiedBy('Maarten Balliauw')
-							 ->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('Maarten Balliauw')
+                                ->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');
 
 // Create the worksheet
 echo date('H:i:s').' Add data'.EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Year')
-                              ->setCellValue('B1', 'Quarter')
-                              ->setCellValue('C1', 'Country')
-                              ->setCellValue('D1', 'Sales');
+                                ->setCellValue('B1', 'Quarter')
+                                ->setCellValue('C1', 'Country')
+                                ->setCellValue('D1', 'Sales');
 
 $dataArray = array(array('2010',	'Q1',	'United States',	790),
-                   array('2010',	'Q2',	'United States',	730),
-                   array('2010',	'Q3',	'United States',	860),
-                   array('2010',	'Q4',	'United States',	850),
-                   array('2011',	'Q1',	'United States',	800),
-                   array('2011',	'Q2',	'United States',	700),
-                   array('2011',	'Q3',	'United States',	900),
-                   array('2011',	'Q4',	'United States',	950),
-                   array('2010',	'Q1',	'Belgium',			380),
-                   array('2010',	'Q2',	'Belgium',			390),
-                   array('2010',	'Q3',	'Belgium',			420),
-                   array('2010',	'Q4',	'Belgium',			460),
-                   array('2011',	'Q1',	'Belgium',			400),
-                   array('2011',	'Q2',	'Belgium',			350),
-                   array('2011',	'Q3',	'Belgium',			450),
-                   array('2011',	'Q4',	'Belgium',			500),
-                   array('2010',	'Q1',	'UK',				690),
-                   array('2010',	'Q2',	'UK',				610),
-                   array('2010',	'Q3',	'UK',				620),
-                   array('2010',	'Q4',	'UK',				600),
-                   array('2011',	'Q1',	'UK',				720),
-                   array('2011',	'Q2',	'UK',				650),
-                   array('2011',	'Q3',	'UK',				580),
-                   array('2011',	'Q4',	'UK',				510),
-                   array('2010',	'Q1',	'France',			510),
-                   array('2010',	'Q2',	'France',			490),
-                   array('2010',	'Q3',	'France',			460),
-                   array('2010',	'Q4',	'France', 			590),
-                   array('2011',	'Q1',	'France',			620),
-                   array('2011',	'Q2',	'France',			650),
-                   array('2011',	'Q3',	'France',			415),
-                   array('2011',	'Q4',	'France', 			570),
-                   array('2010',	'Q1',	'Germany',			720),
-                   array('2010',	'Q2',	'Germany',			680),
-                   array('2010',	'Q3',	'Germany',			640),
-                   array('2010',	'Q4',	'Germany',			660),
-                   array('2011',	'Q1',	'Germany',			680),
-                   array('2011',	'Q2',	'Germany',			620),
-                   array('2011',	'Q3',	'Germany',			710),
-                   array('2011',	'Q4',	'Germany',			690),
-                   array('2010',	'Q1',	'Spain',			510),
-                   array('2010',	'Q2',	'Spain',			490),
-                   array('2010',	'Q3',	'Spain',			470),
-                   array('2010',	'Q4',	'Spain',			420),
-                   array('2011',	'Q1',	'Spain',			460),
-                   array('2011',	'Q2',	'Spain',			390),
-                   array('2011',	'Q3',	'Spain',			430),
-                   array('2011',	'Q4',	'Spain',			415),
-                   array('2010',	'Q1',	'Italy',			440),
-                   array('2010',	'Q2',	'Italy',			410),
-                   array('2010',	'Q3',	'Italy',			420),
-                   array('2010',	'Q4',	'Italy',			450),
-                   array('2011',	'Q1',	'Italy',			430),
-                   array('2011',	'Q2',	'Italy',			370),
-                   array('2011',	'Q3',	'Italy',			350),
-                   array('2011',	'Q4',	'Italy',			335),
-                  );
+                    array('2010',	'Q2',	'United States',	730),
+                    array('2010',	'Q3',	'United States',	860),
+                    array('2010',	'Q4',	'United States',	850),
+                    array('2011',	'Q1',	'United States',	800),
+                    array('2011',	'Q2',	'United States',	700),
+                    array('2011',	'Q3',	'United States',	900),
+                    array('2011',	'Q4',	'United States',	950),
+                    array('2010',	'Q1',	'Belgium',			380),
+                    array('2010',	'Q2',	'Belgium',			390),
+                    array('2010',	'Q3',	'Belgium',			420),
+                    array('2010',	'Q4',	'Belgium',			460),
+                    array('2011',	'Q1',	'Belgium',			400),
+                    array('2011',	'Q2',	'Belgium',			350),
+                    array('2011',	'Q3',	'Belgium',			450),
+                    array('2011',	'Q4',	'Belgium',			500),
+                    array('2010',	'Q1',	'UK',				690),
+                    array('2010',	'Q2',	'UK',				610),
+                    array('2010',	'Q3',	'UK',				620),
+                    array('2010',	'Q4',	'UK',				600),
+                    array('2011',	'Q1',	'UK',				720),
+                    array('2011',	'Q2',	'UK',				650),
+                    array('2011',	'Q3',	'UK',				580),
+                    array('2011',	'Q4',	'UK',				510),
+                    array('2010',	'Q1',	'France',			510),
+                    array('2010',	'Q2',	'France',			490),
+                    array('2010',	'Q3',	'France',			460),
+                    array('2010',	'Q4',	'France', 			590),
+                    array('2011',	'Q1',	'France',			620),
+                    array('2011',	'Q2',	'France',			650),
+                    array('2011',	'Q3',	'France',			415),
+                    array('2011',	'Q4',	'France', 			570),
+                    array('2010',	'Q1',	'Germany',			720),
+                    array('2010',	'Q2',	'Germany',			680),
+                    array('2010',	'Q3',	'Germany',			640),
+                    array('2010',	'Q4',	'Germany',			660),
+                    array('2011',	'Q1',	'Germany',			680),
+                    array('2011',	'Q2',	'Germany',			620),
+                    array('2011',	'Q3',	'Germany',			710),
+                    array('2011',	'Q4',	'Germany',			690),
+                    array('2010',	'Q1',	'Spain',			510),
+                    array('2010',	'Q2',	'Spain',			490),
+                    array('2010',	'Q3',	'Spain',			470),
+                    array('2010',	'Q4',	'Spain',			420),
+                    array('2011',	'Q1',	'Spain',			460),
+                    array('2011',	'Q2',	'Spain',			390),
+                    array('2011',	'Q3',	'Spain',			430),
+                    array('2011',	'Q4',	'Spain',			415),
+                    array('2010',	'Q1',	'Italy',			440),
+                    array('2010',	'Q2',	'Italy',			410),
+                    array('2010',	'Q3',	'Italy',			420),
+                    array('2010',	'Q4',	'Italy',			450),
+                    array('2011',	'Q1',	'Italy',			430),
+                    array('2011',	'Q2',	'Italy',			370),
+                    array('2011',	'Q3',	'Italy',			350),
+                    array('2011',	'Q4',	'Italy',			335),
+                    );
 $objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A2');
 
 // Set title row bold

Spacing +73 added lines, -73 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -38,11 +38,11 @@ 
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 // Create new PHPExcel object
-echo date('H:i:s').' Create new PHPExcel object'.EOL;
+echo date('H:i:s') . ' Create new PHPExcel object' . EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s').' Set document properties'.EOL;
+echo date('H:i:s') . ' Set document properties' . EOL;
 $objPHPExcel->getProperties()->setCreator('Maarten Balliauw')
 							 ->setLastModifiedBy('Maarten Balliauw')
 							 ->setTitle('PHPExcel Test Document')
@@ -52,78 +52,78 @@ 
 							 ->setCategory('Test result file');
 
 // Create the worksheet
-echo date('H:i:s').' Add data'.EOL;
+echo date('H:i:s') . ' Add data' . EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Year')
                               ->setCellValue('B1', 'Quarter')
                               ->setCellValue('C1', 'Country')
                               ->setCellValue('D1', 'Sales');
 
-$dataArray = array(array('2010',	'Q1',	'United States',	790),
-                   array('2010',	'Q2',	'United States',	730),
-                   array('2010',	'Q3',	'United States',	860),
-                   array('2010',	'Q4',	'United States',	850),
-                   array('2011',	'Q1',	'United States',	800),
-                   array('2011',	'Q2',	'United States',	700),
-                   array('2011',	'Q3',	'United States',	900),
-                   array('2011',	'Q4',	'United States',	950),
-                   array('2010',	'Q1',	'Belgium',			380),
-                   array('2010',	'Q2',	'Belgium',			390),
-                   array('2010',	'Q3',	'Belgium',			420),
-                   array('2010',	'Q4',	'Belgium',			460),
-                   array('2011',	'Q1',	'Belgium',			400),
-                   array('2011',	'Q2',	'Belgium',			350),
-                   array('2011',	'Q3',	'Belgium',			450),
-                   array('2011',	'Q4',	'Belgium',			500),
-                   array('2010',	'Q1',	'UK',				690),
-                   array('2010',	'Q2',	'UK',				610),
-                   array('2010',	'Q3',	'UK',				620),
-                   array('2010',	'Q4',	'UK',				600),
-                   array('2011',	'Q1',	'UK',				720),
-                   array('2011',	'Q2',	'UK',				650),
-                   array('2011',	'Q3',	'UK',				580),
-                   array('2011',	'Q4',	'UK',				510),
-                   array('2010',	'Q1',	'France',			510),
-                   array('2010',	'Q2',	'France',			490),
-                   array('2010',	'Q3',	'France',			460),
-                   array('2010',	'Q4',	'France', 			590),
-                   array('2011',	'Q1',	'France',			620),
-                   array('2011',	'Q2',	'France',			650),
-                   array('2011',	'Q3',	'France',			415),
-                   array('2011',	'Q4',	'France', 			570),
-                   array('2010',	'Q1',	'Germany',			720),
-                   array('2010',	'Q2',	'Germany',			680),
-                   array('2010',	'Q3',	'Germany',			640),
-                   array('2010',	'Q4',	'Germany',			660),
-                   array('2011',	'Q1',	'Germany',			680),
-                   array('2011',	'Q2',	'Germany',			620),
-                   array('2011',	'Q3',	'Germany',			710),
-                   array('2011',	'Q4',	'Germany',			690),
-                   array('2010',	'Q1',	'Spain',			510),
-                   array('2010',	'Q2',	'Spain',			490),
-                   array('2010',	'Q3',	'Spain',			470),
-                   array('2010',	'Q4',	'Spain',			420),
-                   array('2011',	'Q1',	'Spain',			460),
-                   array('2011',	'Q2',	'Spain',			390),
-                   array('2011',	'Q3',	'Spain',			430),
-                   array('2011',	'Q4',	'Spain',			415),
-                   array('2010',	'Q1',	'Italy',			440),
-                   array('2010',	'Q2',	'Italy',			410),
-                   array('2010',	'Q3',	'Italy',			420),
-                   array('2010',	'Q4',	'Italy',			450),
-                   array('2011',	'Q1',	'Italy',			430),
-                   array('2011',	'Q2',	'Italy',			370),
-                   array('2011',	'Q3',	'Italy',			350),
-                   array('2011',	'Q4',	'Italy',			335),
+$dataArray = array(array('2010', 'Q1', 'United States', 790),
+                   array('2010', 'Q2', 'United States', 730),
+                   array('2010', 'Q3', 'United States', 860),
+                   array('2010', 'Q4', 'United States', 850),
+                   array('2011', 'Q1', 'United States', 800),
+                   array('2011', 'Q2', 'United States', 700),
+                   array('2011', 'Q3', 'United States', 900),
+                   array('2011', 'Q4', 'United States', 950),
+                   array('2010', 'Q1', 'Belgium', 380),
+                   array('2010', 'Q2', 'Belgium', 390),
+                   array('2010', 'Q3', 'Belgium', 420),
+                   array('2010', 'Q4', 'Belgium', 460),
+                   array('2011', 'Q1', 'Belgium', 400),
+                   array('2011', 'Q2', 'Belgium', 350),
+                   array('2011', 'Q3', 'Belgium', 450),
+                   array('2011', 'Q4', 'Belgium', 500),
+                   array('2010', 'Q1', 'UK', 690),
+                   array('2010', 'Q2', 'UK', 610),
+                   array('2010', 'Q3', 'UK', 620),
+                   array('2010', 'Q4', 'UK', 600),
+                   array('2011', 'Q1', 'UK', 720),
+                   array('2011', 'Q2', 'UK', 650),
+                   array('2011', 'Q3', 'UK', 580),
+                   array('2011', 'Q4', 'UK', 510),
+                   array('2010', 'Q1', 'France', 510),
+                   array('2010', 'Q2', 'France', 490),
+                   array('2010', 'Q3', 'France', 460),
+                   array('2010', 'Q4', 'France', 590),
+                   array('2011', 'Q1', 'France', 620),
+                   array('2011', 'Q2', 'France', 650),
+                   array('2011', 'Q3', 'France', 415),
+                   array('2011', 'Q4', 'France', 570),
+                   array('2010', 'Q1', 'Germany', 720),
+                   array('2010', 'Q2', 'Germany', 680),
+                   array('2010', 'Q3', 'Germany', 640),
+                   array('2010', 'Q4', 'Germany', 660),
+                   array('2011', 'Q1', 'Germany', 680),
+                   array('2011', 'Q2', 'Germany', 620),
+                   array('2011', 'Q3', 'Germany', 710),
+                   array('2011', 'Q4', 'Germany', 690),
+                   array('2010', 'Q1', 'Spain', 510),
+                   array('2010', 'Q2', 'Spain', 490),
+                   array('2010', 'Q3', 'Spain', 470),
+                   array('2010', 'Q4', 'Spain', 420),
+                   array('2011', 'Q1', 'Spain', 460),
+                   array('2011', 'Q2', 'Spain', 390),
+                   array('2011', 'Q3', 'Spain', 430),
+                   array('2011', 'Q4', 'Spain', 415),
+                   array('2010', 'Q1', 'Italy', 440),
+                   array('2010', 'Q2', 'Italy', 410),
+                   array('2010', 'Q3', 'Italy', 420),
+                   array('2010', 'Q4', 'Italy', 450),
+                   array('2011', 'Q1', 'Italy', 430),
+                   array('2011', 'Q2', 'Italy', 370),
+                   array('2011', 'Q3', 'Italy', 350),
+                   array('2011', 'Q4', 'Italy', 335),
                   );
 $objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A2');
 
 // Set title row bold
-echo date('H:i:s').' Set title row bold'.EOL;
+echo date('H:i:s') . ' Set title row bold' . EOL;
 $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setBold(true);
 
 // Set autofilter
-echo date('H:i:s').' Set autofilter'.EOL;
+echo date('H:i:s') . ' Set autofilter' . EOL;
 // Always include the complete filter range!
 // Excel does support setting only the caption
 // row, but that's not a best practise...
@@ -134,7 +134,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -142,14 +142,14 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -157,15 +157,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s').' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB'.EOL;
+echo date('H:i:s') . ' Peak memory usage: ' . (memory_get_peak_usage(true) / 1024 / 1024) . ' MB' . EOL;
 
 // Echo done
-echo date('H:i:s').' Done writing files'.EOL;
-echo 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s') . ' Done writing files' . EOL;
+echo 'Files have been created in ', getcwd(), EOL;

Examples/28iterator.php

Indentation +12 added lines, -12 removed lines

@@ -38,7 +38,7 @@ 
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;
@@ -47,19 +47,19 @@ 
 
 echo date('H:i:s') , " Iterate worksheets" , EOL;
 foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-	echo 'Worksheet - ' , $worksheet->getTitle() , EOL;
+    echo 'Worksheet - ' , $worksheet->getTitle() , EOL;
 
-	foreach ($worksheet->getRowIterator() as $row) {
-		echo '    Row number - ' , $row->getRowIndex() , EOL;
+    foreach ($worksheet->getRowIterator() as $row) {
+        echo '    Row number - ' , $row->getRowIndex() , EOL;
 
-		$cellIterator = $row->getCellIterator();
-		$cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set
-		foreach ($cellIterator as $cell) {
-			if (!is_null($cell)) {
-				echo '        Cell - ' , $cell->getCoordinate() , ' - ' , $cell->getCalculatedValue() , EOL;
-			}
-		}
-	}
+        $cellIterator = $row->getCellIterator();
+        $cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set
+        foreach ($cellIterator as $cell) {
+            if (!is_null($cell)) {
+                echo '        Cell - ' , $cell->getCoordinate() , ' - ' , $cell->getCalculatedValue() , EOL;
+            }
+        }
+    }
 }
 
 

Spacing +7 added lines, -7 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -41,22 +41,22 @@ 
 	exit("Please run 05featuredemo.php first." . EOL);
 }
 
-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load from Excel2007 file", EOL;
 $objReader = \PHPExcel\IOFactory::createReader('Excel2007');
 $objPHPExcel = $objReader->load("05featuredemo.xlsx");
 
-echo date('H:i:s') , " Iterate worksheets" , EOL;
+echo date('H:i:s'), " Iterate worksheets", EOL;
 foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-	echo 'Worksheet - ' , $worksheet->getTitle() , EOL;
+	echo 'Worksheet - ', $worksheet->getTitle(), EOL;
 
 	foreach ($worksheet->getRowIterator() as $row) {
-		echo '    Row number - ' , $row->getRowIndex() , EOL;
+		echo '    Row number - ', $row->getRowIndex(), EOL;
 
 		$cellIterator = $row->getCellIterator();
 		$cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set
 		foreach ($cellIterator as $cell) {
 			if (!is_null($cell)) {
-				echo '        Cell - ' , $cell->getCoordinate() , ' - ' , $cell->getCalculatedValue() , EOL;
+				echo '        Cell - ', $cell->getCoordinate(), ' - ', $cell->getCalculatedValue(), EOL;
 			}
 		}
 	}
@@ -64,4 +64,4 @@ 
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;