PHPOffice / PhpSpreadsheet

Examples/28iterator.php

Indentation +12 added lines, -12 removed lines

@@ -38,7 +38,7 @@ 
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;
@@ -47,19 +47,19 @@ 
 
 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;
+    foreach ($worksheet->getRowIterator() as $row) {
+        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;
-			}
-		}
-	}
+        $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;
+            }
+        }
+    }
 }
 
 

Spacing +7 added lines, -7 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');
 
@@ -41,22 +41,22 @@ 
 	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 @@ 
 
 
 // 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;

Examples/43mergeWorkbooks.php

Spacing +15 added lines, -15 removed lines

@@ -29,7 +29,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -37,38 +37,38 @@ 
 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 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/03formulas.php

Indentation +20 added lines, -20 removed lines

@@ -44,12 +44,12 @@ 
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("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, we will use some formulas here
@@ -57,40 +57,40 @@ 
 $objPHPExcel->getActiveSheet()->setCellValue('A5', 'Sum:');
 
 $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Range #1')
-                              ->setCellValue('B2', 3)
-                              ->setCellValue('B3', 7)
-                              ->setCellValue('B4', 13)
-                              ->setCellValue('B5', '=SUM(B2:B4)');
+                                ->setCellValue('B2', 3)
+                                ->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;
+                        $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)');
+                                ->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;
+                        $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;
+                        $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;
+                        $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;
+                        $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;
+                        $objPHPExcel->getActiveSheet()->getCell('B10')->getCalculatedValue() , EOL;
 
 
 // Rename worksheet

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 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 @@ 
 
 
 // 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 @@ 
                               ->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 @@ 
 
 
 // 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 @@ 
 $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 @@ 
 $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/31docproperties_write-xls.php

Indentation +15 added lines, -15 removed lines

@@ -57,9 +57,9 @@ 
 

 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")

-							 ->setKeywords("office 95 biff php");

+                                ->setSubject("Office 95 XLS Test Document")

+                                ->setDescription("Test XLS document, generated using PHPExcel")

+                                ->setKeywords("office 95 biff php");

 

 

 // Save Excel 95 file

@@ -84,10 +84,10 @@ 
 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;

+                        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;

+                                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;

@@ -103,16 +103,16 @@ 
 echo 'Custom Properties:' , EOL;

 $customProperties = $objPHPExcel->getProperties()->getCustomProperties();

 foreach($customProperties as $customProperty) {

-	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);

-	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);

-	echo '    ' , $customProperty , ' - (' , $propertyType , ') - ';

-	if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {

-		echo date('d-M-Y H:i:s',$propertyValue) , EOL;

-	} elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {

-		echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;

-	} else {

-		echo $propertyValue , EOL;

-	}

+    $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);

+    $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);

+    echo '    ' , $customProperty , ' - (' , $propertyType , ') - ';

+    if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {

+        echo date('d-M-Y H:i:s',$propertyValue) , EOL;

+    } elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {

+        echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;

+    } else {

+        echo $propertyValue , EOL;

+    }

 }

 

 // Echo memory peak usage

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

 

@@ -42,7 +42,7 @@ 
 $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 @@ 
 

 $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 @@ 
 

 

 // 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;

Examples/24readfilter.php

Indentation +8 added lines, -8 removed lines

@@ -39,19 +39,19 @@
 
 // Check prerequisites
 if (!file_exists("06largescale.xlsx")) {
-	exit("Please run 06largescale.php first.\n");
+    exit("Please run 06largescale.php first.\n");
 }
 
 class MyReadFilter implements \PHPExcel\Reader\IReadFilter
 {
-	public function readCell($column, $row, $worksheetName = '') {
-		// Read title row and rows 20 - 30
-		if ($row == 1 || ($row >= 20 && $row <= 30)) {
-			return true;
-		}
+    public function readCell($column, $row, $worksheetName = '') {
+        // Read title row and rows 20 - 30
+        if ($row == 1 || ($row >= 20 && $row <= 30)) {
+            return true;
+        }
 
-		return false;
-	}
+        return false;
+    }
 }
 
 

Spacing +9 added lines, -9 removed lines

@@ -29,7 +29,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -55,23 +55,23 @@ 
 }
 
 
-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;

Build/PharStub.php

Spacing +1 added lines, -1 removed lines

@@ -1,5 +1,5 @@
 <?php

-spl_autoload_register(function ($class) {

+spl_autoload_register(function($class) {

     include 'phar://PHPExcel/' . str_replace('_', '/', $class) . '.php';

 });

 

Documentation/Examples/Calculations/Database/DVARP.php

Spacing +18 added lines, -18 removed lines

@@ -32,21 +32,21 @@ 
 $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 @@ 
 

 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 @@ 
 // 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();

 

 

Indentation +10 added lines, -10 removed lines

@@ -33,17 +33,17 @@
 

 // 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  ),

-                 );

+                    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     )

-                 );

+                    array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

+                    array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+                    );

 

 $worksheet->fromArray( $criteria, NULL, 'A1' );

 $worksheet->fromArray( $database, NULL, 'A4' );

Documentation/Examples/Calculations/Database/DMIN.php

Spacing +17 added lines, -17 removed lines

@@ -32,21 +32,21 @@ 
 $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 @@ 
 

 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 @@ 
 

 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();

 

 

Indentation +10 added lines, -10 removed lines

@@ -33,17 +33,17 @@
 

 // 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  ),

-                 );

+                    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     )

-                 );

+                    array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

+                    array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+                    );

 

 $worksheet->fromArray( $criteria, NULL, 'A1' );

 $worksheet->fromArray( $database, NULL, 'A4' );

Documentation/Examples/Calculations/Database/DVAR.php

Spacing +18 added lines, -18 removed lines

@@ -32,21 +32,21 @@ 
 $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 estimated variance in the yield of Apple and Pear trees');

 $worksheet->setCellValue('B12', '=DVAR(A4:E10,"Yield",A1:A3)');

@@ -60,7 +60,7 @@ 
 

 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 @@ 
 // 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 'DVAR() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';

+echo $worksheet->getCell("A12")->getValue() . '<br />';

+echo 'DVAR() 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 'DVAR() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();

 

 

Indentation +10 added lines, -10 removed lines

@@ -33,17 +33,17 @@
 

 // 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  ),

-                 );

+                    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     )

-                 );

+                    array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

+                    array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+                    );

 

 $worksheet->fromArray( $criteria, NULL, 'A1' );

 $worksheet->fromArray( $database, NULL, 'A4' );