PHPOffice / PhpSpreadsheet

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;

Examples/18extendedcalculation.php

Spacing +2 added lines, -2 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');
 
@@ -105,4 +105,4 @@ 
 echo date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB\r\n";
 
 // Echo done
-echo date('H:i:s') . " Done" , EOL;
+echo date('H:i:s') . " Done", EOL;

Examples/25inmemoryimage.php

Spacing +13 added lines, -13 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")
@@ -53,13 +53,13 @@ 
 							 ->setCategory("Test result file");
 
 // Generate an image
-echo date('H:i:s') , " Generate an image" , EOL;
+echo date('H:i:s'), " Generate an image", EOL;
 $gdImage = @imagecreatetruecolor(120, 20) or die('Cannot Initialize new GD image stream');
 $textColor = imagecolorallocate($gdImage, 255, 255, 255);
-imagestring($gdImage, 1, 5, 5,  'Created with PHPExcel', $textColor);
+imagestring($gdImage, 1, 5, 5, 'Created with PHPExcel', $textColor);
 
 // Add a drawing to the worksheet
-echo date('H:i:s') , " Add a drawing to the worksheet" , EOL;
+echo date('H:i:s'), " Add a drawing to the worksheet", EOL;
 $objDrawing = new \PHPExcel\Worksheet\MemoryDrawing();
 $objDrawing->setName('Sample image');
 $objDrawing->setDescription('Sample image');
@@ -69,21 +69,21 @@ 
 $objDrawing->setHeight(36);
 $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
 
-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') , " Write to HTML format" , EOL;
+echo date('H:i:s'), " Write to HTML format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
 $objWriter->save(str_replace('.php', '.html', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.html', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.html', 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 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'Files have been created in ', getcwd(), EOL;

Indentation +6 added lines, -6 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");
 
 
 // Add some data

Examples/38cloneWorksheet.php

Spacing +15 added lines, -15 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;
 $objPHPExcel->setActiveSheetIndex(0)
             ->setCellValue('A1', 'Hello')
             ->setCellValue('B2', 'world!')
@@ -66,18 +66,18 @@ 
             ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
 
 
-$objPHPExcel->getActiveSheet()->setCellValue('A8',"Hello\nWorld");
+$objPHPExcel->getActiveSheet()->setCellValue('A8', "Hello\nWorld");
 $objPHPExcel->getActiveSheet()->getRowDimension(8)->setRowHeight(-1);
 $objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true);
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Simple');
 
 
 // Clone worksheet
-echo date('H:i:s') , " Clone worksheet" , EOL;
+echo date('H:i:s'), " Clone worksheet", EOL;
 $clonedSheet = clone $objPHPExcel->getActiveSheet();
 $clonedSheet
     ->setCellValue('A1', 'Goodbye')
@@ -86,7 +86,7 @@ 
     ->setCellValue('C2', 'cruel');
 
 // Rename cloned worksheet
-echo date('H:i:s') , " Rename cloned worksheet" , EOL;
+echo date('H:i:s'), " Rename cloned worksheet", EOL;
 $clonedSheet->setTitle('Simple Clone');
 $objPHPExcel->addSheet($clonedSheet);
 
@@ -96,7 +96,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');
@@ -104,15 +104,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 files" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing files", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Indentation +6 added lines, -6 removed lines

@@ -44,12 +44,12 @@
 // 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");
 
 
 // Add some data

Examples/02types.php

Indentation +6 added lines, -6 removed lines

@@ -45,12 +45,12 @@
 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");
 
 // Set default font
 echo date('H:i:s') , " Set default font" , EOL;

Spacing +22 added lines, -22 removed lines

@@ -30,18 +30,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 PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 
 // Create new PhpSpreadsheet object
-echo date('H:i:s') , " Create new PhpSpreadsheet object" , EOL;
+echo date('H:i:s'), " Create new PhpSpreadsheet object", EOL;
 $objPhpSpreadsheet = new \PhpSpreadsheet\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPhpSpreadsheet->getProperties()
     ->setCreator("Maarten Balliauw")
 	->setLastModifiedBy("Maarten Balliauw")
@@ -52,14 +52,14 @@ 
 	->setCategory("Test result file");
 
 // Set default font
-echo date('H:i:s') , " Set default font" , EOL;
+echo date('H:i:s'), " Set default font", EOL;
 $objPhpSpreadsheet->getDefaultStyle()
     ->getFont()
     ->setName('Arial')
     ->setSize(10);
 
 // Add some data, resembling some different data types
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A1', 'String')
     ->setCellValue('B1', 'Simple')
@@ -104,7 +104,7 @@ 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A9', 'Date/Time')
     ->setCellValue('B9', 'Date')
-    ->setCellValue('C9', \PhpSpreadsheet\Shared\Date::PHPToExcel( $dateTimeNow ));
+    ->setCellValue('C9', \PhpSpreadsheet\Shared\Date::PHPToExcel($dateTimeNow));
 $objPhpSpreadsheet->getActiveSheet()
     ->getStyle('C9')
     ->getNumberFormat()
@@ -113,7 +113,7 @@ 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A10', 'Date/Time')
     ->setCellValue('B10', 'Time')
-    ->setCellValue('C10', \PhpSpreadsheet\Shared\Date::PHPToExcel( $dateTimeNow ));
+    ->setCellValue('C10', \PhpSpreadsheet\Shared\Date::PHPToExcel($dateTimeNow));
 $objPhpSpreadsheet->getActiveSheet()
     ->getStyle('C10')
     ->getNumberFormat()
@@ -122,7 +122,7 @@ 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A11', 'Date/Time')
     ->setCellValue('B11', 'Date and Time')
-    ->setCellValue('C11', \PhpSpreadsheet\Shared\Date::PHPToExcel( $dateTimeNow ));
+    ->setCellValue('C11', \PhpSpreadsheet\Shared\Date::PHPToExcel($dateTimeNow));
 $objPhpSpreadsheet->getActiveSheet()
     ->getStyle('C11')
     ->getNumberFormat()
@@ -138,7 +138,7 @@ 
 $objPayable = $objRichText->createTextRun('你 好 吗？');
 $objPayable->getFont()->setBold(true);
 $objPayable->getFont()->setItalic(true);
-$objPayable->getFont()->setColor( new \PhpSpreadsheet\Style\Color( \PhpSpreadsheet\Style\Color::COLOR_DARKGREEN ) );
+$objPayable->getFont()->setColor(new \PhpSpreadsheet\Style\Color(\PhpSpreadsheet\Style\Color::COLOR_DARKGREEN));
 
 $objRichText->createText(', unless specified otherwise on the invoice.');
 
@@ -151,7 +151,7 @@ 
 $objRichText2->createText("black text\n");
 
 $objRed = $objRichText2->createTextRun("red text");
-$objRed->getFont()->setColor( new \PhpSpreadsheet\Style\Color(\PhpSpreadsheet\Style\Color::COLOR_RED ) );
+$objRed->getFont()->setColor(new \PhpSpreadsheet\Style\Color(\PhpSpreadsheet\Style\Color::COLOR_RED));
 
 $objPhpSpreadsheet->getActiveSheet()
     ->getCell("C14")
@@ -183,7 +183,7 @@ 
     ->setAutoSize(true);
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPhpSpreadsheet->getActiveSheet()->setTitle('Datatypes');
 
 
@@ -192,7 +192,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 = \PhpSpreadsheet\IOFactory::createWriter($objPhpSpreadsheet, 'Excel2007');
@@ -200,14 +200,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 5 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 = \PhpSpreadsheet\IOFactory::createWriter($objPhpSpreadsheet, 'Excel5');
@@ -215,15 +215,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 testing file" , EOL;
-echo 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done testing file", EOL;
+echo 'Files have been created in ', getcwd(), EOL;

Examples/33chartcreate-multiple-charts.php

Indentation +49 added lines, -49 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),
+    )
 );
 
 
@@ -61,9 +61,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels1 = 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
@@ -73,7 +73,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -83,19 +83,19 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues1 = 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
 $series1 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
-	range(0, count($dataSeriesValues1)-1),					// plotOrder
-	$dataSeriesLabels1,										// plotLabel
-	$xAxisTickValues1,										// plotCategory
-	$dataSeriesValues1										// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
+    range(0, count($dataSeriesValues1)-1),					// plotOrder
+    $dataSeriesLabels1,										// plotLabel
+    $xAxisTickValues1,										// plotCategory
+    $dataSeriesValues1										// plotValues
 );
 
 //	Set the series in the plot area
@@ -109,14 +109,14 @@ 
 
 //	Create the chart
 $chart1 = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title1,		// title
-	$legend1,		// legend
-	$plotArea1,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel1	// yAxisLabel
+    'chart1',		// name
+    $title1,		// title
+    $legend1,		// legend
+    $plotArea1,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel1	// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet
@@ -135,9 +135,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels2 = 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
@@ -147,7 +147,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -157,19 +157,19 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues2 = 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
 $series2 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels2,								// plotLabel
-	$xAxisTickValues2,								// plotCategory
-	$dataSeriesValues2								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
+    range(0, count($dataSeriesValues2)-1),			// plotOrder
+    $dataSeriesLabels2,								// plotLabel
+    $xAxisTickValues2,								// plotCategory
+    $dataSeriesValues2								// plotValues
 );
 //	Set additional dataseries parameters
 //		Make it a vertical column rather than a horizontal bar graph
@@ -186,14 +186,14 @@ 
 
 //	Create the chart
 $chart2 = new \PHPExcel\Chart(
-	'chart2',		// name
-	$title2,		// title
-	$legend2,		// legend
-	$plotArea2,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel2	// yAxisLabel
+    'chart2',		// name
+    $title2,		// title
+    $legend2,		// legend
+    $plotArea2,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel2	// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Spacing +43 added lines, -43 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),
 	)
 );
 
@@ -61,9 +61,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels1 = 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
@@ -73,7 +73,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), //	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -90,11 +90,11 @@ 
 
 //	Build the dataseries
 $series1 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
-	range(0, count($dataSeriesValues1)-1),					// plotOrder
-	$dataSeriesLabels1,										// plotLabel
-	$xAxisTickValues1,										// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping
+	range(0, count($dataSeriesValues1) - 1), // plotOrder
+	$dataSeriesLabels1, // plotLabel
+	$xAxisTickValues1, // plotCategory
 	$dataSeriesValues1										// plotValues
 );
 
@@ -109,13 +109,13 @@ 
 
 //	Create the chart
 $chart1 = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title1,		// title
-	$legend1,		// legend
-	$plotArea1,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
+	'chart1', // name
+	$title1, // title
+	$legend1, // legend
+	$plotArea1, // plotArea
+	true, // plotVisibleOnly
+	0, // displayBlanksAs
+	NULL, // xAxisLabel
 	$yAxisLabel1	// yAxisLabel
 );
 
@@ -135,9 +135,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels2 = 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
@@ -147,7 +147,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), //	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -164,11 +164,11 @@ 
 
 //	Build the dataseries
 $series2 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels2,								// plotLabel
-	$xAxisTickValues2,								// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping
+	range(0, count($dataSeriesValues2) - 1), // plotOrder
+	$dataSeriesLabels2, // plotLabel
+	$xAxisTickValues2, // plotCategory
 	$dataSeriesValues2								// plotValues
 );
 //	Set additional dataseries parameters
@@ -186,13 +186,13 @@ 
 
 //	Create the chart
 $chart2 = new \PHPExcel\Chart(
-	'chart2',		// name
-	$title2,		// title
-	$legend2,		// legend
-	$plotArea2,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
+	'chart2', // name
+	$title2, // title
+	$legend2, // legend
+	$plotArea2, // plotArea
+	true, // plotVisibleOnly
+	0, // displayBlanksAs
+	NULL, // xAxisLabel
 	$yAxisLabel2	// yAxisLabel
 );
 
@@ -205,16 +205,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/20readexcel5.php

Indentation +1 added lines, -1 removed lines

@@ -40,7 +40,7 @@
 

 

 if (!file_exists("14excel5.xls")) {

-	exit("Please run 14excel5.php first.\n");

+    exit("Please run 14excel5.php first.\n");

 }

 

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

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

 

@@ -43,7 +43,7 @@ 
 	exit("Please run 14excel5.php first.\n");

 }

 

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

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

 $callStartTime = microtime(true);

 

 $objPHPExcel = \PHPExcel\IOFactory::load("14excel5.xls");

@@ -51,13 +51,13 @@ 
 $callEndTime = microtime(true);

 $callTime = $callEndTime - $callStartTime;

 

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

+echo 'Call time to load 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 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');

@@ -65,15 +65,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 reading file" , EOL;

-echo 'File has been created in ' , getcwd() , EOL;

+echo date('H:i:s'), " Done reading file", EOL;

+echo 'File has been created in ', getcwd(), EOL;