PHPOffice / PhpSpreadsheet

Examples/36chartreadwriteHTML.php

Indentation +80 added lines, -80 removed lines

@@ -22,14 +22,14 @@ 
 
 
 if (!PHPExcel\Settings::setChartRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -37,81 +37,81 @@ 
 $inputFileNames = 'templates/36write*.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 = str_replace('.xlsx', '.html', basename($inputFileName));
-
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
-	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
-	$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 = str_replace('.xlsx', '.html', basename($inputFileName));
+
+    echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+    $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
+    $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');
 
@@ -61,63 +61,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;
 					}
 				}
 			}
@@ -127,19 +127,19 @@ 
 
 	$outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName));
 
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+	echo date('H:i:s'), " Write Tests to HTML file ", EOL;
 	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
 	$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/44worksheetInfo.php

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

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;

Examples/08conditionalformatting2.php

Indentation +9 added lines, -9 removed lines

@@ -45,12 +45,12 @@ 
 // 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
@@ -97,9 +97,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('A1')->getConditionalStyles(),
-				'A2:A8'
-			  );
+                $objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
+                'A2:A8'
+                );
 
 
 // Save Excel 2007 file

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, 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', '-0.5')
@@ -75,7 +75,7 @@ 
 
 
 // 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_LESSTHAN)
@@ -95,7 +95,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('A1')->getConditionalStyles(),
 				'A2:A8'
@@ -103,7 +103,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');
@@ -111,10 +111,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');
@@ -122,15 +122,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/04printing.php

Indentation +8 added lines, -8 removed lines

@@ -45,19 +45,19 @@
 // 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, we will use printing features
 echo date('H:i:s') , " Add some data" , EOL;
 for ($i = 1; $i < 200; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
-	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
+    $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.

Spacing +19 added lines, -19 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,19 +54,19 @@ 
 
 
 // Add some data, we will use printing features
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 for ($i = 1; $i < 200; $i++) {
 	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
 	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // 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&G&C&HPlease treat this document as confidential!');
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');
 
 // Add a drawing to the header
-echo date('H:i:s') , " Add a drawing to the header" , EOL;
+echo date('H:i:s'), " Add a drawing to the header", EOL;
 $objDrawing = new \PHPExcel\Worksheet\HeaderFooterDrawing();
 $objDrawing->setName('PHPExcel logo');
 $objDrawing->setPath('./images/phpexcel_logo.gif');
@@ -74,12 +74,12 @@ 
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, \PHPExcel\Worksheet\HeaderFooter::IMAGE_HEADER_LEFT);
 
 // 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_LANDSCAPE);
 $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('Printing');
 
 
@@ -88,7 +88,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');
@@ -96,14 +96,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');
@@ -111,15 +111,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/15datavalidation.php

Indentation +18 added lines, -18 removed lines

@@ -47,30 +47,30 @@
 // 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" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...")
-                              ->setCellValue('A3', "Number:")
-                              ->setCellValue('B3', "10")
-                              ->setCellValue('A5', "List:")
-                              ->setCellValue('B5', "Item A")
-                              ->setCellValue('A7', "List #2:")
-                              ->setCellValue('B7', "Item #2")
-                              ->setCellValue('D2', "Item #1")
-                              ->setCellValue('D3', "Item #2")
-                              ->setCellValue('D4', "Item #3")
-                              ->setCellValue('D5', "Item #4")
-                              ->setCellValue('D6', "Item #5")
-                              ;
+                                ->setCellValue('A3', "Number:")
+                                ->setCellValue('B3', "10")
+                                ->setCellValue('A5', "List:")
+                                ->setCellValue('B5', "Item A")
+                                ->setCellValue('A7', "List #2:")
+                                ->setCellValue('B7', "Item #2")
+                                ->setCellValue('D2', "Item #1")
+                                ->setCellValue('D3', "Item #2")
+                                ->setCellValue('D4', "Item #3")
+                                ->setCellValue('D5', "Item #4")
+                                ->setCellValue('D6', "Item #5")
+                                ;
 
 
 // Set data validation

Spacing +20 added lines, -20 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,12 +40,12 @@ 
 
 
 // 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")
@@ -56,7 +56,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', "Cell B3 and B5 contain data validation...")
                               ->setCellValue('A3', "Number:")
@@ -74,10 +74,10 @@ 
 
 
 // Set data validation
-echo date('H:i:s') , " Set data validation" , EOL;
+echo date('H:i:s'), " Set data validation", EOL;
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation();
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_WHOLE );
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_STOP );
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_WHOLE);
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_STOP);
 $objValidation->setAllowBlank(true);
 $objValidation->setShowInputMessage(true);
 $objValidation->setShowErrorMessage(true);
@@ -89,8 +89,8 @@ 
 $objValidation->setFormula2(20);
 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B5')->getDataValidation();
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_LIST );
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_INFORMATION );
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_LIST);
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_INFORMATION);
 $objValidation->setAllowBlank(false);
 $objValidation->setShowInputMessage(true);
 $objValidation->setShowErrorMessage(true);
@@ -99,12 +99,12 @@ 
 $objValidation->setError('Value is not in list.');
 $objValidation->setPromptTitle('Pick from list');
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
-$objValidation->setFormula1('"Item A,Item B,Item C"');	// Make sure to put the list items between " and " if your list is simply a comma-separated list of values !!!
+$objValidation->setFormula1('"Item A,Item B,Item C"'); // Make sure to put the list items between " and " if your list is simply a comma-separated list of values !!!
 
 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B7')->getDataValidation();
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_LIST );
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_INFORMATION );
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_LIST);
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_INFORMATION);
 $objValidation->setAllowBlank(false);
 $objValidation->setShowInputMessage(true);
 $objValidation->setShowErrorMessage(true);
@@ -113,7 +113,7 @@ 
 $objValidation->setError('Value is not in list.');
 $objValidation->setPromptTitle('Pick from list');
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
-$objValidation->setFormula1('$D$2:$D$6');	// Make sure NOT to put a range of cells or a formula between " and "  !!!
+$objValidation->setFormula1('$D$2:$D$6'); // Make sure NOT to put a range of cells or a formula between " and "  !!!
 
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet
@@ -121,7 +121,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');
@@ -129,15 +129,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/36chartreadwritePDF.php

Indentation +88 added lines, -88 removed lines

@@ -26,14 +26,14 @@ 
 
 
 if (!PHPExcel\Settings::setPdfRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -45,14 +45,14 @@ 
 
 
 if (!PHPExcel\Settings::setChartRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -60,81 +60,81 @@ 
 $inputFileNames = 'templates/36write*.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 = str_replace('.xlsx', '.pdf', basename($inputFileName));
-
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
-	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
-	$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 = str_replace('.xlsx', '.pdf', basename($inputFileName));
+
+    echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+    $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
+    $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');
 
@@ -61,63 +61,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;
 					}
 				}
 			}
@@ -127,19 +127,19 @@ 
 
 	$outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName));
 
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+	echo date('H:i:s'), " Write Tests to HTML file ", EOL;
 	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
 	$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/23sharedstyles.php

Indentation +24 added lines, -24 removed lines

@@ -46,12 +46,12 @@ 
 // 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
@@ -62,26 +62,26 @@ 
 $sharedStyle2 = new \PHPExcel\Style();
 
 $sharedStyle1->applyFromArray(
-	array('fill' 	=> array(
-								'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
-								'color'		=> array('argb' => 'FFCCFFCC')
-							),
-		  'borders' => array(
-								'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
-								'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
-							)
-		 ));
+    array('fill' 	=> array(
+                                'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
+                                'color'		=> array('argb' => 'FFCCFFCC')
+                            ),
+            'borders' => array(
+                                'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
+                                'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
+                            )
+            ));
 
 $sharedStyle2->applyFromArray(
-	array('fill' 	=> array(
-								'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
-								'color'		=> array('argb' => 'FFFFFF00')
-							),
-		  'borders' => array(
-								'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
-								'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
-							)
-		 ));
+    array('fill' 	=> array(
+                                'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
+                                'color'		=> array('argb' => 'FFFFFF00')
+                            ),
+            'borders' => array(
+                                'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
+                                'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
+                            )
+            ));
 
 $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle1, "A1:T100");
 $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle2, "C5:R95");

Spacing +15 added lines, -15 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);
 
 $sharedStyle1 = new \PHPExcel\Style();
@@ -87,7 +87,7 @@ 
 $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle2, "C5:R95");
 
 // 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');
@@ -95,14 +95,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');
@@ -110,15 +110,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/05featuredemo.php

Spacing +12 added lines, -12 removed lines

@@ -30,14 +30,14 @@ 
 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');
 
 include "05featuredemo.inc.php";
 
 // 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');
@@ -45,14 +45,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');
@@ -60,15 +60,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/SylkReader.php

Spacing +5 added lines, -5 removed lines

@@ -34,17 +34,17 @@
 require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php';

 

 

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

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

 $objPHPExcel = \PHPExcel\IOFactory::load("SylkTest.slk");

 

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