PHPOffice / PhpSpreadsheet

Examples/37page_layout_view.php

Spacing +11 added lines, -11 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("PHPOffice")
 							 ->setLastModifiedBy("PHPOffice")
 							 ->setTitle("PHPExcel Test Document")
@@ -53,7 +53,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)
             ->setCellValue('A1', 'Hello')
             ->setCellValue('B2', 'world!');
@@ -65,19 +65,19 @@ 
 $objPHPExcel->getActiveSheet()->getSheetView()->setView(PHPExcel\Worksheet\SheetView::SHEETVIEW_PAGE_LAYOUT);
 
 // 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->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;
 // Save Excel5 file
-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 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/42richText.php

Spacing +16 added lines, -16 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")
@@ -53,7 +53,7 @@ 
 
 
 // Add some data
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 
 $html1 = '<font color="#0000ff">
 <h1 align="center">My very first example of rich text<br />generated from html markup</h1>
@@ -124,7 +124,7 @@ 
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()
     ->setTitle('Rich Text Examples');
 
@@ -134,7 +134,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -142,14 +142,14 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -157,15 +157,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing files" , EOL;
-echo 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing files", EOL;
+echo 'Files have been created in ', getcwd(), EOL;

Examples/39dropdown.php

Spacing +16 added lines, -16 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("PHPOffice")
 	->setLastModifiedBy("PHPOffice")
@@ -62,10 +62,10 @@ 
 $column = 'F';
 
 // Set data for dropdowns
-foreach(glob('./data/continents/*') as $key => $filename) {
+foreach (glob('./data/continents/*') as $key => $filename) {
     $continent = pathinfo($filename, PATHINFO_FILENAME);
     echo "Loading $continent", EOL;
-    $continent = str_replace(' ','_',$continent);
+    $continent = str_replace(' ', '_', $continent);
     $countries = file($filename, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
     $countryCount = count($countries);
 
@@ -84,7 +84,7 @@ 
         ->setVisible(false);
 
     $objPHPExcel->getActiveSheet()
-        ->setCellValue($continentColumn . ($key+1), $continent);
+        ->setCellValue($continentColumn . ($key + 1), $continent);
 
     ++$column;
 }
@@ -97,7 +97,7 @@ 
 $objPHPExcel->addNamedRange(
     new PHPExcel\NamedRange(
         'Continents', 
-        $objPHPExcel->getActiveSheet(), $continentColumn . '1:' . $continentColumn . ($key+1)
+        $objPHPExcel->getActiveSheet(), $continentColumn . '1:' . $continentColumn . ($key + 1)
     )
 );
 
@@ -119,8 +119,8 @@ 
 $objValidation = $objPHPExcel->getActiveSheet()
     ->getCell('B1')
     ->getDataValidation();
-$objValidation->setType( PHPExcel\Cell\DataValidation::TYPE_LIST )
-    ->setErrorStyle( PHPExcel\Cell\DataValidation::STYLE_INFORMATION )
+$objValidation->setType(PHPExcel\Cell\DataValidation::TYPE_LIST)
+    ->setErrorStyle(PHPExcel\Cell\DataValidation::STYLE_INFORMATION)
     ->setAllowBlank(false)
     ->setShowInputMessage(true)
     ->setShowErrorMessage(true)
@@ -140,8 +140,8 @@ 
 $objValidation = $objPHPExcel->getActiveSheet()
     ->getCell('B3')
     ->getDataValidation();
-$objValidation->setType( PHPExcel\Cell\DataValidation::TYPE_LIST )
-    ->setErrorStyle( PHPExcel\Cell\DataValidation::STYLE_INFORMATION )
+$objValidation->setType(PHPExcel\Cell\DataValidation::TYPE_LIST)
+    ->setErrorStyle(PHPExcel\Cell\DataValidation::STYLE_INFORMATION)
     ->setAllowBlank(false)
     ->setShowInputMessage(true)
     ->setShowErrorMessage(true)
@@ -162,14 +162,14 @@ 
 
 // Save Excel 2007 file
 // This linked validation list method only seems to work for Excel2007, not for Excel5
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 // Echo 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/GnumericReader.php

Spacing +7 added lines, -7 removed lines

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

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

 

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

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

 $callStartTime = microtime(true);

 

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

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

 $callEndTime = microtime(true);

 $callTime = $callEndTime - $callStartTime;

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

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

 // Echo memory usage

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

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

 

 

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

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

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

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

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

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

 

 

 // Echo memory peak usage

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

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

 

 // Echo done

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

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

Examples/Quadratic.php

Spacing +4 added lines, -4 removed lines

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

 

 		$callStartTime = microtime(true);

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

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

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

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

 		$callEndTime = microtime(true);

 		$callTime = $callEndTime - $callStartTime;

 

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

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

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

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

 	}

 }

 

Examples/07reader.php

Spacing +11 added lines, -11 removed lines

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

Examples/34chartupdate.php

Spacing +12 added lines, -12 removed lines

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

Examples/40duplicateStyle.php

Spacing +10 added lines, -10 removed lines

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

Examples/33chartcreate-stock.php

Spacing +26 added lines, -26 removed lines

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