Inspection of "Introduce PHP-CS-Fixer for stricter code style rul..." - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 685e29...09d456 )

by Adrien

created 2016-08-16 15:35 UTC

Status

Spacing +73 added lines, -73 removed lines patch added patch discarded remove patch

@@ -30,7 +30,7 @@  discard block
 block discarded – undo
 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');
 
@@ -38,11 +38,11 @@  discard block
 block discarded – undo
 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')
@@ -52,78 +52,78 @@  discard block
 block discarded – undo
 							 ->setCategory('Test result file');
 
 // Create the worksheet
-echo date('H:i:s').' Add data'.EOL;
+echo date('H:i:s') . ' Add data' . EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Year')
                               ->setCellValue('B1', 'Quarter')
                               ->setCellValue('C1', 'Country')
                               ->setCellValue('D1', 'Sales');
 
-$dataArray = array(array('2010',	'Q1',	'United States',	790),
-                   array('2010',	'Q2',	'United States',	730),
-                   array('2010',	'Q3',	'United States',	860),
-                   array('2010',	'Q4',	'United States',	850),
-                   array('2011',	'Q1',	'United States',	800),
-                   array('2011',	'Q2',	'United States',	700),
-                   array('2011',	'Q3',	'United States',	900),
-                   array('2011',	'Q4',	'United States',	950),
-                   array('2010',	'Q1',	'Belgium',			380),
-                   array('2010',	'Q2',	'Belgium',			390),
-                   array('2010',	'Q3',	'Belgium',			420),
-                   array('2010',	'Q4',	'Belgium',			460),
-                   array('2011',	'Q1',	'Belgium',			400),
-                   array('2011',	'Q2',	'Belgium',			350),
-                   array('2011',	'Q3',	'Belgium',			450),
-                   array('2011',	'Q4',	'Belgium',			500),
-                   array('2010',	'Q1',	'UK',				690),
-                   array('2010',	'Q2',	'UK',				610),
-                   array('2010',	'Q3',	'UK',				620),
-                   array('2010',	'Q4',	'UK',				600),
-                   array('2011',	'Q1',	'UK',				720),
-                   array('2011',	'Q2',	'UK',				650),
-                   array('2011',	'Q3',	'UK',				580),
-                   array('2011',	'Q4',	'UK',				510),
-                   array('2010',	'Q1',	'France',			510),
-                   array('2010',	'Q2',	'France',			490),
-                   array('2010',	'Q3',	'France',			460),
-                   array('2010',	'Q4',	'France', 			590),
-                   array('2011',	'Q1',	'France',			620),
-                   array('2011',	'Q2',	'France',			650),
-                   array('2011',	'Q3',	'France',			415),
-                   array('2011',	'Q4',	'France', 			570),
-                   array('2010',	'Q1',	'Germany',			720),
-                   array('2010',	'Q2',	'Germany',			680),
-                   array('2010',	'Q3',	'Germany',			640),
-                   array('2010',	'Q4',	'Germany',			660),
-                   array('2011',	'Q1',	'Germany',			680),
-                   array('2011',	'Q2',	'Germany',			620),
-                   array('2011',	'Q3',	'Germany',			710),
-                   array('2011',	'Q4',	'Germany',			690),
-                   array('2010',	'Q1',	'Spain',			510),
-                   array('2010',	'Q2',	'Spain',			490),
-                   array('2010',	'Q3',	'Spain',			470),
-                   array('2010',	'Q4',	'Spain',			420),
-                   array('2011',	'Q1',	'Spain',			460),
-                   array('2011',	'Q2',	'Spain',			390),
-                   array('2011',	'Q3',	'Spain',			430),
-                   array('2011',	'Q4',	'Spain',			415),
-                   array('2010',	'Q1',	'Italy',			440),
-                   array('2010',	'Q2',	'Italy',			410),
-                   array('2010',	'Q3',	'Italy',			420),
-                   array('2010',	'Q4',	'Italy',			450),
-                   array('2011',	'Q1',	'Italy',			430),
-                   array('2011',	'Q2',	'Italy',			370),
-                   array('2011',	'Q3',	'Italy',			350),
-                   array('2011',	'Q4',	'Italy',			335),
+$dataArray = array(array('2010', 'Q1', 'United States', 790),
+                   array('2010', 'Q2', 'United States', 730),
+                   array('2010', 'Q3', 'United States', 860),
+                   array('2010', 'Q4', 'United States', 850),
+                   array('2011', 'Q1', 'United States', 800),
+                   array('2011', 'Q2', 'United States', 700),
+                   array('2011', 'Q3', 'United States', 900),
+                   array('2011', 'Q4', 'United States', 950),
+                   array('2010', 'Q1', 'Belgium', 380),
+                   array('2010', 'Q2', 'Belgium', 390),
+                   array('2010', 'Q3', 'Belgium', 420),
+                   array('2010', 'Q4', 'Belgium', 460),
+                   array('2011', 'Q1', 'Belgium', 400),
+                   array('2011', 'Q2', 'Belgium', 350),
+                   array('2011', 'Q3', 'Belgium', 450),
+                   array('2011', 'Q4', 'Belgium', 500),
+                   array('2010', 'Q1', 'UK', 690),
+                   array('2010', 'Q2', 'UK', 610),
+                   array('2010', 'Q3', 'UK', 620),
+                   array('2010', 'Q4', 'UK', 600),
+                   array('2011', 'Q1', 'UK', 720),
+                   array('2011', 'Q2', 'UK', 650),
+                   array('2011', 'Q3', 'UK', 580),
+                   array('2011', 'Q4', 'UK', 510),
+                   array('2010', 'Q1', 'France', 510),
+                   array('2010', 'Q2', 'France', 490),
+                   array('2010', 'Q3', 'France', 460),
+                   array('2010', 'Q4', 'France', 590),
+                   array('2011', 'Q1', 'France', 620),
+                   array('2011', 'Q2', 'France', 650),
+                   array('2011', 'Q3', 'France', 415),
+                   array('2011', 'Q4', 'France', 570),
+                   array('2010', 'Q1', 'Germany', 720),
+                   array('2010', 'Q2', 'Germany', 680),
+                   array('2010', 'Q3', 'Germany', 640),
+                   array('2010', 'Q4', 'Germany', 660),
+                   array('2011', 'Q1', 'Germany', 680),
+                   array('2011', 'Q2', 'Germany', 620),
+                   array('2011', 'Q3', 'Germany', 710),
+                   array('2011', 'Q4', 'Germany', 690),
+                   array('2010', 'Q1', 'Spain', 510),
+                   array('2010', 'Q2', 'Spain', 490),
+                   array('2010', 'Q3', 'Spain', 470),
+                   array('2010', 'Q4', 'Spain', 420),
+                   array('2011', 'Q1', 'Spain', 460),
+                   array('2011', 'Q2', 'Spain', 390),
+                   array('2011', 'Q3', 'Spain', 430),
+                   array('2011', 'Q4', 'Spain', 415),
+                   array('2010', 'Q1', 'Italy', 440),
+                   array('2010', 'Q2', 'Italy', 410),
+                   array('2010', 'Q3', 'Italy', 420),
+                   array('2010', 'Q4', 'Italy', 450),
+                   array('2011', 'Q1', 'Italy', 430),
+                   array('2011', 'Q2', 'Italy', 370),
+                   array('2011', 'Q3', 'Italy', 350),
+                   array('2011', 'Q4', 'Italy', 335),
                   );
 $objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A2');
 
 // Set title row bold
-echo date('H:i:s').' Set title row bold'.EOL;
+echo date('H:i:s') . ' Set title row bold' . EOL;
 $objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setBold(true);
 
 // Set autofilter
-echo date('H:i:s').' Set autofilter'.EOL;
+echo date('H:i:s') . ' Set autofilter' . EOL;
 // Always include the complete filter range!
 // Excel does support setting only the caption
 // row, but that's not a best practise...
@@ -134,7 +134,7 @@  discard block
 block discarded – undo
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -142,14 +142,14 @@  discard block
 block discarded – undo
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -157,15 +157,15 @@  discard block
 block discarded – undo
 $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;

Please login to merge, or discard this patch.

Examples/28iterator.php 1 patch

Spacing +7 added lines, -7 removed lines patch added patch discarded remove patch

@@ -30,7 +30,7 @@  discard block
 block discarded – undo
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -41,22 +41,22 @@  discard block
 block discarded – undo
 	exit("Please run 05featuredemo.php first." . EOL);
 }
 
-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load from Excel2007 file", EOL;
 $objReader = \PHPExcel\IOFactory::createReader('Excel2007');
 $objPHPExcel = $objReader->load("05featuredemo.xlsx");
 
-echo date('H:i:s') , " Iterate worksheets" , EOL;
+echo date('H:i:s'), " Iterate worksheets", EOL;
 foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-	echo 'Worksheet - ' , $worksheet->getTitle() , EOL;
+	echo 'Worksheet - ', $worksheet->getTitle(), EOL;
 
 	foreach ($worksheet->getRowIterator() as $row) {
-		echo '    Row number - ' , $row->getRowIndex() , EOL;
+		echo '    Row number - ', $row->getRowIndex(), EOL;
 
 		$cellIterator = $row->getCellIterator();
 		$cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set
 		foreach ($cellIterator as $cell) {
 			if (!is_null($cell)) {
-				echo '        Cell - ' , $cell->getCoordinate() , ' - ' , $cell->getCalculatedValue() , EOL;
+				echo '        Cell - ', $cell->getCoordinate(), ' - ', $cell->getCalculatedValue(), EOL;
 			}
 		}
 	}
@@ -64,4 +64,4 @@  discard block
 block discarded – undo
 
 
 // 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;

Please login to merge, or discard this patch.

Examples/43mergeWorkbooks.php 1 patch

Spacing +15 added lines, -15 removed lines patch added patch discarded remove patch

@@ -29,7 +29,7 @@  discard block
 block discarded – undo
 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');
 
@@ -37,38 +37,38 @@  discard block
 block discarded – undo
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 
-echo date('H:i:s') , " Load MergeBook1 from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load MergeBook1 from Excel2007 file", EOL;
 $callStartTime = microtime(true);
 
 $objPHPExcel1 = \PHPExcel\IOFactory::load(dirname(__FILE__) . "/templates/43mergeBook1.xlsx");
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to read Mergebook1 was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to read Mergebook1 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') , " Load MergeBook2 from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load MergeBook2 from Excel2007 file", EOL;
 $callStartTime = microtime(true);
 
 $objPHPExcel2 = \PHPExcel\IOFactory::load(dirname(__FILE__) . "/templates/43mergeBook2.xlsx");
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to read Mergebook2 was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to read Mergebook2 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;
 
 
-foreach($objPHPExcel2->getSheetNames() as $sheetName) {
+foreach ($objPHPExcel2->getSheetNames() as $sheetName) {
     $sheet = $objPHPExcel2->getSheetByName($sheetName);
     $sheet->setTitle($sheet->getTitle() . ' copied');
     $objPHPExcel1->addExternalSheet($sheet);
 }
 
 
-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($objPHPExcel1, 'Excel2007');
@@ -77,15 +77,15 @@  discard block
 block discarded – undo
 $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;

Please login to merge, or discard this patch.

Examples/03formulas.php 1 patch

Spacing +28 added lines, -28 removed lines patch added patch discarded remove patch

@@ -31,18 +31,18 @@  discard block
 block discarded – undo
 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("Office 2007 XLSX Test Document")
@@ -53,7 +53,7 @@  discard block
 block discarded – undo
 
 
 // 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;
 $objPHPExcel->getActiveSheet()->setCellValue('A5', 'Sum:');
 
 $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Range #1')
@@ -61,40 +61,40 @@  discard block
 block discarded – undo
                               ->setCellValue('B3', 7)
                               ->setCellValue('B4', 13)
                               ->setCellValue('B5', '=SUM(B2:B4)');
-echo date('H:i:s') , " Sum of Range #1 is " ,
-                     $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Sum of Range #1 is ",
+                     $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue(), EOL;
 
 $objPHPExcel->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 " ,
-                     $objPHPExcel->getActiveSheet()->getCell('C5')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Sum of Range #2 is ",
+                     $objPHPExcel->getActiveSheet()->getCell('C5')->getCalculatedValue(), EOL;
 
 $objPHPExcel->getActiveSheet()->setCellValue('A7', 'Total of both ranges:');
 $objPHPExcel->getActiveSheet()->setCellValue('B7', '=SUM(B5:C5)');
-echo date('H:i:s') , " Sum of both Ranges is " ,
-                     $objPHPExcel->getActiveSheet()->getCell('B7')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Sum of both Ranges is ",
+                     $objPHPExcel->getActiveSheet()->getCell('B7')->getCalculatedValue(), EOL;
 
 $objPHPExcel->getActiveSheet()->setCellValue('A8', 'Minimum of both ranges:');
 $objPHPExcel->getActiveSheet()->setCellValue('B8', '=MIN(B2:C4)');
-echo date('H:i:s') , " Minimum value in either Range is " ,
-                     $objPHPExcel->getActiveSheet()->getCell('B8')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Minimum value in either Range is ",
+                     $objPHPExcel->getActiveSheet()->getCell('B8')->getCalculatedValue(), EOL;
 
 $objPHPExcel->getActiveSheet()->setCellValue('A9', 'Maximum of both ranges:');
 $objPHPExcel->getActiveSheet()->setCellValue('B9', '=MAX(B2:C4)');
-echo date('H:i:s') , " Maximum value in either Range is " ,
-                     $objPHPExcel->getActiveSheet()->getCell('B9')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Maximum value in either Range is ",
+                     $objPHPExcel->getActiveSheet()->getCell('B9')->getCalculatedValue(), EOL;
 
 $objPHPExcel->getActiveSheet()->setCellValue('A10', 'Average of both ranges:');
 $objPHPExcel->getActiveSheet()->setCellValue('B10', '=AVERAGE(B2:C4)');
-echo date('H:i:s') , " Average value of both Ranges is " ,
-                     $objPHPExcel->getActiveSheet()->getCell('B10')->getCalculatedValue() , EOL;
+echo date('H:i:s'), " Average value of both Ranges is ",
+                     $objPHPExcel->getActiveSheet()->getCell('B10')->getCalculatedValue(), EOL;
 
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Formulas');
 
 
@@ -103,7 +103,7 @@  discard block
 block discarded – undo
 
 
 // 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');
@@ -120,14 +120,14 @@  discard block
 block discarded – undo
 $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');
@@ -135,15 +135,15 @@  discard block
 block discarded – undo
 $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;

Please login to merge, or discard this patch.

Examples/31docproperties_write-xls.php 1 patch

Spacing +32 added lines, -32 removed lines patch added patch discarded remove patch

@@ -30,7 +30,7 @@  discard block
 block discarded – undo
 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');
 
@@ -42,7 +42,7 @@  discard block
 block discarded – undo
 $inputFileName = 'templates/31docproperties.xls';
 
 
-echo date('H:i:s') , " Load Tests from $inputFileType file" , EOL;
+echo date('H:i:s'), " Load Tests from $inputFileType file", EOL;
 $callStartTime = microtime(true);
 
 $objPHPExcelReader = \PHPExcel\IOFactory::createReader($inputFileType);
@@ -50,12 +50,12 @@  discard block
 block discarded – undo
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
-echo date('H:i:s') , " Adjust properties" , EOL;
+echo date('H:i:s'), " Adjust properties", EOL;
 $objPHPExcel->getProperties()->setTitle("Office 95 XLS Test Document")
 							 ->setSubject("Office 95 XLS Test Document")
 							 ->setDescription("Test XLS document, generated using PHPExcel")
@@ -63,57 +63,57 @@  discard block
 block discarded – undo
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
 $objWriter->save(str_replace('.php', '.xls', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB", EOL;
 
 
 echo EOL;
 // Reread File
-echo date('H:i:s') , " Reread Excel5 file" , EOL;
+echo date('H:i:s'), " Reread Excel5 file", EOL;
 $objPHPExcelRead = \PHPExcel\IOFactory::load(str_replace('.php', '.xls', __FILE__));
 
 // Set properties
-echo date('H:i:s') , " Get properties" , EOL;
+echo date('H:i:s'), " Get properties", EOL;
 
-echo 'Core Properties:' , EOL;
-echo '    Created by - ' , $objPHPExcel->getProperties()->getCreator() , EOL;
-echo '    Created on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getCreated()) , ' at ' ,
-                       date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
-echo '    Last Modified by - ' , $objPHPExcel->getProperties()->getLastModifiedBy() , EOL;
-echo '    Last Modified on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getModified()) , ' at ' ,
-                             date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
-echo '    Title - ' , $objPHPExcel->getProperties()->getTitle() , EOL;
-echo '    Subject - ' , $objPHPExcel->getProperties()->getSubject() , EOL;
-echo '    Description - ' , $objPHPExcel->getProperties()->getDescription() , EOL;
-echo '    Keywords: - ' , $objPHPExcel->getProperties()->getKeywords() , EOL;
+echo 'Core Properties:', EOL;
+echo '    Created by - ', $objPHPExcel->getProperties()->getCreator(), EOL;
+echo '    Created on - ', date('d-M-Y', $objPHPExcel->getProperties()->getCreated()), ' at ',
+                       date('H:i:s', $objPHPExcel->getProperties()->getCreated()), EOL;
+echo '    Last Modified by - ', $objPHPExcel->getProperties()->getLastModifiedBy(), EOL;
+echo '    Last Modified on - ', date('d-M-Y', $objPHPExcel->getProperties()->getModified()), ' at ',
+                             date('H:i:s', $objPHPExcel->getProperties()->getModified()), EOL;
+echo '    Title - ', $objPHPExcel->getProperties()->getTitle(), EOL;
+echo '    Subject - ', $objPHPExcel->getProperties()->getSubject(), EOL;
+echo '    Description - ', $objPHPExcel->getProperties()->getDescription(), EOL;
+echo '    Keywords: - ', $objPHPExcel->getProperties()->getKeywords(), EOL;
 
 
-echo 'Extended (Application) Properties:' , EOL;
-echo '    Category - ' , $objPHPExcel->getProperties()->getCategory() , EOL;
-echo '    Company - ' , $objPHPExcel->getProperties()->getCompany() , EOL;
-echo '    Manager - ' , $objPHPExcel->getProperties()->getManager() , EOL;
+echo 'Extended (Application) Properties:', EOL;
+echo '    Category - ', $objPHPExcel->getProperties()->getCategory(), EOL;
+echo '    Company - ', $objPHPExcel->getProperties()->getCompany(), EOL;
+echo '    Manager - ', $objPHPExcel->getProperties()->getManager(), EOL;
 
 
-echo 'Custom Properties:' , EOL;
+echo 'Custom Properties:', EOL;
 $customProperties = $objPHPExcel->getProperties()->getCustomProperties();
-foreach($customProperties as $customProperty) {
+foreach ($customProperties as $customProperty) {
 	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
 	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
-	echo '    ' , $customProperty , ' - (' , $propertyType , ') - ';
+	echo '    ', $customProperty, ' - (', $propertyType, ') - ';
 	if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
-		echo date('d-M-Y H:i:s',$propertyValue) , EOL;
+		echo date('d-M-Y H:i:s', $propertyValue), EOL;
 	} elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
-		echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
+		echo (($propertyValue) ? 'TRUE' : 'FALSE'), EOL;
 	} else {
-		echo $propertyValue , EOL;
+		echo $propertyValue, 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;

Please login to merge, or discard this patch.

Examples/24readfilter.php 1 patch

Spacing +9 added lines, -9 removed lines patch added patch discarded remove patch

@@ -29,7 +29,7 @@  discard block
 block discarded – undo
 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');
 
@@ -55,23 +55,23 @@  discard block
 block discarded – undo
 }
 
 
-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load from Excel2007 file", EOL;
 $objReader = \PHPExcel\IOFactory::createReader('Excel2007');
-$objReader->setReadFilter( new MyReadFilter() );
+$objReader->setReadFilter(new MyReadFilter());
 $objPHPExcel = $objReader->load("06largescale.xlsx");
 
-echo date('H:i:s') , " Remove unnecessary rows" , EOL;
+echo date('H:i:s'), " Remove unnecessary rows", EOL;
 $objPHPExcel->getActiveSheet()->removeRow(2, 18);
 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing 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;

Please login to merge, or discard this patch.

Build/PharStub.php 1 patch

Spacing +1 added lines, -1 removed lines patch added patch discarded remove patch

@@ -1,5 +1,5 @@
 block discarded – undo
 <?php
-spl_autoload_register(function ($class) {
+spl_autoload_register(function($class) {
     include 'phar://PHPExcel/' . str_replace('_', '/', $class) . '.php';
 });
 

Please login to merge, or discard this patch.

Documentation/Examples/Calculations/Database/DVARP.php 1 patch

Spacing +18 added lines, -18 removed lines patch added patch discarded remove patch

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The variance in the yield of Apple and Pear trees');
 $worksheet->setCellValue('B12', '=DVARP(A4:E10,"Yield",A1:A3)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -70,18 +70,18 @@  discard block
 block discarded – undo
 // Test the formulae
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DVARP() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

Documentation/Examples/Calculations/Database/DMIN.php 1 patch

Spacing +17 added lines, -17 removed lines patch added patch discarded remove patch

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The shortest tree in the orchard');
 $worksheet->setCellValue('B12', '=DMIN(A4:E10,"Height",A4:E10)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -72,15 +72,15 @@  discard block
 block discarded – undo
 
 echo 'ALL' . '<br /><br />';
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DMIN() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DMIN() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DMIN() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

		@@ -30,7 +30,7 @@ discard block
		block discarded – undo
30	30	ini_set('display_errors', TRUE);
31	31	ini_set('display_startup_errors', TRUE);
32	32
33		-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
	33	+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
34	34
35	35	date_default_timezone_set('Europe/London');
36	36
		@@ -38,11 +38,11 @@ discard block
		block discarded – undo
38	38	require_once dirname(__FILE__) . '/../src/Bootstrap.php';
39	39
40	40	// Create new PHPExcel object
41		-echo date('H:i:s').' Create new PHPExcel object'.EOL;
	41	+echo date('H:i:s') . ' Create new PHPExcel object' . EOL;
42	42	$objPHPExcel = new \PHPExcel\Spreadsheet();
43	43
44	44	// Set document properties
45		-echo date('H:i:s').' Set document properties'.EOL;
	45	+echo date('H:i:s') . ' Set document properties' . EOL;
46	46	$objPHPExcel->getProperties()->setCreator('Maarten Balliauw')
47	47	->setLastModifiedBy('Maarten Balliauw')
48	48	->setTitle('PHPExcel Test Document')
		@@ -52,78 +52,78 @@ discard block
		block discarded – undo
52	52	->setCategory('Test result file');
53	53
54	54	// Create the worksheet
55		-echo date('H:i:s').' Add data'.EOL;
	55	+echo date('H:i:s') . ' Add data' . EOL;
56	56	$objPHPExcel->setActiveSheetIndex(0);
57	57	$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Year')
58	58	->setCellValue('B1', 'Quarter')
59	59	->setCellValue('C1', 'Country')
60	60	->setCellValue('D1', 'Sales');
61	61
62		-$dataArray = array(array('2010', 'Q1', 'United States', 790),
63		- array('2010', 'Q2', 'United States', 730),
64		- array('2010', 'Q3', 'United States', 860),
65		- array('2010', 'Q4', 'United States', 850),
66		- array('2011', 'Q1', 'United States', 800),
67		- array('2011', 'Q2', 'United States', 700),
68		- array('2011', 'Q3', 'United States', 900),
69		- array('2011', 'Q4', 'United States', 950),
70		- array('2010', 'Q1', 'Belgium', 380),
71		- array('2010', 'Q2', 'Belgium', 390),
72		- array('2010', 'Q3', 'Belgium', 420),
73		- array('2010', 'Q4', 'Belgium', 460),
74		- array('2011', 'Q1', 'Belgium', 400),
75		- array('2011', 'Q2', 'Belgium', 350),
76		- array('2011', 'Q3', 'Belgium', 450),
77		- array('2011', 'Q4', 'Belgium', 500),
78		- array('2010', 'Q1', 'UK', 690),
79		- array('2010', 'Q2', 'UK', 610),
80		- array('2010', 'Q3', 'UK', 620),
81		- array('2010', 'Q4', 'UK', 600),
82		- array('2011', 'Q1', 'UK', 720),
83		- array('2011', 'Q2', 'UK', 650),
84		- array('2011', 'Q3', 'UK', 580),
85		- array('2011', 'Q4', 'UK', 510),
86		- array('2010', 'Q1', 'France', 510),
87		- array('2010', 'Q2', 'France', 490),
88		- array('2010', 'Q3', 'France', 460),
89		- array('2010', 'Q4', 'France', 590),
90		- array('2011', 'Q1', 'France', 620),
91		- array('2011', 'Q2', 'France', 650),
92		- array('2011', 'Q3', 'France', 415),
93		- array('2011', 'Q4', 'France', 570),
94		- array('2010', 'Q1', 'Germany', 720),
95		- array('2010', 'Q2', 'Germany', 680),
96		- array('2010', 'Q3', 'Germany', 640),
97		- array('2010', 'Q4', 'Germany', 660),
98		- array('2011', 'Q1', 'Germany', 680),
99		- array('2011', 'Q2', 'Germany', 620),
100		- array('2011', 'Q3', 'Germany', 710),
101		- array('2011', 'Q4', 'Germany', 690),
102		- array('2010', 'Q1', 'Spain', 510),
103		- array('2010', 'Q2', 'Spain', 490),
104		- array('2010', 'Q3', 'Spain', 470),
105		- array('2010', 'Q4', 'Spain', 420),
106		- array('2011', 'Q1', 'Spain', 460),
107		- array('2011', 'Q2', 'Spain', 390),
108		- array('2011', 'Q3', 'Spain', 430),
109		- array('2011', 'Q4', 'Spain', 415),
110		- array('2010', 'Q1', 'Italy', 440),
111		- array('2010', 'Q2', 'Italy', 410),
112		- array('2010', 'Q3', 'Italy', 420),
113		- array('2010', 'Q4', 'Italy', 450),
114		- array('2011', 'Q1', 'Italy', 430),
115		- array('2011', 'Q2', 'Italy', 370),
116		- array('2011', 'Q3', 'Italy', 350),
117		- array('2011', 'Q4', 'Italy', 335),
	62	+$dataArray = array(array('2010', 'Q1', 'United States', 790),
	63	+ array('2010', 'Q2', 'United States', 730),
	64	+ array('2010', 'Q3', 'United States', 860),
	65	+ array('2010', 'Q4', 'United States', 850),
	66	+ array('2011', 'Q1', 'United States', 800),
	67	+ array('2011', 'Q2', 'United States', 700),
	68	+ array('2011', 'Q3', 'United States', 900),
	69	+ array('2011', 'Q4', 'United States', 950),
	70	+ array('2010', 'Q1', 'Belgium', 380),
	71	+ array('2010', 'Q2', 'Belgium', 390),
	72	+ array('2010', 'Q3', 'Belgium', 420),
	73	+ array('2010', 'Q4', 'Belgium', 460),
	74	+ array('2011', 'Q1', 'Belgium', 400),
	75	+ array('2011', 'Q2', 'Belgium', 350),
	76	+ array('2011', 'Q3', 'Belgium', 450),
	77	+ array('2011', 'Q4', 'Belgium', 500),
	78	+ array('2010', 'Q1', 'UK', 690),
	79	+ array('2010', 'Q2', 'UK', 610),
	80	+ array('2010', 'Q3', 'UK', 620),
	81	+ array('2010', 'Q4', 'UK', 600),
	82	+ array('2011', 'Q1', 'UK', 720),
	83	+ array('2011', 'Q2', 'UK', 650),
	84	+ array('2011', 'Q3', 'UK', 580),
	85	+ array('2011', 'Q4', 'UK', 510),
	86	+ array('2010', 'Q1', 'France', 510),
	87	+ array('2010', 'Q2', 'France', 490),
	88	+ array('2010', 'Q3', 'France', 460),
	89	+ array('2010', 'Q4', 'France', 590),
	90	+ array('2011', 'Q1', 'France', 620),
	91	+ array('2011', 'Q2', 'France', 650),
	92	+ array('2011', 'Q3', 'France', 415),
	93	+ array('2011', 'Q4', 'France', 570),
	94	+ array('2010', 'Q1', 'Germany', 720),
	95	+ array('2010', 'Q2', 'Germany', 680),
	96	+ array('2010', 'Q3', 'Germany', 640),
	97	+ array('2010', 'Q4', 'Germany', 660),
	98	+ array('2011', 'Q1', 'Germany', 680),
	99	+ array('2011', 'Q2', 'Germany', 620),
	100	+ array('2011', 'Q3', 'Germany', 710),
	101	+ array('2011', 'Q4', 'Germany', 690),
	102	+ array('2010', 'Q1', 'Spain', 510),
	103	+ array('2010', 'Q2', 'Spain', 490),
	104	+ array('2010', 'Q3', 'Spain', 470),
	105	+ array('2010', 'Q4', 'Spain', 420),
	106	+ array('2011', 'Q1', 'Spain', 460),
	107	+ array('2011', 'Q2', 'Spain', 390),
	108	+ array('2011', 'Q3', 'Spain', 430),
	109	+ array('2011', 'Q4', 'Spain', 415),
	110	+ array('2010', 'Q1', 'Italy', 440),
	111	+ array('2010', 'Q2', 'Italy', 410),
	112	+ array('2010', 'Q3', 'Italy', 420),
	113	+ array('2010', 'Q4', 'Italy', 450),
	114	+ array('2011', 'Q1', 'Italy', 430),
	115	+ array('2011', 'Q2', 'Italy', 370),
	116	+ array('2011', 'Q3', 'Italy', 350),
	117	+ array('2011', 'Q4', 'Italy', 335),
118	118	);
119	119	$objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A2');
120	120
121	121	// Set title row bold
122		-echo date('H:i:s').' Set title row bold'.EOL;
	122	+echo date('H:i:s') . ' Set title row bold' . EOL;
123	123	$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setBold(true);
124	124
125	125	// Set autofilter
126		-echo date('H:i:s').' Set autofilter'.EOL;
	126	+echo date('H:i:s') . ' Set autofilter' . EOL;
127	127	// Always include the complete filter range!
128	128	// Excel does support setting only the caption
129	129	// row, but that's not a best practise...
		@@ -134,7 +134,7 @@ discard block
		block discarded – undo
134	134
135	135
136	136	// Save Excel 2007 file
137		-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
	137	+echo date('H:i:s'), " Write to Excel2007 format", EOL;
138	138	$callStartTime = microtime(true);
139	139
140	140	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
		@@ -142,14 +142,14 @@ discard block
		block discarded – undo
142	142	$callEndTime = microtime(true);
143	143	$callTime = $callEndTime - $callStartTime;
144	144
145		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
146		-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	145	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
	146	+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
147	147	// Echo memory usage
148		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	148	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
149	149
150	150
151	151	// Save Excel 95 file
152		-echo date('H:i:s') , " Write to Excel5 format" , EOL;
	152	+echo date('H:i:s'), " Write to Excel5 format", EOL;
153	153	$callStartTime = microtime(true);
154	154
155	155	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
		@@ -157,15 +157,15 @@ discard block
		block discarded – undo
157	157	$callEndTime = microtime(true);
158	158	$callTime = $callEndTime - $callStartTime;
159	159
160		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
161		-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	160	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
	161	+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
162	162	// Echo memory usage
163		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	163	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
164	164
165	165
166	166	// Echo memory peak usage
167		-echo date('H:i:s').' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB'.EOL;
	167	+echo date('H:i:s') . ' Peak memory usage: ' . (memory_get_peak_usage(true) / 1024 / 1024) . ' MB' . EOL;
168	168
169	169	// Echo done
170		-echo date('H:i:s').' Done writing files'.EOL;
171		-echo 'Files have been created in ' , getcwd() , EOL;
	170	+echo date('H:i:s') . ' Done writing files' . EOL;
	171	+echo 'Files have been created in ', getcwd(), EOL;

		@@ -29,7 +29,7 @@ discard block
		block discarded – undo
29	29	ini_set('display_errors', TRUE);
30	30	ini_set('display_startup_errors', TRUE);
31	31
32		-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
	32	+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
33	33
34	34	date_default_timezone_set('Europe/London');
35	35
		@@ -37,38 +37,38 @@ discard block
		block discarded – undo
37	37	require_once dirname(__FILE__) . '/../src/Bootstrap.php';
38	38
39	39
40		-echo date('H:i:s') , " Load MergeBook1 from Excel2007 file" , EOL;
	40	+echo date('H:i:s'), " Load MergeBook1 from Excel2007 file", EOL;
41	41	$callStartTime = microtime(true);
42	42
43	43	$objPHPExcel1 = \PHPExcel\IOFactory::load(dirname(__FILE__) . "/templates/43mergeBook1.xlsx");
44	44
45	45	$callEndTime = microtime(true);
46	46	$callTime = $callEndTime - $callStartTime;
47		-echo 'Call time to read Mergebook1 was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	47	+echo 'Call time to read Mergebook1 was ', sprintf('%.4f', $callTime), " seconds", EOL;
48	48	// Echo memory usage
49		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	49	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
50	50
51	51
52		-echo date('H:i:s') , " Load MergeBook2 from Excel2007 file" , EOL;
	52	+echo date('H:i:s'), " Load MergeBook2 from Excel2007 file", EOL;
53	53	$callStartTime = microtime(true);
54	54
55	55	$objPHPExcel2 = \PHPExcel\IOFactory::load(dirname(__FILE__) . "/templates/43mergeBook2.xlsx");
56	56
57	57	$callEndTime = microtime(true);
58	58	$callTime = $callEndTime - $callStartTime;
59		-echo 'Call time to read Mergebook2 was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	59	+echo 'Call time to read Mergebook2 was ', sprintf('%.4f', $callTime), " seconds", EOL;
60	60	// Echo memory usage
61		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	61	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
62	62
63	63
64		-foreach($objPHPExcel2->getSheetNames() as $sheetName) {
	64	+foreach ($objPHPExcel2->getSheetNames() as $sheetName) {
65	65	$sheet = $objPHPExcel2->getSheetByName($sheetName);
66	66	$sheet->setTitle($sheet->getTitle() . ' copied');
67	67	$objPHPExcel1->addExternalSheet($sheet);
68	68	}
69	69
70	70
71		-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
	71	+echo date('H:i:s'), " Write to Excel2007 format", EOL;
72	72	$callStartTime = microtime(true);
73	73
74	74	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel1, 'Excel2007');
		@@ -77,15 +77,15 @@ discard block
		block discarded – undo
77	77	$callEndTime = microtime(true);
78	78	$callTime = $callEndTime - $callStartTime;
79	79
80		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
81		-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	80	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
	81	+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
82	82	// Echo memory usage
83		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	83	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
84	84
85	85
86	86	// Echo memory peak usage
87		-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
	87	+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
88	88
89	89	// Echo done
90		-echo date('H:i:s') , " Done writing file" , EOL;
91		-echo 'File has been created in ' , getcwd() , EOL;
	90	+echo date('H:i:s'), " Done writing file", EOL;
	91	+echo 'File has been created in ', getcwd(), EOL;

		@@ -31,18 +31,18 @@ discard block
		block discarded – undo
31	31	ini_set('display_startup_errors', TRUE);
32	32	date_default_timezone_set('Europe/London');
33	33
34		-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
	34	+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
35	35
36	36	/** Include PHPExcel */
37	37	require_once dirname(__FILE__) . '/../src/Bootstrap.php';
38	38
39	39
40	40	// Create new PHPExcel object
41		-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
	41	+echo date('H:i:s'), " Create new PHPExcel object", EOL;
42	42	$objPHPExcel = new \PHPExcel\Spreadsheet();
43	43
44	44	// Set document properties
45		-echo date('H:i:s') , " Set document properties" , EOL;
	45	+echo date('H:i:s'), " Set document properties", EOL;
46	46	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
47	47	->setLastModifiedBy("Maarten Balliauw")
48	48	->setTitle("Office 2007 XLSX Test Document")
		@@ -53,7 +53,7 @@ discard block
		block discarded – undo
53	53
54	54
55	55	// Add some data, we will use some formulas here
56		-echo date('H:i:s') , " Add some data" , EOL;
	56	+echo date('H:i:s'), " Add some data", EOL;
57	57	$objPHPExcel->getActiveSheet()->setCellValue('A5', 'Sum:');
58	58
59	59	$objPHPExcel->getActiveSheet()->setCellValue('B1', 'Range #1')
		@@ -61,40 +61,40 @@ discard block
		block discarded – undo
61	61	->setCellValue('B3', 7)
62	62	->setCellValue('B4', 13)
63	63	->setCellValue('B5', '=SUM(B2:B4)');
64		-echo date('H:i:s') , " Sum of Range #1 is " ,
65		- $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue() , EOL;
	64	+echo date('H:i:s'), " Sum of Range #1 is ",
	65	+ $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue(), EOL;
66	66
67	67	$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Range #2')
68	68	->setCellValue('C2', 5)
69	69	->setCellValue('C3', 11)
70	70	->setCellValue('C4', 17)
71	71	->setCellValue('C5', '=SUM(C2:C4)');
72		-echo date('H:i:s') , " Sum of Range #2 is " ,
73		- $objPHPExcel->getActiveSheet()->getCell('C5')->getCalculatedValue() , EOL;
	72	+echo date('H:i:s'), " Sum of Range #2 is ",
	73	+ $objPHPExcel->getActiveSheet()->getCell('C5')->getCalculatedValue(), EOL;
74	74
75	75	$objPHPExcel->getActiveSheet()->setCellValue('A7', 'Total of both ranges:');
76	76	$objPHPExcel->getActiveSheet()->setCellValue('B7', '=SUM(B5:C5)');
77		-echo date('H:i:s') , " Sum of both Ranges is " ,
78		- $objPHPExcel->getActiveSheet()->getCell('B7')->getCalculatedValue() , EOL;
	77	+echo date('H:i:s'), " Sum of both Ranges is ",
	78	+ $objPHPExcel->getActiveSheet()->getCell('B7')->getCalculatedValue(), EOL;
79	79
80	80	$objPHPExcel->getActiveSheet()->setCellValue('A8', 'Minimum of both ranges:');
81	81	$objPHPExcel->getActiveSheet()->setCellValue('B8', '=MIN(B2:C4)');
82		-echo date('H:i:s') , " Minimum value in either Range is " ,
83		- $objPHPExcel->getActiveSheet()->getCell('B8')->getCalculatedValue() , EOL;
	82	+echo date('H:i:s'), " Minimum value in either Range is ",
	83	+ $objPHPExcel->getActiveSheet()->getCell('B8')->getCalculatedValue(), EOL;
84	84
85	85	$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Maximum of both ranges:');
86	86	$objPHPExcel->getActiveSheet()->setCellValue('B9', '=MAX(B2:C4)');
87		-echo date('H:i:s') , " Maximum value in either Range is " ,
88		- $objPHPExcel->getActiveSheet()->getCell('B9')->getCalculatedValue() , EOL;
	87	+echo date('H:i:s'), " Maximum value in either Range is ",
	88	+ $objPHPExcel->getActiveSheet()->getCell('B9')->getCalculatedValue(), EOL;
89	89
90	90	$objPHPExcel->getActiveSheet()->setCellValue('A10', 'Average of both ranges:');
91	91	$objPHPExcel->getActiveSheet()->setCellValue('B10', '=AVERAGE(B2:C4)');
92		-echo date('H:i:s') , " Average value of both Ranges is " ,
93		- $objPHPExcel->getActiveSheet()->getCell('B10')->getCalculatedValue() , EOL;
	92	+echo date('H:i:s'), " Average value of both Ranges is ",
	93	+ $objPHPExcel->getActiveSheet()->getCell('B10')->getCalculatedValue(), EOL;
94	94
95	95
96	96	// Rename worksheet
97		-echo date('H:i:s') , " Rename worksheet" , EOL;
	97	+echo date('H:i:s'), " Rename worksheet", EOL;
98	98	$objPHPExcel->getActiveSheet()->setTitle('Formulas');
99	99
100	100
		@@ -103,7 +103,7 @@ discard block
		block discarded – undo
103	103
104	104
105	105	// Save Excel 2007 file
106		-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
	106	+echo date('H:i:s'), " Write to Excel2007 format", EOL;
107	107	$callStartTime = microtime(true);
108	108
109	109	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
		@@ -120,14 +120,14 @@ discard block
		block discarded – undo
120	120	$callEndTime = microtime(true);
121	121	$callTime = $callEndTime - $callStartTime;
122	122
123		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
124		-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	123	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
	124	+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
125	125	// Echo memory usage
126		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	126	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
127	127
128	128
129	129	// Save Excel 95 file
130		-echo date('H:i:s') , " Write to Excel5 format" , EOL;
	130	+echo date('H:i:s'), " Write to Excel5 format", EOL;
131	131	$callStartTime = microtime(true);
132	132
133	133	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
		@@ -135,15 +135,15 @@ discard block
		block discarded – undo
135	135	$callEndTime = microtime(true);
136	136	$callTime = $callEndTime - $callStartTime;
137	137
138		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
139		-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	138	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
	139	+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
140	140	// Echo memory usage
141		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	141	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
142	142
143	143
144	144	// Echo memory peak usage
145		-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
	145	+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
146	146
147	147	// Echo done
148		-echo date('H:i:s') , " Done writing files" , EOL;
149		-echo 'Files have been created in ' , getcwd() , EOL;
	148	+echo date('H:i:s'), " Done writing files", EOL;
	149	+echo 'Files have been created in ', getcwd(), EOL;

		@@ -1,5 +1,5 @@
		block discarded – undo
1	1	<?php
2		-spl_autoload_register(function ($class) {
	2	+spl_autoload_register(function($class) {
3	3	include 'phar://PHPExcel/' . str_replace('_', '/', $class) . '.php';
4	4	});
5	5

		@@ -32,21 +32,21 @@ discard block
		block discarded – undo
32	32	$worksheet = $objPHPExcel->getActiveSheet();
33	33
34	34	// Add some data
35		-$database = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit' ),
36		- array( 'Apple', 18, 20, 14, 105.00 ),
37		- array( 'Pear', 12, 12, 10, 96.00 ),
38		- array( 'Cherry', 13, 14, 9, 105.00 ),
39		- array( 'Apple', 14, 15, 10, 75.00 ),
40		- array( 'Pear', 9, 8, 8, 76.80 ),
41		- array( 'Apple', 8, 9, 6, 45.00 ),
	35	+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
	36	+ array('Apple', 18, 20, 14, 105.00),
	37	+ array('Pear', 12, 12, 10, 96.00),
	38	+ array('Cherry', 13, 14, 9, 105.00),
	39	+ array('Apple', 14, 15, 10, 75.00),
	40	+ array('Pear', 9, 8, 8, 76.80),
	41	+ array('Apple', 8, 9, 6, 45.00),
42	42	);
43		-$criteria = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44		- array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
45		- array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	43	+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
	44	+ array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
	45	+ array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46	46	);
47	47
48		-$worksheet->fromArray( $criteria, NULL, 'A1' );
49		-$worksheet->fromArray( $database, NULL, 'A4' );
	48	+$worksheet->fromArray($criteria, NULL, 'A1');
	49	+$worksheet->fromArray($database, NULL, 'A4');
50	50
51	51	$worksheet->setCellValue('A12', 'The variance in the yield of Apple and Pear trees');
52	52	$worksheet->setCellValue('B12', '=DVARP(A4:E10,"Yield",A1:A3)');
		@@ -60,7 +60,7 @@ discard block
		block discarded – undo
60	60
61	61	echo '<h4>Database</h4>';
62	62
63		-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
	63	+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64	64	var_dump($databaseData);
65	65
66	66
		@@ -70,18 +70,18 @@ discard block
		block discarded – undo
70	70	// Test the formulae
71	71	echo '<h4>Criteria</h4>';
72	72
73		-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
	73	+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
74	74	var_dump($criteriaData);
75	75
76		-echo $worksheet->getCell("A12")->getValue() .'<br />';
77		-echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
	76	+echo $worksheet->getCell("A12")->getValue() . '<br />';
	77	+echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78	78
79	79	echo '<h4>Criteria</h4>';
80	80
81		-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
	81	+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82	82	var_dump($criteriaData);
83	83
84		-echo $worksheet->getCell("A13")->getValue() .'<br />';
	84	+echo $worksheet->getCell("A13")->getValue() . '<br />';
85	85	echo 'DVARP() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86	86
87	87

PHPOffice / PhpSpreadsheet

Push — develop ( 685e29...09d456 )

Status

Category

Spacing +73 added lines, -73 removed lines patch added patch discarded remove patch

Spacing +7 added lines, -7 removed lines patch added patch discarded remove patch

Spacing +15 added lines, -15 removed lines patch added patch discarded remove patch

Spacing +28 added lines, -28 removed lines patch added patch discarded remove patch

Spacing +32 added lines, -32 removed lines patch added patch discarded remove patch

Spacing +9 added lines, -9 removed lines patch added patch discarded remove patch

Spacing +1 added lines, -1 removed lines patch added patch discarded remove patch

Spacing +18 added lines, -18 removed lines patch added patch discarded remove patch

Spacing +17 added lines, -17 removed lines patch added patch discarded remove patch