PHPOffice / PhpSpreadsheet

Examples/06largescale.php

Spacing +15 added lines, -15 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');
 
@@ -53,11 +53,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 properties" , EOL;
+echo date('H:i:s'), " Set properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -68,7 +68,7 @@ 
 
 
 // Create a first sheet
-echo date('H:i:s') , " Add data" , EOL;
+echo date('H:i:s'), " Add data", EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname");
 $objPHPExcel->getActiveSheet()->setCellValue('B1', "Lastname");
@@ -78,24 +78,24 @@ 
 
 
 // Hide "Phone" and "fax" column
-echo date('H:i:s') , " Hide 'Phone' and 'fax' columns" , EOL;
+echo date('H:i:s'), " Hide 'Phone' and 'fax' columns", EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
 $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);
 
 
 // Set outline levels
-echo date('H:i:s') , " Set outline levels" , EOL;
+echo date('H:i:s'), " Set outline levels", EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
                                                        ->setVisible(false)
                                                        ->setCollapsed(true);
 
 // Freeze panes
-echo date('H:i:s') , " Freeze panes" , EOL;
+echo date('H:i:s'), " Freeze panes", EOL;
 $objPHPExcel->getActiveSheet()->freezePane('A2');
 
 
 // Rows to repeat at top
-echo date('H:i:s') , " Rows to repeat at top" , EOL;
+echo date('H:i:s'), " Rows to repeat at top", EOL;
 $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 1);
 
 
@@ -114,7 +114,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');
@@ -122,15 +122,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;

Indentation +13 added lines, -13 removed lines

@@ -52,12 +52,12 @@ 
 // 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 @@ 
 // 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 @@ 
 
 // 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);
 }
 
 

Examples/09pagebreaks.php

Indentation +21 added lines, -21 removed lines

@@ -45,37 +45,37 @@
 // 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");
 
 
 // Create a first sheet
 echo date('H:i:s') , " Add data and page breaks" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname")
-                              ->setCellValue('B1', "Lastname")
-                              ->setCellValue('C1', "Phone")
-                              ->setCellValue('D1', "Fax")
-                              ->setCellValue('E1', "Is Client ?");
+                                ->setCellValue('B1', "Lastname")
+                                ->setCellValue('C1', "Phone")
+                                ->setCellValue('D1', "Fax")
+                                ->setCellValue('E1', "Is Client ?");
 
 
 // Add data
 for ($i = 2; $i <= 50; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, "LName $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, "PhoneNo $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, "FaxNo $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, true);
-
-	// Add page breaks every 10 rows
-	if ($i % 10 == 0) {
-		// Add a page break
-		$objPHPExcel->getActiveSheet()->setBreak( 'A' . $i, \PHPExcel\Worksheet::BREAK_ROW );
-	}
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, "LName $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, "PhoneNo $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, "FaxNo $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, true);
+
+    // Add page breaks every 10 rows
+    if ($i % 10 == 0) {
+        // Add a page break
+        $objPHPExcel->getActiveSheet()->setBreak( 'A' . $i, \PHPExcel\Worksheet::BREAK_ROW );
+    }
 }
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet

Spacing +16 added lines, -16 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');
 
@@ -39,11 +39,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")
@@ -54,7 +54,7 @@ 
 
 
 // Create a first sheet
-echo date('H:i:s') , " Add data and page breaks" , EOL;
+echo date('H:i:s'), " Add data and page breaks", EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname")
                               ->setCellValue('B1', "Lastname")
@@ -74,7 +74,7 @@ 
 	// Add page breaks every 10 rows
 	if ($i % 10 == 0) {
 		// Add a page break
-		$objPHPExcel->getActiveSheet()->setBreak( 'A' . $i, \PHPExcel\Worksheet::BREAK_ROW );
+		$objPHPExcel->getActiveSheet()->setBreak('A' . $i, \PHPExcel\Worksheet::BREAK_ROW);
 	}
 }
 
@@ -97,7 +97,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');
@@ -105,14 +105,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');
@@ -120,15 +120,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/33chartcreate-bar-stacked.php

Indentation +28 added lines, -28 removed lines

@@ -43,13 +43,13 @@ 
 $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 @@ 
 //		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 @@ 
 //		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 @@ 
 //		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_STACKED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_STACKED,	// 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 @@ 
 
 //	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

Spacing +27 added lines, -27 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,11 +44,11 @@ 
 $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('', 2010, 2011, 2012),
+		array('Q1', 12, 15, 21),
+		array('Q2', 56, 73, 86),
+		array('Q3', 52, 61, 69),
+		array('Q4', 30, 32, 0),
 	)
 );
 
@@ -60,9 +60,9 @@ 
 //		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 @@ 
 //		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
@@ -89,11 +89,11 @@ 
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STACKED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_STACKED, // plotGrouping
+	range(0, count($dataSeriesValues) - 1), // plotOrder
+	$dataSeriesLabels, // plotLabel
+	$xAxisTickValues, // plotCategory
 	$dataSeriesValues								// plotValues
 );
 //	Set additional dataseries parameters
@@ -111,13 +111,13 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
+	'chart1', // name
+	$title, // title
+	$legend, // legend
+	$plotArea, // plotArea
+	true, // plotVisibleOnly
+	0, // displayBlanksAs
+	NULL, // xAxisLabel
 	$yAxisLabel		// yAxisLabel
 );
 
@@ -130,16 +130,16 @@ 
 
 
 // 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/08conditionalformatting.php

Indentation +16 added lines, -16 removed lines

@@ -45,37 +45,37 @@ 
 // 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");
 
 
 // Create a first sheet, representing sales data
 echo date('H:i:s') , " Add some data" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Description')
-                              ->setCellValue('B1', 'Amount');
+                                ->setCellValue('B1', 'Amount');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Paycheck received')
-                              ->setCellValue('B2', 100);
+                                ->setCellValue('B2', 100);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A3', 'Cup of coffee bought')
-                              ->setCellValue('B3', -1.5);
+                                ->setCellValue('B3', -1.5);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A4', 'Cup of coffee bought')
-                              ->setCellValue('B4', -1.5);
+                                ->setCellValue('B4', -1.5);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A5', 'Cup of tea bought')
-                              ->setCellValue('B5', -1.2);
+                                ->setCellValue('B5', -1.2);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A6', 'Found some money')
-                              ->setCellValue('B6', 8);
+                                ->setCellValue('B6', 8);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A7', 'Total:')
-                              ->setCellValue('B7', '=SUM(B2:B6)');
+                                ->setCellValue('B7', '=SUM(B2:B6)');
 
 
 // Set column widths
@@ -121,9 +121,9 @@ 
 //	duplicate the conditional styles across a range of cells
 echo date('H:i:s') , " Duplicate the conditional formatting across a range of cells" , EOL;
 $objPHPExcel->getActiveSheet()->duplicateConditionalStyle(
-				$objPHPExcel->getActiveSheet()->getStyle('B2')->getConditionalStyles(),
-				'B3:B7'
-			  );
+                $objPHPExcel->getActiveSheet()->getStyle('B2')->getConditionalStyles(),
+                'B3:B7'
+                );
 
 
 // Set fonts

Spacing +21 added lines, -21 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');
 
@@ -39,11 +39,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")
@@ -54,7 +54,7 @@ 
 
 
 // Create a first sheet, representing sales 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', 'Description')
                               ->setCellValue('B1', 'Amount');
@@ -79,13 +79,13 @@ 
 
 
 // Set column widths
-echo date('H:i:s') , " Set column widths" , EOL;
+echo date('H:i:s'), " Set column widths", EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
 $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
 
 
 // Add conditional formatting
-echo date('H:i:s') , " Add conditional formatting" , EOL;
+echo date('H:i:s'), " Add conditional formatting", EOL;
 $objConditional1 = new \PHPExcel\Style\Conditional();
 $objConditional1->setConditionType(\PHPExcel\Style\Conditional::CONDITION_CELLIS)
                 ->setOperatorType(\PHPExcel\Style\Conditional::OPERATOR_BETWEEN)
@@ -119,7 +119,7 @@ 
 
 
 //	duplicate the conditional styles across a range of cells
-echo date('H:i:s') , " Duplicate the conditional formatting across a range of cells" , EOL;
+echo date('H:i:s'), " Duplicate the conditional formatting across a range of cells", EOL;
 $objPHPExcel->getActiveSheet()->duplicateConditionalStyle(
 				$objPHPExcel->getActiveSheet()->getStyle('B2')->getConditionalStyles(),
 				'B3:B7'
@@ -127,7 +127,7 @@ 
 
 
 // Set fonts
-echo date('H:i:s') , " Set fonts" , EOL;
+echo date('H:i:s'), " Set fonts", EOL;
 $objPHPExcel->getActiveSheet()->getStyle('A1:B1')->getFont()->setBold(true);
 //$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
 $objPHPExcel->getActiveSheet()->getStyle('A7:B7')->getFont()->setBold(true);
@@ -135,19 +135,19 @@ 
 
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.
-echo date('H:i:s') , " Set header/footer" , EOL;
+echo date('H:i:s'), " Set header/footer", EOL;
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&BPersonal cash register&RPrinted on &D');
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');
 
 
 // Set page orientation and size
-echo date('H:i:s') , " Set page orientation and size" , EOL;
+echo date('H:i:s'), " Set page orientation and size", EOL;
 $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(\PHPExcel\Worksheet\PageSetup::ORIENTATION_PORTRAIT);
 $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(\PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4);
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Invoice');
 
 
@@ -156,7 +156,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');
@@ -164,10 +164,10 @@ 
 $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;
 // Save Excel5 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');
@@ -175,15 +175,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 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-selection-display.php

Indentation +81 added lines, -81 removed lines

@@ -44,23 +44,23 @@ 
 // 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', 'Financial Year')
-                              ->setCellValue('B1', 'Financial Period')
-                              ->setCellValue('C1', 'Country')
-                              ->setCellValue('D1', 'Date')
-                              ->setCellValue('E1', 'Sales Value')
-                              ->setCellValue('F1', 'Expenditure')
-                              ;
+                                ->setCellValue('B1', 'Financial Period')
+                                ->setCellValue('C1', 'Country')
+                                ->setCellValue('D1', 'Date')
+                                ->setCellValue('E1', 'Sales Value')
+                                ->setCellValue('F1', 'Expenditure')
+                                ;
 $startYear = $endYear = $currentYear = date('Y');
 $startYear--;
 $endYear++;
@@ -68,44 +68,44 @@ 
 $years = range($startYear,$endYear);
 $periods = range(1,12);
 $countries = array(	'United States',	'UK',		'France',	'Germany',
-					'Italy',			'Spain',	'Portugal',	'Japan'
-				  );
+                    'Italy',			'Spain',	'Portugal',	'Japan'
+                    );
 
 $row = 2;
 foreach($years as $year) {
-	foreach($periods as $period) {
-		foreach($countries as $country) {
-			$endDays = date('t',mktime(0,0,0,$period,1,$year));
-			for($i = 1; $i <= $endDays; ++$i) {
-				$eDate = \PHPExcel\Shared\Date::formattedPHPToExcel(
-					$year,
-					$period,
-					$i
-				);
-				$value = rand(500,1000) * (1 + rand(-0.25,+0.25));
-				$salesValue = $invoiceValue = NULL;
-				$incomeOrExpenditure = rand(-1,1);
-				if ($incomeOrExpenditure == -1) {
-					$expenditure = rand(-500,-1000) * (1 + rand(-0.25,+0.25));
-					$income = NULL;
-				} elseif ($incomeOrExpenditure == 1) {
-					$expenditure = rand(-500,-1000) * (1 + rand(-0.25,+0.25));
-					$income = rand(500,1000) * (1 + rand(-0.25,+0.25));;
-				} else {
-					$expenditure = NULL;
-					$income = rand(500,1000) * (1 + rand(-0.25,+0.25));;
-				}
-				$dataArray = array(	$year,
-									$period,
-									$country,
-									$eDate,
-									$income,
-									$expenditure,
-								  );
-				$objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A'.$row++);
-			}
-		}
-	}
+    foreach($periods as $period) {
+        foreach($countries as $country) {
+            $endDays = date('t',mktime(0,0,0,$period,1,$year));
+            for($i = 1; $i <= $endDays; ++$i) {
+                $eDate = \PHPExcel\Shared\Date::formattedPHPToExcel(
+                    $year,
+                    $period,
+                    $i
+                );
+                $value = rand(500,1000) * (1 + rand(-0.25,+0.25));
+                $salesValue = $invoiceValue = NULL;
+                $incomeOrExpenditure = rand(-1,1);
+                if ($incomeOrExpenditure == -1) {
+                    $expenditure = rand(-500,-1000) * (1 + rand(-0.25,+0.25));
+                    $income = NULL;
+                } elseif ($incomeOrExpenditure == 1) {
+                    $expenditure = rand(-500,-1000) * (1 + rand(-0.25,+0.25));
+                    $income = rand(500,1000) * (1 + rand(-0.25,+0.25));;
+                } else {
+                    $expenditure = NULL;
+                    $income = rand(500,1000) * (1 + rand(-0.25,+0.25));;
+                }
+                $dataArray = array(	$year,
+                                    $period,
+                                    $country,
+                                    $eDate,
+                                    $income,
+                                    $expenditure,
+                                    );
+                $objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A'.$row++);
+            }
+        }
+    }
 }
 $row--;
 
@@ -138,45 +138,45 @@ 
 $autoFilter->getColumn('C')
     ->setFilterType(\PHPExcel\Worksheet\AutoFilter\Column::AUTOFILTER_FILTERTYPE_CUSTOMFILTER)
     ->createRule()
-		->setRule(
-			\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
-			'u*'
-		)
-		->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_CUSTOMFILTER);
+        ->setRule(
+            \PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
+            'u*'
+        )
+        ->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_CUSTOMFILTER);
 $autoFilter->getColumn('C')
     ->createRule()
-		->setRule(
-			\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
-			'japan'
-		)
-		->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_CUSTOMFILTER);
+        ->setRule(
+            \PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
+            'japan'
+        )
+        ->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_CUSTOMFILTER);
 // Filter the Date column on a filter value of the first day of every period of the current year
 //	We us a dateGroup ruletype for this, although it is still a standard filter
 foreach($periods as $period) {
-	$endDate = date('t',mktime(0,0,0,$period,1,$currentYear));
-
-	$autoFilter->getColumn('D')
-	    ->setFilterType(\PHPExcel\Worksheet\AutoFilter\Column::AUTOFILTER_FILTERTYPE_FILTER)
-	    ->createRule()
-			->setRule(
-				\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
-				array(
-					'year' => $currentYear,
-					'month' => $period,
-					'day' => $endDate
-				)
-			)
-			->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_DATEGROUP);
+    $endDate = date('t',mktime(0,0,0,$period,1,$currentYear));
+
+    $autoFilter->getColumn('D')
+        ->setFilterType(\PHPExcel\Worksheet\AutoFilter\Column::AUTOFILTER_FILTERTYPE_FILTER)
+        ->createRule()
+            ->setRule(
+                \PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
+                array(
+                    'year' => $currentYear,
+                    'month' => $period,
+                    'day' => $endDate
+                )
+            )
+            ->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_DATEGROUP);
 }
 // Display only sales values that are blank
 //     Standard filter, operator equals, and value of NULL
 $autoFilter->getColumn('E')
     ->setFilterType(\PHPExcel\Worksheet\AutoFilter\Column::AUTOFILTER_FILTERTYPE_FILTER)
     ->createRule()
-		->setRule(
-			\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
-			''
-		);
+        ->setRule(
+            \PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_COLUMN_RULE_EQUAL,
+            ''
+        );
 
 // Execute filtering
 echo date('H:i:s').' Execute filtering'.EOL;
@@ -189,10 +189,10 @@ 
 // Display Results of filtering
 echo date('H:i:s').' Display filtered rows'.EOL;
 foreach ($objPHPExcel->getActiveSheet()->getRowIterator() as $row) {
-	if ($objPHPExcel->getActiveSheet()->getRowDimension($row->getRowIndex())->getVisible()) {
-		echo '    Row number - ' , $row->getRowIndex() , ' ';
-		echo $objPHPExcel->getActiveSheet()->getCell('C'.$row->getRowIndex())->getValue(), ' ';
-		echo $objPHPExcel->getActiveSheet()->getCell('D'.$row->getRowIndex())->getFormattedValue(), ' ';
-		echo EOL;
-	}
+    if ($objPHPExcel->getActiveSheet()->getRowDimension($row->getRowIndex())->getVisible()) {
+        echo '    Row number - ' , $row->getRowIndex() , ' ';
+        echo $objPHPExcel->getActiveSheet()->getCell('C'.$row->getRowIndex())->getValue(), ' ';
+        echo $objPHPExcel->getActiveSheet()->getCell('D'.$row->getRowIndex())->getFormattedValue(), ' ';
+        echo EOL;
+    }
 }

Spacing +33 added lines, -33 removed lines

@@ -31,18 +31,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 />');
 
 /** Include PHPExcel */
 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,7 +52,7 @@ 
 							 ->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', 'Financial Year')
                               ->setCellValue('B1', 'Financial Period')
@@ -65,44 +65,44 @@ 
 $startYear--;
 $endYear++;
 
-$years = range($startYear,$endYear);
-$periods = range(1,12);
-$countries = array(	'United States',	'UK',		'France',	'Germany',
-					'Italy',			'Spain',	'Portugal',	'Japan'
+$years = range($startYear, $endYear);
+$periods = range(1, 12);
+$countries = array('United States', 'UK', 'France', 'Germany',
+					'Italy', 'Spain', 'Portugal', 'Japan'
 				  );
 
 $row = 2;
-foreach($years as $year) {
-	foreach($periods as $period) {
-		foreach($countries as $country) {
-			$endDays = date('t',mktime(0,0,0,$period,1,$year));
-			for($i = 1; $i <= $endDays; ++$i) {
+foreach ($years as $year) {
+	foreach ($periods as $period) {
+		foreach ($countries as $country) {
+			$endDays = date('t', mktime(0, 0, 0, $period, 1, $year));
+			for ($i = 1; $i <= $endDays; ++$i) {
 				$eDate = \PHPExcel\Shared\Date::formattedPHPToExcel(
 					$year,
 					$period,
 					$i
 				);
-				$value = rand(500,1000) * (1 + rand(-0.25,+0.25));
+				$value = rand(500, 1000) * (1 + rand(-0.25, +0.25));
 				$salesValue = $invoiceValue = NULL;
-				$incomeOrExpenditure = rand(-1,1);
+				$incomeOrExpenditure = rand(-1, 1);
 				if ($incomeOrExpenditure == -1) {
-					$expenditure = rand(-500,-1000) * (1 + rand(-0.25,+0.25));
+					$expenditure = rand(-500, -1000) * (1 + rand(-0.25, +0.25));
 					$income = NULL;
 				} elseif ($incomeOrExpenditure == 1) {
-					$expenditure = rand(-500,-1000) * (1 + rand(-0.25,+0.25));
-					$income = rand(500,1000) * (1 + rand(-0.25,+0.25));;
+					$expenditure = rand(-500, -1000) * (1 + rand(-0.25, +0.25));
+					$income = rand(500, 1000) * (1 + rand(-0.25, +0.25)); ;
 				} else {
 					$expenditure = NULL;
-					$income = rand(500,1000) * (1 + rand(-0.25,+0.25));;
+					$income = rand(500, 1000) * (1 + rand(-0.25, +0.25)); ;
 				}
-				$dataArray = array(	$year,
+				$dataArray = array($year,
 									$period,
 									$country,
 									$eDate,
 									$income,
 									$expenditure,
 								  );
-				$objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A'.$row++);
+				$objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A' . $row++);
 			}
 		}
 	}
@@ -111,20 +111,20 @@ 
 
 
 // Set styling
-echo date('H:i:s').' Set styling'.EOL;
+echo date('H:i:s') . ' Set styling' . EOL;
 $objPHPExcel->getActiveSheet()->getStyle('A1:F1')->getFont()->setBold(true);
 $objPHPExcel->getActiveSheet()->getStyle('A1:F1')->getAlignment()->setWrapText(TRUE);
 $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12.5);
 $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(10.5);
-$objPHPExcel->getActiveSheet()->getStyle('D2:D'.$row)->getNumberFormat()->setFormatCode(\PHPExcel\Style\NumberFormat::FORMAT_DATE_YYYYMMDD2);
-$objPHPExcel->getActiveSheet()->getStyle('E2:F'.$row)->getNumberFormat()->setFormatCode(\PHPExcel\Style\NumberFormat::FORMAT_CURRENCY_USD_SIMPLE);
+$objPHPExcel->getActiveSheet()->getStyle('D2:D' . $row)->getNumberFormat()->setFormatCode(\PHPExcel\Style\NumberFormat::FORMAT_DATE_YYYYMMDD2);
+$objPHPExcel->getActiveSheet()->getStyle('E2:F' . $row)->getNumberFormat()->setFormatCode(\PHPExcel\Style\NumberFormat::FORMAT_CURRENCY_USD_SIMPLE);
 $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(14);
 $objPHPExcel->getActiveSheet()->freezePane('A2');
 
 
 
 // Set autofilter range
-echo date('H:i:s').' Set autofilter range'.EOL;
+echo date('H:i:s') . ' Set autofilter range' . EOL;
 // Always include the complete filter range!
 // Excel does support setting only the caption
 // row, but that's not a best practise...
@@ -132,7 +132,7 @@ 
 
 // Set active filters
 $autoFilter = $objPHPExcel->getActiveSheet()->getAutoFilter();
-echo date('H:i:s').' Set active filters'.EOL;
+echo date('H:i:s') . ' Set active filters' . EOL;
 // Filter the Country column on a filter value of countries beginning with the letter U (or Japan)
 //     We use * as a wildcard, so specify as U* and using a wildcard requires customFilter
 $autoFilter->getColumn('C')
@@ -152,8 +152,8 @@ 
 		->setRuleType(\PHPExcel\Worksheet\AutoFilter\Column\Rule::AUTOFILTER_RULETYPE_CUSTOMFILTER);
 // Filter the Date column on a filter value of the first day of every period of the current year
 //	We us a dateGroup ruletype for this, although it is still a standard filter
-foreach($periods as $period) {
-	$endDate = date('t',mktime(0,0,0,$period,1,$currentYear));
+foreach ($periods as $period) {
+	$endDate = date('t', mktime(0, 0, 0, $period, 1, $currentYear));
 
 	$autoFilter->getColumn('D')
 	    ->setFilterType(\PHPExcel\Worksheet\AutoFilter\Column::AUTOFILTER_FILTERTYPE_FILTER)
@@ -179,7 +179,7 @@ 
 		);
 
 // Execute filtering
-echo date('H:i:s').' Execute filtering'.EOL;
+echo date('H:i:s') . ' Execute filtering' . EOL;
 $autoFilter->showHideRows();
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet
@@ -187,12 +187,12 @@ 
 
 
 // Display Results of filtering
-echo date('H:i:s').' Display filtered rows'.EOL;
+echo date('H:i:s') . ' Display filtered rows' . EOL;
 foreach ($objPHPExcel->getActiveSheet()->getRowIterator() as $row) {
 	if ($objPHPExcel->getActiveSheet()->getRowDimension($row->getRowIndex())->getVisible()) {
-		echo '    Row number - ' , $row->getRowIndex() , ' ';
-		echo $objPHPExcel->getActiveSheet()->getCell('C'.$row->getRowIndex())->getValue(), ' ';
-		echo $objPHPExcel->getActiveSheet()->getCell('D'.$row->getRowIndex())->getFormattedValue(), ' ';
+		echo '    Row number - ', $row->getRowIndex(), ' ';
+		echo $objPHPExcel->getActiveSheet()->getCell('C' . $row->getRowIndex())->getValue(), ' ';
+		echo $objPHPExcel->getActiveSheet()->getCell('D' . $row->getRowIndex())->getFormattedValue(), ' ';
 		echo EOL;
 	}
 }

Examples/30template.php

Indentation +20 added lines, -20 removed lines

@@ -48,31 +48,31 @@
 

 echo date('H:i:s') , " Add new data to the template" , EOL;

 $data = array(array('title'		=> 'Excel for dummies',

-					'price'		=> 17.99,

-					'quantity'	=> 2

-				   ),

-			  array('title'		=> 'PHP for dummies',

-					'price'		=> 15.99,

-					'quantity'	=> 1

-				   ),

-			  array('title'		=> 'Inside OOP',

-					'price'		=> 12.95,

-					'quantity'	=> 1

-				   )

-			 );

+                    'price'		=> 17.99,

+                    'quantity'	=> 2

+                    ),

+                array('title'		=> 'PHP for dummies',

+                    'price'		=> 15.99,

+                    'quantity'	=> 1

+                    ),

+                array('title'		=> 'Inside OOP',

+                    'price'		=> 12.95,

+                    'quantity'	=> 1

+                    )

+                );

 

 $objPHPExcel->getActiveSheet()->setCellValue('D1', \PHPExcel\Shared\Date::PHPToExcel(time()));

 

 $baseRow = 5;

 foreach($data as $r => $dataRow) {

-	$row = $baseRow + $r;

-	$objPHPExcel->getActiveSheet()->insertNewRowBefore($row,1);

-

-	$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $r+1)

-	                              ->setCellValue('B'.$row, $dataRow['title'])

-	                              ->setCellValue('C'.$row, $dataRow['price'])

-	                              ->setCellValue('D'.$row, $dataRow['quantity'])

-	                              ->setCellValue('E'.$row, '=C'.$row.'*D'.$row);

+    $row = $baseRow + $r;

+    $objPHPExcel->getActiveSheet()->insertNewRowBefore($row,1);

+

+    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $r+1)

+                                    ->setCellValue('B'.$row, $dataRow['title'])

+                                    ->setCellValue('C'.$row, $dataRow['price'])

+                                    ->setCellValue('D'.$row, $dataRow['quantity'])

+                                    ->setCellValue('E'.$row, '=C'.$row.'*D'.$row);

 }

 $objPHPExcel->getActiveSheet()->removeRow($baseRow-1,1);

 

Spacing +16 added lines, -16 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');

 

@@ -39,14 +39,14 @@ 
 

 

 

-echo date('H:i:s') , " Load from Excel5 template" , EOL;

+echo date('H:i:s'), " Load from Excel5 template", EOL;

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

 $objPHPExcel = $objReader->load("templates/30template.xls");

 

 

 

 

-echo date('H:i:s') , " Add new data to the template" , EOL;

+echo date('H:i:s'), " Add new data to the template", EOL;

 $data = array(array('title'		=> 'Excel for dummies',

 					'price'		=> 17.99,

 					'quantity'	=> 2

@@ -64,28 +64,28 @@ 
 $objPHPExcel->getActiveSheet()->setCellValue('D1', \PHPExcel\Shared\Date::PHPToExcel(time()));

 

 $baseRow = 5;

-foreach($data as $r => $dataRow) {

+foreach ($data as $r => $dataRow) {

 	$row = $baseRow + $r;

-	$objPHPExcel->getActiveSheet()->insertNewRowBefore($row,1);

+	$objPHPExcel->getActiveSheet()->insertNewRowBefore($row, 1);

 

-	$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $r+1)

-	                              ->setCellValue('B'.$row, $dataRow['title'])

-	                              ->setCellValue('C'.$row, $dataRow['price'])

-	                              ->setCellValue('D'.$row, $dataRow['quantity'])

-	                              ->setCellValue('E'.$row, '=C'.$row.'*D'.$row);

+	$objPHPExcel->getActiveSheet()->setCellValue('A' . $row, $r + 1)

+	                              ->setCellValue('B' . $row, $dataRow['title'])

+	                              ->setCellValue('C' . $row, $dataRow['price'])

+	                              ->setCellValue('D' . $row, $dataRow['quantity'])

+	                              ->setCellValue('E' . $row, '=C' . $row . '*D' . $row);

 }

-$objPHPExcel->getActiveSheet()->removeRow($baseRow-1,1);

+$objPHPExcel->getActiveSheet()->removeRow($baseRow - 1, 1);

 

 

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

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

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

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

-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;

+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', 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/32chartreadwrite.php

Indentation +72 added lines, -72 removed lines

@@ -17,81 +17,81 @@
 $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];

-	}

+    $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);

-				$groupCount = $chart->getPlotArea()->getPlotGroupCount();

-				if ($groupCount == 1) {

-					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();

-					echo '    ' , $chartType , EOL;

-				} else {

-					$chartTypes = array();

-					for($i = 0; $i < $groupCount; ++$i) {

-						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();

-					}

-					$chartTypes = array_unique($chartTypes);

-					if (count($chartTypes) == 1) {

-						$chartType = 'Multiple Plot ' . array_pop($chartTypes);

-						echo '    ' , $chartType , EOL;

-					} elseif (count($chartTypes) == 0) {

-						echo '    *** Type not yet implemented' , EOL;

-					} else {

-						echo '    Combination Chart' , EOL;

-					}

-				}

-			}

-		}

-	}

-

-

-	$outputFileName = basename($inputFileName);

-

-	echo date('H:i:s') , " Write Tests to Excel2007 file " , EOL;

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

-	$objWriter->setIncludeCharts(TRUE);

-	$objWriter->save($outputFileName);

-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;

-

-	$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);

+                $groupCount = $chart->getPlotArea()->getPlotGroupCount();

+                if ($groupCount == 1) {

+                    $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();

+                    echo '    ' , $chartType , EOL;

+                } else {

+                    $chartTypes = array();

+                    for($i = 0; $i < $groupCount; ++$i) {

+                        $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();

+                    }

+                    $chartTypes = array_unique($chartTypes);

+                    if (count($chartTypes) == 1) {

+                        $chartType = 'Multiple Plot ' . array_pop($chartTypes);

+                        echo '    ' , $chartType , EOL;

+                    } elseif (count($chartTypes) == 0) {

+                        echo '    *** Type not yet implemented' , EOL;

+                    } else {

+                        echo '    Combination Chart' , EOL;

+                    }

+                }

+            }

+        }

+    }

+

+

+    $outputFileName = basename($inputFileName);

+

+    echo date('H:i:s') , " Write Tests to Excel2007 file " , EOL;

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

+    $objWriter->setIncludeCharts(TRUE);

+    $objWriter->save($outputFileName);

+    echo date('H:i:s') , " File written to " , $outputFileName , EOL;

+

+    $objPHPExcel->disconnectWorksheets();

+    unset($objPHPExcel);

 }

 

 // Echo memory peak usage

Spacing +23 added lines, -23 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');

 

@@ -18,63 +18,63 @@ 
 

 if ((isset($argc)) && ($argc > 1)) {

 	$inputFileNames = array();

-	for($i = 1; $i < $argc; ++$i) {

+	for ($i = 1; $i < $argc; ++$i) {

 		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];

 	}

 } else {

 	$inputFileNames = glob($inputFileNames);

 }

-foreach($inputFileNames as $inputFileName) {

+foreach ($inputFileNames as $inputFileName) {

 	$inputFileNameShort = basename($inputFileName);

 

 	if (!file_exists($inputFileName)) {

-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;

+		echo date('H:i:s'), " File ", $inputFileNameShort, ' does not exist', EOL;

 		continue;

 	}

 

-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;

+	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;

+	echo date('H:i:s'), " Iterate worksheets looking at the charts", EOL;

 	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {

 		$sheetName = $worksheet->getTitle();

-		echo 'Worksheet: ' , $sheetName , EOL;

+		echo 'Worksheet: ', $sheetName, EOL;

 

 		$chartNames = $worksheet->getChartNames();

-		if(empty($chartNames)) {

-			echo '    There are no charts in this worksheet' , EOL;

+		if (empty($chartNames)) {

+			echo '    There are no charts in this worksheet', EOL;

 		} else {

 			natsort($chartNames);

-			foreach($chartNames as $i => $chartName) {

+			foreach ($chartNames as $i => $chartName) {

 				$chart = $worksheet->getChartByName($chartName);

 				if (!is_null($chart->getTitle())) {

-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';

+					$caption = '"' . implode(' ', $chart->getTitle()->getCaption()) . '"';

 				} else {

 					$caption = 'Untitled';

 				}

-				echo '    ' , $chartName , ' - ' , $caption , EOL;

-				echo str_repeat(' ',strlen($chartName)+3);

+				echo '    ', $chartName, ' - ', $caption, EOL;

+				echo str_repeat(' ', strlen($chartName) + 3);

 				$groupCount = $chart->getPlotArea()->getPlotGroupCount();

 				if ($groupCount == 1) {

 					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();

-					echo '    ' , $chartType , EOL;

+					echo '    ', $chartType, EOL;

 				} else {

 					$chartTypes = array();

-					for($i = 0; $i < $groupCount; ++$i) {

+					for ($i = 0; $i < $groupCount; ++$i) {

 						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();

 					}

 					$chartTypes = array_unique($chartTypes);

 					if (count($chartTypes) == 1) {

 						$chartType = 'Multiple Plot ' . array_pop($chartTypes);

-						echo '    ' , $chartType , EOL;

+						echo '    ', $chartType, EOL;

 					} elseif (count($chartTypes) == 0) {

-						echo '    *** Type not yet implemented' , EOL;

+						echo '    *** Type not yet implemented', EOL;

 					} else {

-						echo '    Combination Chart' , EOL;

+						echo '    Combination Chart', EOL;

 					}

 				}

 			}

@@ -84,19 +84,19 @@ 
 

 	$outputFileName = basename($inputFileName);

 

-	echo date('H:i:s') , " Write Tests to Excel2007 file " , EOL;

+	echo date('H:i:s'), " Write Tests to Excel2007 file ", EOL;

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

 	$objWriter->setIncludeCharts(TRUE);

 	$objWriter->save($outputFileName);

-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;

+	echo date('H:i:s'), " File written to ", $outputFileName, EOL;

 

 	$objPHPExcel->disconnectWorksheets();

 	unset($objPHPExcel);

 }

 

 // 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/16csv.php

Indentation +3 added lines, -3 removed lines

@@ -45,9 +45,9 @@
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'CSV')->setDelimiter(',')
-                                                                  ->setEnclosure('"')
-                                                                  ->setSheetIndex(0)
-                                                                  ->save(str_replace('.php', '.csv', __FILE__));
+                                                                    ->setEnclosure('"')
+                                                                    ->setSheetIndex(0)
+                                                                    ->save(str_replace('.php', '.csv', __FILE__));
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 echo date('H:i:s') , " File written to " , str_replace('.php', '.csv', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;

Spacing +19 added lines, -19 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');
 
@@ -41,7 +41,7 @@ 
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 
-echo date('H:i:s') , " Write to CSV format" , EOL;
+echo date('H:i:s'), " Write to CSV format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'CSV')->setDelimiter(',')
@@ -50,13 +50,13 @@ 
                                                                   ->save(str_replace('.php', '.csv', __FILE__));
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo date('H:i:s') , " File written to " , str_replace('.php', '.csv', 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', '.csv', 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 date('H:i:s') , " Read from CSV format" , EOL;
+echo date('H:i:s'), " Read from CSV format", EOL;
 $callStartTime = microtime(true);
 $objReader = \PHPExcel\IOFactory::createReader('CSV')->setDelimiter(',')
                                                     ->setEnclosure('"')
@@ -65,25 +65,25 @@ 
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to reload Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to reload 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);
 
 $objWriter2007 = \PHPExcel\IOFactory::createWriter($objPHPExcelFromCSV, 'Excel2007');
 $objWriter2007->save(str_replace('.php', '.xlsx', __FILE__));
 $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 date('H:i:s') , " Write to CSV format" , EOL;
+echo date('H:i:s'), " Write to CSV format", EOL;
 $callStartTime = microtime(true);
 
 $objWriterCSV = \PHPExcel\IOFactory::createWriter($objPHPExcelFromCSV, 'CSV');
@@ -91,15 +91,15 @@ 
 $objWriterCSV->save(str_replace('.php', '_excel.csv', __FILE__));
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo date('H:i:s') , " File written to " , str_replace('.php', '_excel.csv', 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', '_excel.csv', 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/OOCalcReader.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 OOCalc file" , PHP_EOL;

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

 $callStartTime = microtime(true);

 

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

@@ -42,20 +42,20 @@ 
 

 $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;