PHPOffice / PhpSpreadsheet

Examples/02types.php

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/03formulas.php

Spacing +28 added lines, -28 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 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")
 	->setTitle("Office 2007 XLSX Test Document")
@@ -53,7 +53,7 @@ 
 
 
 // Add some data, we will use some formulas here
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A5', 'Sum:');
 
@@ -62,55 +62,55 @@ 
     ->setCellValue('B3', 7)
     ->setCellValue('B4', 13)
     ->setCellValue('B5', '=SUM(B2:B4)');
-echo date('H:i:s') , " Sum of Range #1 is " ,
+echo date('H:i:s'), " Sum of Range #1 is ",
 $objPhpSpreadsheet->getActiveSheet()
     ->getCell('B5')
-    ->getCalculatedValue() , EOL;
+    ->getCalculatedValue(), EOL;
 
 $objPhpSpreadsheet->getActiveSheet()->setCellValue('C1', 'Range #2')
     ->setCellValue('C2', 5)
     ->setCellValue('C3', 11)
     ->setCellValue('C4', 17)
     ->setCellValue('C5', '=SUM(C2:C4)');
-echo date('H:i:s') , " Sum of Range #2 is " ,
+echo date('H:i:s'), " Sum of Range #2 is ",
 $objPhpSpreadsheet->getActiveSheet()
     ->getCell('C5')
-    ->getCalculatedValue() , EOL;
+    ->getCalculatedValue(), EOL;
 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A7', 'Total of both ranges:');
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('B7', '=SUM(B5:C5)');
-echo date('H:i:s') , " Sum of both Ranges is " ,
+echo date('H:i:s'), " Sum of both Ranges is ",
 $objPhpSpreadsheet->getActiveSheet()
     ->getCell('B7')
-    ->getCalculatedValue() , EOL;
+    ->getCalculatedValue(), EOL;
 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A8', 'Minimum of both ranges:');
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('B8', '=MIN(B2:C4)');
-echo date('H:i:s') , " Minimum value in either Range is " ,
+echo date('H:i:s'), " Minimum value in either Range is ",
 $objPhpSpreadsheet->getActiveSheet()
     ->getCell('B8')
-    ->getCalculatedValue() , EOL;
+    ->getCalculatedValue(), EOL;
 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A9', 'Maximum of both ranges:');
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('B9', '=MAX(B2:C4)');
-echo date('H:i:s') , " Maximum value in either Range is " ,
+echo date('H:i:s'), " Maximum value in either Range is ",
 $objPhpSpreadsheet->getActiveSheet()
     ->getCell('B9')
-    ->getCalculatedValue() , EOL;
+    ->getCalculatedValue(), EOL;
 
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('A10', 'Average of both ranges:');
 $objPhpSpreadsheet->getActiveSheet()
     ->setCellValue('B10', '=AVERAGE(B2:C4)');
-echo date('H:i:s') , " Average value of both Ranges is " ,
+echo date('H:i:s'), " Average value of both Ranges is ",
 $objPhpSpreadsheet->getActiveSheet()
-    ->getCell('B10')->getCalculatedValue() , EOL;
+    ->getCell('B10')->getCalculatedValue(), EOL;
 
 
 $objPhpSpreadsheet->getActiveSheet()
@@ -119,7 +119,7 @@ 
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPhpSpreadsheet->getActiveSheet()
     ->setTitle('Formulas');
 
@@ -129,7 +129,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');
@@ -146,14 +146,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 = \PhpSpreadsheet\IOFactory::createWriter($objPhpSpreadsheet, 'Excel5');
@@ -161,15 +161,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/01simple-download-xls.php

Indentation +7 added lines, -7 removed lines

@@ -31,7 +31,7 @@ 
 date_default_timezone_set('Europe/London');
 
 if (PHP_SAPI == 'cli')
-	die('This example should only be run from a Web Browser');
+    die('This example should only be run from a Web Browser');
 
 /** Include PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -42,12 +42,12 @@ 
 
 // Set document properties
 $objPhpSpreadsheet->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/01simple-download-xlsx.php

Indentation +7 added lines, -7 removed lines

@@ -31,7 +31,7 @@ 
 date_default_timezone_set('Europe/London');
 
 if (PHP_SAPI == 'cli')
-	die('This example should only be run from a Web Browser');
+    die('This example should only be run from a Web Browser');
 
 /** Include PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -42,12 +42,12 @@ 
 
 // Set document properties
 $objPhpSpreadsheet->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/01simple-download-ods.php

Indentation +7 added lines, -7 removed lines

@@ -31,7 +31,7 @@ 
 date_default_timezone_set('Europe/London');
 
 if (PHP_SAPI == 'cli')
-	die('This example should only be run from a Web Browser');
+    die('This example should only be run from a Web Browser');
 
 /** Include PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -42,12 +42,12 @@ 
 
 // Set document properties
 $objPhpSpreadsheet->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/01simple-download-pdf.php

Indentation +14 added lines, -14 removed lines

@@ -31,7 +31,7 @@ 
 date_default_timezone_set('Europe/London');
 
 if (PHP_SAPI == 'cli')
-	die('This example should only be run from a Web Browser');
+    die('This example should only be run from a Web Browser');
 
 /** Include PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -53,12 +53,12 @@ 
 
 // Set document properties
 $objPhpSpreadsheet->getProperties()->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("PDF Test Document")
-	->setSubject("PDF Test Document")
-	->setDescription("Test document for PDF, generated using PHP classes.")
-	->setKeywords("pdf php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("PDF Test Document")
+    ->setSubject("PDF Test Document")
+    ->setDescription("Test document for PDF, generated using PHP classes.")
+    ->setKeywords("pdf php")
+    ->setCategory("Test result file");
 
 
 // Add some data
@@ -83,13 +83,13 @@ 
 
 if (!PhpSpreadsheet\Settings::setPdfRenderer(
         $rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		'<br />' .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        '<br />' .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 

Examples/01simple.php

Indentation +6 added lines, -6 removed lines

@@ -44,12 +44,12 @@
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPhpSpreadsheet->getProperties()
     ->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("PhpSpreadsheet Test Document")
-	->setSubject("PhpSpreadsheet Test Document")
-	->setDescription("Test document for PhpSpreadsheet, generated using PHP classes.")
-	->setKeywords("office PhpSpreadsheet php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("PhpSpreadsheet Test Document")
+    ->setSubject("PhpSpreadsheet Test Document")
+    ->setDescription("Test document for PhpSpreadsheet, generated using PHP classes.")
+    ->setKeywords("office PhpSpreadsheet php")
+    ->setCategory("Test result file");
 
 
 // Add some data

Spacing +17 added lines, -17 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 Spreadsheet object
-echo date('H:i:s') , " Create new Spreadsheet object" , EOL;
+echo date('H:i:s'), " Create new Spreadsheet 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")
@@ -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;
 $objPhpSpreadsheet->setActiveSheetIndex(0)
     ->setCellValue('A1', 'Hello')
     ->setCellValue('B2', 'world!')
@@ -67,7 +67,7 @@ 
 
 
 $objPhpSpreadsheet->getActiveSheet()
-    ->setCellValue('A8',"Hello\nWorld");
+    ->setCellValue('A8', "Hello\nWorld");
 $objPhpSpreadsheet->getActiveSheet()
     ->getRowDimension(8)
     ->setRowHeight(-1);
@@ -93,7 +93,7 @@ 
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPhpSpreadsheet->getActiveSheet()
     ->setTitle('Simple');
 
@@ -103,7 +103,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PhpSpreadsheet\IOFactory::createWriter($objPhpSpreadsheet, 'Excel2007');
@@ -111,14 +111,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 = \PhpSpreadsheet\IOFactory::createWriter($objPhpSpreadsheet, 'Excel5');
@@ -126,15 +126,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/01simplePCLZip.php

Indentation +6 added lines, -6 removed lines

@@ -43,12 +43,12 @@
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPhpSpreadsheet->getProperties()->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("PhpSpreadsheet Test Document")
-	->setSubject("PhpSpreadsheet Test Document")
-	->setDescription("Test document for PhpSpreadsheet, generated using PHP classes.")
-	->setKeywords("office PhpSpreadsheet php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("PhpSpreadsheet Test Document")
+    ->setSubject("PhpSpreadsheet Test Document")
+    ->setDescription("Test document for PhpSpreadsheet, generated using PHP classes.")
+    ->setKeywords("office PhpSpreadsheet php")
+    ->setCategory("Test result file");
 
 
 // Add some data

Spacing +13 added lines, -13 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")
 	->setTitle("PhpSpreadsheet Test Document")
@@ -52,7 +52,7 @@ 
 
 
 // Add some data
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPhpSpreadsheet->setActiveSheetIndex(0)
     ->setCellValue('A1', 'Hello')
     ->setCellValue('B2', 'world!')
@@ -65,13 +65,13 @@ 
     ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
 
 
-$objPhpSpreadsheet->getActiveSheet()->setCellValue('A8',"Hello\nWorld");
+$objPhpSpreadsheet->getActiveSheet()->setCellValue('A8', "Hello\nWorld");
 $objPhpSpreadsheet->getActiveSheet()->getRowDimension(8)->setRowHeight(-1);
 $objPhpSpreadsheet->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true);
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPhpSpreadsheet->getActiveSheet()->setTitle('Simple');
 
 
@@ -80,7 +80,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);
 
 // Use PCLZip rather than ZipArchive to create the Excel2007 OfficeOpenXML file
@@ -91,15 +91,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 '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/04printing.php

Indentation +7 added lines, -7 removed lines

@@ -46,18 +46,18 @@
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPhpSpreadsheet->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");
+    ->setTitle("Office 2007 XLSX Test Document")
+    ->setSubject("Office 2007 XLSX Test Document")
+    ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+    ->setKeywords("office 2007 openxml php")
+    ->setCategory("Test result file");
 
 
 // Add some data, we will use printing features
 echo date('H:i:s') , " Add some data" , EOL;
 for ($i = 1; $i < 200; $i++) {
-	$objPhpSpreadsheet->getActiveSheet()->setCellValue('A' . $i, $i);
-	$objPhpSpreadsheet->getActiveSheet()->setCellValue('B' . $i, 'Test value');
+    $objPhpSpreadsheet->getActiveSheet()->setCellValue('A' . $i, $i);
+    $objPhpSpreadsheet->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.

Spacing +19 added lines, -19 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -39,11 +39,11 @@ 
 
 
 // Create new 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")
 	->setTitle("Office 2007 XLSX Test Document")
@@ -54,14 +54,14 @@ 
 
 
 // Add some data, we will use printing features
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 for ($i = 1; $i < 200; $i++) {
 	$objPhpSpreadsheet->getActiveSheet()->setCellValue('A' . $i, $i);
 	$objPhpSpreadsheet->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.
-echo date('H:i:s') , " Set header/footer" , EOL;
+echo date('H:i:s'), " Set header/footer", EOL;
 $objPhpSpreadsheet->getActiveSheet()
     ->getHeaderFooter()
     ->setOddHeader('&L&G&C&HPlease treat this document as confidential!');
@@ -70,7 +70,7 @@ 
     ->setOddFooter('&L&B' . $objPhpSpreadsheet->getProperties()->getTitle() . '&RPage &P of &N');
 
 // Add a drawing to the header
-echo date('H:i:s') , " Add a drawing to the header" , EOL;
+echo date('H:i:s'), " Add a drawing to the header", EOL;
 $objDrawing = new \PhpSpreadsheet\Worksheet\HeaderFooterDrawing();
 $objDrawing->setName('PhpSpreadsheet logo');
 $objDrawing->setPath('./images/PhpSpreadsheet_logo.gif');
@@ -80,7 +80,7 @@ 
     ->addImage($objDrawing, \PhpSpreadsheet\Worksheet\HeaderFooter::IMAGE_HEADER_LEFT);
 
 // Set page orientation and size
-echo date('H:i:s') , " Set page orientation and size" , EOL;
+echo date('H:i:s'), " Set page orientation and size", EOL;
 $objPhpSpreadsheet->getActiveSheet()
     ->getPageSetup()
     ->setOrientation(\PhpSpreadsheet\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);
@@ -89,7 +89,7 @@ 
     ->setPaperSize(\PhpSpreadsheet\Worksheet\PageSetup::PAPERSIZE_A4);
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPhpSpreadsheet->getActiveSheet()->setTitle('Printing');
 
 
@@ -98,7 +98,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');
@@ -106,14 +106,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 = \PhpSpreadsheet\IOFactory::createWriter($objPhpSpreadsheet, 'Excel5');
@@ -121,15 +121,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;