PHPOffice / PhpSpreadsheet

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 +21 added lines, -21 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")
@@ -53,14 +53,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;
 $objPHPExcel->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;
 $objPHPExcel->getActiveSheet()
     ->setCellValue('A1', 'String')
     ->setCellValue('B1', 'Simple')
@@ -105,7 +105,7 @@ 
 $objPHPExcel->getActiveSheet()
     ->setCellValue('A9', 'Date/Time')
     ->setCellValue('B9', 'Date')
-    ->setCellValue('C9', \PHPExcel\Shared\Date::PHPToExcel( $dateTimeNow ));
+    ->setCellValue('C9', \PHPExcel\Shared\Date::PHPToExcel($dateTimeNow));
 $objPHPExcel->getActiveSheet()
     ->getStyle('C9')
     ->getNumberFormat()
@@ -114,7 +114,7 @@ 
 $objPHPExcel->getActiveSheet()
     ->setCellValue('A10', 'Date/Time')
     ->setCellValue('B10', 'Time')
-    ->setCellValue('C10', \PHPExcel\Shared\Date::PHPToExcel( $dateTimeNow ));
+    ->setCellValue('C10', \PHPExcel\Shared\Date::PHPToExcel($dateTimeNow));
 $objPHPExcel->getActiveSheet()
     ->getStyle('C10')
     ->getNumberFormat()
@@ -123,7 +123,7 @@ 
 $objPHPExcel->getActiveSheet()
     ->setCellValue('A11', 'Date/Time')
     ->setCellValue('B11', 'Date and Time')
-    ->setCellValue('C11', \PHPExcel\Shared\Date::PHPToExcel( $dateTimeNow ));
+    ->setCellValue('C11', \PHPExcel\Shared\Date::PHPToExcel($dateTimeNow));
 $objPHPExcel->getActiveSheet()
     ->getStyle('C11')
     ->getNumberFormat()
@@ -139,7 +139,7 @@ 
 $objPayable = $objRichText->createTextRun('你 好 吗？');
 $objPayable->getFont()->setBold(true);
 $objPayable->getFont()->setItalic(true);
-$objPayable->getFont()->setColor( new \PHPExcel\Style\Color( \PHPExcel\Style\Color::COLOR_DARKGREEN ) );
+$objPayable->getFont()->setColor(new \PHPExcel\Style\Color(\PHPExcel\Style\Color::COLOR_DARKGREEN));
 
 $objRichText->createText(', unless specified otherwise on the invoice.');
 
@@ -152,7 +152,7 @@ 
 $objRichText2->createText("black text\n");
 
 $objRed = $objRichText2->createTextRun("red text");
-$objRed->getFont()->setColor( new \PHPExcel\Style\Color(\PHPExcel\Style\Color::COLOR_RED  ) );
+$objRed->getFont()->setColor(new \PHPExcel\Style\Color(\PHPExcel\Style\Color::COLOR_RED));
 
 $objPHPExcel->getActiveSheet()
     ->getCell("C14")
@@ -179,7 +179,7 @@ 
     ->setAutoSize(true);
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Datatypes');
 
 
@@ -188,7 +188,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');
@@ -196,30 +196,30 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
-echo date('H:i:s') , " Reload workbook from saved file" , EOL;
+echo date('H:i:s'), " Reload workbook from saved file", EOL;
 $callStartTime = microtime(true);
 
 $objPHPExcel = \PHPExcel\IOFactory::load(str_replace('.php', '.xlsx', __FILE__));
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to reload Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to reload Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 var_dump($objPHPExcel->getActiveSheet()->toArray());
 
 
 // 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 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done testing file", EOL;
+echo 'File has 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;

Examples/Quadratic2.php

Indentation +19 added lines, -19 removed lines

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

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

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

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

-		echo 'The equation is not quadratic';

-	} else {

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

-		include 'PHPExcel/Calculation.php';

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

+        echo 'The equation is not quadratic';

+    } else {

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

+        include 'PHPExcel/Calculation.php';

 

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

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

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

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

 

-		$callStartTime = microtime(true);

-		$discriminantFormula = '=POWER('.$_POST['B'].',2) - (4 * '.$_POST['A'].' * '.$_POST['C'].')';

-		$discriminant = PHPExcel_Calculation::getInstance()->calculateFormula($discriminantFormula);

+        $callStartTime = microtime(true);

+        $discriminantFormula = '=POWER('.$_POST['B'].',2) - (4 * '.$_POST['A'].' * '.$_POST['C'].')';

+        $discriminant = PHPExcel_Calculation::getInstance()->calculateFormula($discriminantFormula);

 

-		$r1Formula = '=IMDIV(IMSUM(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].')';

-		$r2Formula = '=IF('.$discriminant.'=0,"Only one root",IMDIV(IMSUB(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].'))';

+        $r1Formula = '=IMDIV(IMSUM(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].')';

+        $r2Formula = '=IF('.$discriminant.'=0,"Only one root",IMDIV(IMSUB(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].'))';

 

-		echo PHPExcel_Calculation::getInstance()->calculateFormula($r1Formula).'<br />';

-		echo PHPExcel_Calculation::getInstance()->calculateFormula($r2Formula).'<br />';

-		$callEndTime = microtime(true);

-		$callTime = $callEndTime - $callStartTime;

+        echo PHPExcel_Calculation::getInstance()->calculateFormula($r1Formula).'<br />';

+        echo PHPExcel_Calculation::getInstance()->calculateFormula($r2Formula).'<br />';

+        $callEndTime = microtime(true);

+        $callTime = $callEndTime - $callStartTime;

 

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

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

-	}

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

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

+    }

 }

 

 ?>

Spacing +7 added lines, -7 removed lines

@@ -43,19 +43,19 @@
 		echo '<hr /><b>Roots:</b><br />';

 

 		$callStartTime = microtime(true);

-		$discriminantFormula = '=POWER('.$_POST['B'].',2) - (4 * '.$_POST['A'].' * '.$_POST['C'].')';

+		$discriminantFormula = '=POWER(' . $_POST['B'] . ',2) - (4 * ' . $_POST['A'] . ' * ' . $_POST['C'] . ')';

 		$discriminant = PHPExcel_Calculation::getInstance()->calculateFormula($discriminantFormula);

 

-		$r1Formula = '=IMDIV(IMSUM(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].')';

-		$r2Formula = '=IF('.$discriminant.'=0,"Only one root",IMDIV(IMSUB(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].'))';

+		$r1Formula = '=IMDIV(IMSUM(-' . $_POST['B'] . ',IMSQRT(' . $discriminant . ')),2 * ' . $_POST['A'] . ')';

+		$r2Formula = '=IF(' . $discriminant . '=0,"Only one root",IMDIV(IMSUB(-' . $_POST['B'] . ',IMSQRT(' . $discriminant . ')),2 * ' . $_POST['A'] . '))';

 

-		echo PHPExcel_Calculation::getInstance()->calculateFormula($r1Formula).'<br />';

-		echo PHPExcel_Calculation::getInstance()->calculateFormula($r2Formula).'<br />';

+		echo PHPExcel_Calculation::getInstance()->calculateFormula($r1Formula) . '<br />';

+		echo PHPExcel_Calculation::getInstance()->calculateFormula($r2Formula) . '<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/33chartcreate-composite.php

Indentation +48 added lines, -48 removed lines

@@ -43,21 +43,21 @@ 
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',		'Rainfall (mm)',	'Temperature (°F)',	'Humidity (%)'),
-		array('Jan',		78,   				52,					61),
-		array('Feb',		64,   				54,					62),
-		array('Mar',		62,   				57,					63),
-		array('Apr',		21,   				62,					59),
-		array('May',		11,   				75,					60),
-		array('Jun',		1,   				75,					57),
-		array('Jul',		1,   				79,					56),
-		array('Aug',		1,   				79,					59),
-		array('Sep',		10,   				75,					60),
-		array('Oct',		40,   				68,					63),
-		array('Nov',		69,   				62,					64),
-		array('Dec',		89,   				57,					66),
-	)
+    array(
+        array('',		'Rainfall (mm)',	'Temperature (°F)',	'Humidity (%)'),
+        array('Jan',		78,   				52,					61),
+        array('Feb',		64,   				54,					62),
+        array('Mar',		62,   				57,					63),
+        array('Apr',		21,   				62,					59),
+        array('May',		11,   				75,					60),
+        array('Jun',		1,   				75,					57),
+        array('Jul',		1,   				79,					56),
+        array('Aug',		1,   				79,					59),
+        array('Sep',		10,   				75,					60),
+        array('Oct',		40,   				68,					63),
+        array('Nov',		69,   				62,					64),
+        array('Dec',		89,   				57,					66),
+    )
 );
 
 
@@ -69,13 +69,13 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	Temperature
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	Temperature
 );
 $dataSeriesLabels2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	Rainfall
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	Rainfall
 );
 $dataSeriesLabels3 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	Humidity
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	Humidity
 );
 
 //	Set the X-Axis Labels
@@ -86,7 +86,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
 );
 
 
@@ -98,17 +98,17 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$13', NULL, 12),
 );
 
 //	Build the dataseries
 $series1 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
-	range(0, count($dataSeriesValues1)-1),			// plotOrder
-	$dataSeriesLabels1,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues1								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
+    range(0, count($dataSeriesValues1)-1),			// plotOrder
+    $dataSeriesLabels1,								// plotLabel
+    $xAxisTickValues,								// plotCategory
+    $dataSeriesValues1								// plotValues
 );
 //	Set additional dataseries parameters
 //		Make it a vertical column rather than a horizontal bar graph
@@ -123,17 +123,17 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
 );
 
 //	Build the dataseries
 $series2 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_LINECHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels2,								// plotLabel
-	NULL,											// plotCategory
-	$dataSeriesValues2								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_LINECHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
+    range(0, count($dataSeriesValues2)-1),			// plotOrder
+    $dataSeriesLabels2,								// plotLabel
+    NULL,											// plotCategory
+    $dataSeriesValues2								// plotValues
 );
 
 
@@ -145,17 +145,17 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues3 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
 );
 
 //	Build the dataseries
 $series3 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_AREACHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels3,								// plotLabel
-	NULL,											// plotCategory
-	$dataSeriesValues3								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_AREACHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
+    range(0, count($dataSeriesValues2)-1),			// plotOrder
+    $dataSeriesLabels3,								// plotLabel
+    NULL,											// plotCategory
+    $dataSeriesValues3								// plotValues
 );
 
 
@@ -169,14 +169,14 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	NULL			// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    NULL			// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Spacing +45 added lines, -45 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,19 +44,19 @@ 
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
 	array(
-		array('',		'Rainfall (mm)',	'Temperature (°F)',	'Humidity (%)'),
-		array('Jan',		78,   				52,					61),
-		array('Feb',		64,   				54,					62),
-		array('Mar',		62,   				57,					63),
-		array('Apr',		21,   				62,					59),
-		array('May',		11,   				75,					60),
-		array('Jun',		1,   				75,					57),
-		array('Jul',		1,   				79,					56),
-		array('Aug',		1,   				79,					59),
-		array('Sep',		10,   				75,					60),
-		array('Oct',		40,   				68,					63),
-		array('Nov',		69,   				62,					64),
-		array('Dec',		89,   				57,					66),
+		array('', 'Rainfall (mm)', 'Temperature (°F)', 'Humidity (%)'),
+		array('Jan', 78, 52, 61),
+		array('Feb', 64, 54, 62),
+		array('Mar', 62, 57, 63),
+		array('Apr', 21, 62, 59),
+		array('May', 11, 75, 60),
+		array('Jun', 1, 75, 57),
+		array('Jul', 1, 79, 56),
+		array('Aug', 1, 79, 59),
+		array('Sep', 10, 75, 60),
+		array('Oct', 40, 68, 63),
+		array('Nov', 69, 62, 64),
+		array('Dec', 89, 57, 66),
 	)
 );
 
@@ -69,13 +69,13 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	Temperature
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), //	Temperature
 );
 $dataSeriesLabels2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	Rainfall
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), //	Rainfall
 );
 $dataSeriesLabels3 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	Humidity
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), //	Humidity
 );
 
 //	Set the X-Axis Labels
@@ -86,7 +86,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), //	Jan to Dec
 );
 
 
@@ -103,11 +103,11 @@ 
 
 //	Build the dataseries
 $series1 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
-	range(0, count($dataSeriesValues1)-1),			// plotOrder
-	$dataSeriesLabels1,								// plotLabel
-	$xAxisTickValues,								// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED, // plotGrouping
+	range(0, count($dataSeriesValues1) - 1), // plotOrder
+	$dataSeriesLabels1, // plotLabel
+	$xAxisTickValues, // plotCategory
 	$dataSeriesValues1								// plotValues
 );
 //	Set additional dataseries parameters
@@ -128,11 +128,11 @@ 
 
 //	Build the dataseries
 $series2 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_LINECHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels2,								// plotLabel
-	NULL,											// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_LINECHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping
+	range(0, count($dataSeriesValues2) - 1), // plotOrder
+	$dataSeriesLabels2, // plotLabel
+	NULL, // plotCategory
 	$dataSeriesValues2								// plotValues
 );
 
@@ -150,11 +150,11 @@ 
 
 //	Build the dataseries
 $series3 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_AREACHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels3,								// plotLabel
-	NULL,											// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping
+	range(0, count($dataSeriesValues2) - 1), // plotOrder
+	$dataSeriesLabels3, // plotLabel
+	NULL, // plotCategory
 	$dataSeriesValues3								// plotValues
 );
 
@@ -169,13 +169,13 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
+	'chart1', // name
+	$title, // title
+	$legend, // legend
+	$plotArea, // plotArea
+	true, // plotVisibleOnly
+	0, // displayBlanksAs
+	NULL, // xAxisLabel
 	NULL			// yAxisLabel
 );
 
@@ -188,16 +188,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/06largescale.php

Spacing +15 added lines, -15 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -53,11 +53,11 @@ 
 */
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set properties" , EOL;
+echo date('H:i:s'), " Set properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -68,7 +68,7 @@ 
 
 
 // Create a first sheet
-echo date('H:i:s') , " Add data" , EOL;
+echo date('H:i:s'), " Add data", EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname");
 $objPHPExcel->getActiveSheet()->setCellValue('B1', "Lastname");
@@ -78,24 +78,24 @@ 
 
 
 // Hide "Phone" and "fax" column
-echo date('H:i:s') , " Hide 'Phone' and 'fax' columns" , EOL;
+echo date('H:i:s'), " Hide 'Phone' and 'fax' columns", EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
 $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);
 
 
 // Set outline levels
-echo date('H:i:s') , " Set outline levels" , EOL;
+echo date('H:i:s'), " Set outline levels", EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
                                                        ->setVisible(false)
                                                        ->setCollapsed(true);
 
 // Freeze panes
-echo date('H:i:s') , " Freeze panes" , EOL;
+echo date('H:i:s'), " Freeze panes", EOL;
 $objPHPExcel->getActiveSheet()->freezePane('A2');
 
 
 // Rows to repeat at top
-echo date('H:i:s') , " Rows to repeat at top" , EOL;
+echo date('H:i:s'), " Rows to repeat at top", EOL;
 $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 1);
 
 
@@ -114,7 +114,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -122,15 +122,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Indentation +13 added lines, -13 removed lines

@@ -52,12 +52,12 @@ 
 // Set document properties
 echo date('H:i:s') , " Set properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Create a first sheet
@@ -79,8 +79,8 @@ 
 // Set outline levels
 echo date('H:i:s') , " Set outline levels" , EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
-                                                       ->setVisible(false)
-                                                       ->setCollapsed(true);
+                                                        ->setVisible(false)
+                                                        ->setCollapsed(true);
 
 // Freeze panes
 echo date('H:i:s') , " Freeze panes" , EOL;
@@ -94,11 +94,11 @@ 
 
 // Add data
 for ($i = 2; $i <= 5000; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
-	                              ->setCellValue('B' . $i, "LName $i")
-	                              ->setCellValue('C' . $i, "PhoneNo $i")
-	                              ->setCellValue('D' . $i, "FaxNo $i")
-	                              ->setCellValue('E' . $i, true);
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
+                                    ->setCellValue('B' . $i, "LName $i")
+                                    ->setCellValue('C' . $i, "PhoneNo $i")
+                                    ->setCellValue('D' . $i, "FaxNo $i")
+                                    ->setCellValue('E' . $i, true);
 }
 
 

Examples/09pagebreaks.php

Indentation +21 added lines, -21 removed lines

@@ -45,37 +45,37 @@
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Create a first sheet
 echo date('H:i:s') , " Add data and page breaks" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname")
-                              ->setCellValue('B1', "Lastname")
-                              ->setCellValue('C1', "Phone")
-                              ->setCellValue('D1', "Fax")
-                              ->setCellValue('E1', "Is Client ?");
+                                ->setCellValue('B1', "Lastname")
+                                ->setCellValue('C1', "Phone")
+                                ->setCellValue('D1', "Fax")
+                                ->setCellValue('E1', "Is Client ?");
 
 
 // Add data
 for ($i = 2; $i <= 50; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, "LName $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, "PhoneNo $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, "FaxNo $i");
-	$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, true);
-
-	// Add page breaks every 10 rows
-	if ($i % 10 == 0) {
-		// Add a page break
-		$objPHPExcel->getActiveSheet()->setBreak( 'A' . $i, \PHPExcel\Worksheet::BREAK_ROW );
-	}
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, "LName $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, "PhoneNo $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, "FaxNo $i");
+    $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, true);
+
+    // Add page breaks every 10 rows
+    if ($i % 10 == 0) {
+        // Add a page break
+        $objPHPExcel->getActiveSheet()->setBreak( 'A' . $i, \PHPExcel\Worksheet::BREAK_ROW );
+    }
 }
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet

Spacing +16 added lines, -16 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -39,11 +39,11 @@ 
 
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -54,7 +54,7 @@ 
 
 
 // Create a first sheet
-echo date('H:i:s') , " Add data and page breaks" , EOL;
+echo date('H:i:s'), " Add data and page breaks", EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname")
                               ->setCellValue('B1', "Lastname")
@@ -74,7 +74,7 @@ 
 	// Add page breaks every 10 rows
 	if ($i % 10 == 0) {
 		// Add a page break
-		$objPHPExcel->getActiveSheet()->setBreak( 'A' . $i, \PHPExcel\Worksheet::BREAK_ROW );
+		$objPHPExcel->getActiveSheet()->setBreak('A' . $i, \PHPExcel\Worksheet::BREAK_ROW);
 	}
 }
 
@@ -97,7 +97,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -105,14 +105,14 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -120,15 +120,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing files" , EOL;
-echo 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing files", EOL;
+echo 'Files have been created in ', getcwd(), EOL;